sqzdog
02-09-2010, 08:30 PM
Hi everyone-
I keep getting SQL error email messages from my server and I can't figure out what is causing it. I run two 4.01 vbulletin sites that are both running the same modifications. Only one site is giving me these errors. Here's the content of the error:
Database error in vBulletin 4.0.1:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.postusername, thread.postuserid, thread.lastposter, thread.lastposterid, thread.dateline, thread.views, thread.visible, thread.open, user.usergroupid, user.displaygroupid
FROM vbthread AS thread
LEFT JOIN vbuser AS user ON (user.userid = thread.lastposterid)
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10' AND thread.forumid NOT IN(34,33,51,52,59,24,47,48,49,50,8,35,11,12,13,14, 15,58,37,38,60,)
ORDER BY lastpost DESC
LIMIT 0, 15;
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 ')
ORDER BY lastpost DESC
LIMIT 0, 15' at line 4
Error Number : 1064
Request Date : Tuesday, February 9th 2010 @ 05:19:51 PM
Error Date : Tuesday, February 9th 2010 @ 05:19:52 PM
Script : http://www.mysite.com/forums/forumdisplay.php?39-RSS-Feeds
Referrer :
IP Address :
Username : Unregistered
Classname : vB_Database
MySQL Version :
I keep getting SQL error email messages from my server and I can't figure out what is causing it. I run two 4.01 vbulletin sites that are both running the same modifications. Only one site is giving me these errors. Here's the content of the error:
Database error in vBulletin 4.0.1:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.postusername, thread.postuserid, thread.lastposter, thread.lastposterid, thread.dateline, thread.views, thread.visible, thread.open, user.usergroupid, user.displaygroupid
FROM vbthread AS thread
LEFT JOIN vbuser AS user ON (user.userid = thread.lastposterid)
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10' AND thread.forumid NOT IN(34,33,51,52,59,24,47,48,49,50,8,35,11,12,13,14, 15,58,37,38,60,)
ORDER BY lastpost DESC
LIMIT 0, 15;
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 ')
ORDER BY lastpost DESC
LIMIT 0, 15' at line 4
Error Number : 1064
Request Date : Tuesday, February 9th 2010 @ 05:19:51 PM
Error Date : Tuesday, February 9th 2010 @ 05:19:52 PM
Script : http://www.mysite.com/forums/forumdisplay.php?39-RSS-Feeds
Referrer :
IP Address :
Username : Unregistered
Classname : vB_Database
MySQL Version :