wolfe |
01-27-2010 09:44 PM |
error on CMS edit, adding and viewing ?
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
|