getting this error when viewing a article and editing and adding.
PHP Code:
Database error in vBulletin 4.0.1:
Invalid SQL:
SELECT searchgroup.groupid, MATCH(searchgroup_text.title) AGAINST ('Article: Football Manager 2010 Review') AS score
FROM nzb_searchgroup AS searchgroup JOIN nzb_searchgroup_text AS searchgroup_text ON
(searchgroup.searchgroupid = searchgroup_text.searchgroupid)
WHERE MATCH(searchgroup_text.title) AGAINST ('Article: Football Manager 2010 Review') AND
searchgroup.contenttypeid =
HAVING score > 4
LIMIT 5;
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 'HAVING score > 4
LIMIT 5' at line 9
Error Number : 1064
Request Date : Wednesday, January 27th 2010 @ 06:41:56 PM
Error Date : Wednesday, January 27th 2010 @ 06:41:56 PM
Script : http://*link*/content.php?8-Football-Manager-2010-Review
Referrer : http://*link*/content.php
IP Address : 86.15.250.239
Username : Wolfe
Classname : vB_Database
MySQL Version : 5.0.45-community