vBulletin Database Error!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • marrr
    New Member
    • Nov 2007
    • 19

    vBulletin Database Error!

    Since I upgraded my forums to 3.8.4 I keep getting the following error.

    Database error in vBulletin 3.8.4:
    Invalid SQL:
    SELECT
    thread.forumid AS forumid, thread.visible,thread.lastposter, thread.prefixid, thread.title AS thread_title, thread.threadid as threadid, thread.attach AS attach,
    thread.taglist AS tag, thread.postusername AS username, thread.postuserid AS userid, thread.dateline AS date, views AS views, thread.replycount AS reply,
    thread.lastposter, forum.title AS forum_title, post.postid, post.pagetext AS pagetext, user.userid, user.username, user.usergroupid, icon.title AS icontitle,
    icon.iconpath, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
    FROM thread AS thread
    LEFT JOIN post AS post on (thread.firstpostid = post.postid)
    LEFT JOIN forum AS forum on (thread.forumid = forum.forumid)
    LEFT JOIN user AS user ON(user.userid = thread.postuserid)
    LEFT JOIN icon AS icon ON(icon.iconid = thread.iconid)
    WHERE thread.open ='1' AND thread.visible = '1' AND thread.forumid NOT IN(103,104,72,55,82,97,81,83,98,7,8,23,9,12,99,100,30,31,35,32,91,94,33,48,49,39,40,59,50, 29,95,74,27,) AND forum.forumid NOT IN(103,104,72,55,82,97,81,83,98,7,8,23,9,12,99,100,30,31,35,32,91,94,33,48,49,39,40,59,50, 29,95,74,27,)
    ORDER BY threadid DESC
    LIMIT 7;
    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 forum.forumid NOT IN(103,104,72,55,82,97,81,83,98,7,8,23,9,12,99,100,30,31' at line 11
    Error Number : 1064
    Request Date : Friday, October 2nd 2009 @ 03:00:33 PM
    Error Date : Friday, October 2nd 2009 @ 03:00:33 PM
    Script : http://xxxxx.net/forums/?f=16&page=2
    Referrer :
    IP Address : xx.xxx.xxx.xxx
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :

    I keep getting this error over and over again. Im guessing it has something to do with one of the plugins I have installed..
  • EvilAkuma
    Senior Member
    • Jan 2005
    • 322

    #2
    Do you have any modification before the installation?
    Shun Goku Satsu

    Comment

    • Steve Machol
      Former Customer Support Manager
      • Jul 2000
      • 154488

      #3
      SQL Syntax errors are almost always related to modified code.

      To troubleshoot this, first reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

      Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions


      [Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

      Next, disable all plugins.

      Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

      define('DISABLE_HOOKS', true);

      Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it.

      Do you have the same problem?
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment

      • marrr
        New Member
        • Nov 2007
        • 19

        #4
        Originally posted by EvilAkuma
        Do you have any modification before the installation?
        Before the upgrading yes.

        Comment

        • EvilAkuma
          Senior Member
          • Jan 2005
          • 322

          #5
          Please follow the instruction from Steve to resolve the issue. And see if you're still having the problem.
          Shun Goku Satsu

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...