Forum Really Annoying ERROR !!
 

Hi,

I'm continually getting the below error. This is emailed to my administration email at least 30-40 times a day.

It seems to appear when comebody has clicked the 'what's new' button on the navbar, or else when somebody searches for posts by a particular user, or latest posts.

If I 'Rebuild forum information' in update counters, the 'what's new' function seems to work for one click and then goes back to 'posts not found' or even a database error page.

This is really frustrating and I'm not sure what to do about it.

Very grateful for any help.

Here's the error:

-----------------------------------------------------------------------------------
Database error in vBulletin 4.0.0:

Invalid SQL:

SELECT thread.threadid
FROM thread AS thread

WHERE thread.forumid IN()
AND thread.lastpost >= 1262419129
AND thread.open 10
ORDER BY thread.lastpost desc
LIMIT 500;

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.lastpost >= 1262419129
AND thread.open 10
ORDER BY' at line 4
Error Number : 1064
Request Date : Sunday, January 3rd 2010 @ 08:58:49 AM
Error Date : Sunday, January 3rd 2010 @ 08:58:49 AM
Script : http://www.electricalforum.co.uk/search.php?do=getdaily
Referrer :
IP Address : 208.115.111.250
Username : Unregistered
Classname : vB_Database
MySQL Version :