Forum MYSQL errors
 

Hey guys, I get lots of emails from my server saying I have errors, wondering if anyone can help.

I have VB 4.3 the newest release, but this has been happening since 4.01

Database error in vBulletin 4.0.3:

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 thread AS thread
LEFT JOIN user 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(201,)
ORDER BY lastpost 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 ')
ORDER BY lastpost DESC
LIMIT 0, 10' at line 4
Error Number : 1064
Request Date : Wednesday, April 21st 2010 @ 05:36:35 AM
Error Date : Wednesday, April 21st 2010 @ 05:36:35 AM