Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
Register FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-27-2010, 09:44 PM
wolfe wolfe is offline
 
Join Date: Jan 2002
Posts: 900
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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 
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:20 PM.


Powered by vBulletin® Version 3.9.0
Copyright ©2000 - 2017, vBulletin Solutions Inc.