Forum MYSQL Search Error 1064
 

I just upgraded to vB 4.0.7. Within the first hour I've received 5 search errors, not quite sure why. Here is the error message:

Code:
Database error in vBulletin 4.0.7:

Invalid SQL:

SELECT searchcore.searchgroupid, searchgroup.dateline
FROM searchcore AS searchcore
JOIN searchcore_text AS searchcore_text ON (searchcore_text.searchcoreid = searchcore.searchcoreid)
JOIN searchgroup AS searchgroup ON (searchgroup.searchgroupid = searchcore.searchgroupid)
INNER JOIN thread AS thread ON (searchgroup.contenttypeid = 2 AND searchgroup.groupid = thread.threadid)

WHERE MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('CPS') AND () 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 ') LIMIT 500' at line 7
Error Number : 1064
Request Date : Sunday, September 26th 2010 @ 03:36:27 PM
Error Date : Sunday, September 26th 2010 @ 03:36:27 PM
Script : http://www.mysite.com/forums/search.php?do=process
Referrer : http://www.mysite.com/forums/showthr...44232&p=137879
IP Address : 184.97.196.176
Username : userman720
Classname : vB_Database
MySQL Version :