Got Error Number : 1064

[mr1dul]

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 :

[kh99]

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

[mr1dul]

Thanks for replying...

I did that but getting the same error.

[kh99]

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

[mr1dul]

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

[kh99]

OK, try this: execute this SQL statement:

UPDATE discuss_thread set similar=('136, 175, 174, 134, 125, 274, 281, 235, 151, 156, 266') WHERE threadid = 279

[mr1dul]

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?

[kh99]

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.