No announcement yet.

3.5.3 to 3.5.4 db error

  • Filter
  • Time
  • Show
Clear All
new posts

  • 3.5.3 to 3.5.4 db error

    I recently upgraded from 3.5.3 to 3.5.4, shortly thereafter I started receiving the following e-mail notification.

    Database error in vBulletin 3.5.4:
    Invalid SQL:
     SELECT user.userid, user.usergroupid, username, email, activationid, user.languageid
     FROM vb351_user AS user
     LEFT JOIN vb351_useractivation AS useractivation ON (user.userid=useractivation.userid AND type = 0)
     WHERE user.usergroupid = 3
      AND ((joindate >= 1160633819 AND joindate <= 1160720219) OR (joindate >= 1160288219 AND joindate <= 1160374619))
      AND NOT (user.options & );
    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 ')' at line 6 Error Number : 1064
    Date         : Saturday, October 14th 2006 @ 12:17:00 AM
    Script       :
    Referrer     : 
    IP Address   : xxxxxxxxxxxx
    Username     : Unregistered
    Classname    : vb_database
    Thanks in advance for your assistance

  • #2
    SQL Syntax errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any hacks or plugins, then see if you still have this problem.

    If so, 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.

    Next, 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 changeto 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.


    • #3
      Thanks for such a prompt and detailed reply. I'll start with removing the plugins one by one and see which has the desired affect.


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