vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   General Hosting/Server Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=197)
-   -   Database Problem?? (https://vborg.vbsupport.ru/showthread.php?t=155073)

maxpain 08-13-2007 03:23 AM

Database Problem??
 
I recently moved servers and started receiving a lot of emails displaying the following error message:


Quote:

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE vbforum
SET replycount = replycount + 1,
threadcount = threadcount + 1,
lastpost = '1186966490',
lastposter = 'Data Banks',
lastthread = 'New Norndolls made :P',
lastthreadid = 105193
WHERE forumid IN ();

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 8
Error Number : 1064
Date : Sunday, August 12th 2007 @ 05:54:50 PM
Script : http://www.gamesforum.ca/cron.php?&rand=284747
Referrer : http://www.gamesforum.ca/showthread.php?t=103110
IP Address : 98.195.36.14
Username : Unregistered
Classname : vb_database
Plz list the steps that I need to do in order to get this error rectified. Am quite new to VB, any help will be appreciated.

regards
Max


All times are GMT. The time now is 07:28 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02336 seconds
  • Memory Usage 1,709KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete