Got Error Number : 1064
 

Just received the following email from my Vbulletin
Please help and tell what to do...

Database error in vBulletin 3.8.7:

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 discuss_thread AS thread
INNER JOIN discuss_forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN discuss_post AS post ON (post.postid = thread.firstpostid)



WHERE thread.threadid IN (136, 175, 174, 134, 125, 274, 281, 235, 151, 156, 266, ) AND thread.visible = 1
AND forum.password = ''


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
AND forum.password = ''


ORDER BY lastpost ' at line 13
Error Number : 1064
Request Date : Wednesday, May 25th 2011 @ 03:07:04 AM
Error Date : Wednesday, May 25th 2011 @ 03:07:04 AM
Script : http://studychacha.com/discuss/279-a...ance-exam.html
Referrer :
IP Address : 66.249.71.42
Username : Unregistered
Classname : vB_Database
MySQL Version :

Try going to the admin control panel -> Maintenance -> Update Counters, and select "Rebuild Similar Threads".

Thanks for replying...

I did that but getting the same error.

Try it one more time, but set "Number of threads to process per cycle" to 300.

tried it twice .... but its still the same... :(

OK, try this: execute this SQL statement:

Done.... You rock dude...

thanks

--------------- Added [DATE]1306318139[/DATE] at [TIME]1306318139[/TIME] ---------------

Hello..
I am getting those errors again
now on URL

http://studychacha.com/discuss/292-t...ance-exam.html

and 2 more... isn't there a permanent solution for this?

I don't understand how that could happen, so I don't know what the fix is. It looks like that could only happen if there was a null threadid in the thread table, but that shouldn't be possible. ETA: Do you have any mods that affect similar threads?

You could turn off "Automatic Similar Thread Search" if it becomes a big problem - not a fix of course but at least your site will work.