Since I upgraded my forums to 3.8.4 I keep getting the following error.
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT
thread.forumid AS forumid, thread.visible,thread.lastposter, thread.prefixid, thread.title AS thread_title, thread.threadid as threadid, thread.attach AS attach,
thread.taglist AS tag, thread.postusername AS username, thread.postuserid AS userid, thread.dateline AS date, views AS views, thread.replycount AS reply,
thread.lastposter, forum.title AS forum_title, post.postid, post.pagetext AS pagetext, user.userid, user.username, user.usergroupid, icon.title AS icontitle,
icon.iconpath, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM thread AS thread
LEFT JOIN post AS post on (thread.firstpostid = post.postid)
LEFT JOIN forum AS forum on (thread.forumid = forum.forumid)
LEFT JOIN user AS user ON(user.userid = thread.postuserid)
LEFT JOIN icon AS icon ON(icon.iconid = thread.iconid)
WHERE thread.open ='1' AND thread.visible = '1' AND thread.forumid NOT IN(103,104,72,55,82,97,81,83,98,7,8,23,9,12,99,100,30,31,35,32,91,94,33,48,49,39,40,59,50, 29,95,74,27,) AND forum.forumid NOT IN(103,104,72,55,82,97,81,83,98,7,8,23,9,12,99,100,30,31,35,32,91,94,33,48,49,39,40,59,50, 29,95,74,27,)
ORDER BY threadid DESC
LIMIT 7;
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 ') AND forum.forumid NOT IN(103,104,72,55,82,97,81,83,98,7,8,23,9,12,99,100,30,31' at line 11
Error Number : 1064
Request Date : Friday, October 2nd 2009 @ 03:00:33 PM
Error Date : Friday, October 2nd 2009 @ 03:00:33 PM
Script : http://xxxxx.net/forums/?f=16&page=2
Referrer :
IP Address : xx.xxx.xxx.xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :
I keep getting this error over and over again. Im guessing it has something to do with one of the plugins I have installed..
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT
thread.forumid AS forumid, thread.visible,thread.lastposter, thread.prefixid, thread.title AS thread_title, thread.threadid as threadid, thread.attach AS attach,
thread.taglist AS tag, thread.postusername AS username, thread.postuserid AS userid, thread.dateline AS date, views AS views, thread.replycount AS reply,
thread.lastposter, forum.title AS forum_title, post.postid, post.pagetext AS pagetext, user.userid, user.username, user.usergroupid, icon.title AS icontitle,
icon.iconpath, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM thread AS thread
LEFT JOIN post AS post on (thread.firstpostid = post.postid)
LEFT JOIN forum AS forum on (thread.forumid = forum.forumid)
LEFT JOIN user AS user ON(user.userid = thread.postuserid)
LEFT JOIN icon AS icon ON(icon.iconid = thread.iconid)
WHERE thread.open ='1' AND thread.visible = '1' AND thread.forumid NOT IN(103,104,72,55,82,97,81,83,98,7,8,23,9,12,99,100,30,31,35,32,91,94,33,48,49,39,40,59,50, 29,95,74,27,) AND forum.forumid NOT IN(103,104,72,55,82,97,81,83,98,7,8,23,9,12,99,100,30,31,35,32,91,94,33,48,49,39,40,59,50, 29,95,74,27,)
ORDER BY threadid DESC
LIMIT 7;
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 ') AND forum.forumid NOT IN(103,104,72,55,82,97,81,83,98,7,8,23,9,12,99,100,30,31' at line 11
Error Number : 1064
Request Date : Friday, October 2nd 2009 @ 03:00:33 PM
Error Date : Friday, October 2nd 2009 @ 03:00:33 PM
Script : http://xxxxx.net/forums/?f=16&page=2
Referrer :
IP Address : xx.xxx.xxx.xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :
I keep getting this error over and over again. Im guessing it has something to do with one of the plugins I have installed..
Comment