maxpain
08-13-2007, 03:23 AM
I recently moved servers and started receiving a lot of emails displaying the following error message:
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
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