PDA

View Full Version : vbulletin error when viewing a thread..


final kaoss
01-19-2010, 11:14 PM
Ok so when I goto view a thread it starts giving me this on random threads..

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT thread.threadid, thread.forumid, thread.title, thread.prefixid, thread.taglist, postusername, postuserid,
thread.lastpost, thread.replycount,
forum.title AS forumtitle
,post.pagetext AS preview


FROM thread AS thread
INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)



WHERE thread.threadid IN (15168, 4538, 350, 7330, 4068, 3470, 6003, 20954, 2668, ) AND thread.visible = 1



ORDER BY lastpost DESC;

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 thread.visible = 1



ORDER BY lastpost DESC' at line 13
Error Number : 1064
Request Date : Tuesday, January 19th 2010 @ 08:12:13 PM
Error Date : Tuesday, January 19th 2010 @ 08:12:13 PM
Script : http://vgchat.info/forum/showthread.php?t=21031
Referrer : http://vgchat.info/forum/forumdisplay.php?f=6
IP Address : -----------------------
Username : ---------------------
Classname : vB_Database
MySQL Version : 5.0.87-percona-highperf

What does it mean & how do I fix it?

Lynne
01-19-2010, 11:45 PM
Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

final kaoss
01-19-2010, 11:50 PM
Yep the error is still there after that. What I believe this error means is that somewhere some entries in a table got corrupted unreadable or whatever. I've checked, repaired, optimized and analyzed every last one of them in phpmyadmin but still some threads choose to do this (not all of them thank god)