| Astroman |
11-12-2007 10:20 PM |
Database error in vBulletin 3.6.8
I get this error from time to time, I think it's since I moved a bunch of threads and deleted some forums? I did update counters, but maybe I missed something. Any ideas how to fix it?
Thanks.
PHP Code:
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, thread.iconid, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM thread AS thread LEFT JOIN user AS user ON (user.username = thread.lastposter) WHERE NOT ISNULL(thread.threadid) AND thread.forumid NOT IN (0,) AND thread.visible <> 2
ORDER BY views DESC LIMIT 0, 10;
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 <> 2
ORDER BY views DESC LIMIT 0, 10' at line 2
Error Number : 1064
Date : Tuesday, November 13th 2007 @ 12:02:11 AM
Script : http://www.onlinebusinessboard.com/?f=16
Referrer :
IP Address : 66.249.72.18
Username : Unregistered
Classname : vb_database
|
More Information