Out of nowhere! im in real trouble- Database problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sinjix_media
    Senior Member
    • Apr 2006
    • 199
    • 3.5.x

    Out of nowhere! im in real trouble- Database problem

    I got
    Code:
    Database error in vBulletin 3.5.4:
    
    Invalid SQL:
    SELECT user_table.userid AS userid, profile_fields.field30 AS wantquotenotify FROM user AS user_table LEFT JOIN userfield AS profile_fields ON (user_table.userid=profile_fields.userid) WHERE user_table.username='Stev'O' GROUP BY user_table.userid;
    
    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 'O' GROUP BY user_table.userid' at line 1
    Error Number : 1064
    Date         : Friday, April 21st 2006 @ 04:11:40 AM
    Script       : http://www.infitechdesign.com/forums/newreply.php
    Referrer     : 
    IP Address   : 69.112.44.220
    Username     : adobe_fan
    Classname    : vb_database
    out of nowhere. I made no changes to anything. I never got this message before when tryong to reply to a message.
    3D Resources - A list of resources for 3D Developers
    After Effects Resources - A list of resources for design in motion with Adobe After Effects
  • Zachery
    Former vBulletin Support
    • Jul 2002
    • 59097

    #2
    Hmm, weird, that users username has a single quote it in but the query didn't account for it...

    What version of vB are you running?

    Comment

    • sinjix_media
      Senior Member
      • Apr 2006
      • 199
      • 3.5.x

      #3
      3.5.4
      3D Resources - A list of resources for 3D Developers
      After Effects Resources - A list of resources for design in motion with Adobe After Effects

      Comment

      • Zachery
        Former vBulletin Support
        • Jul 2002
        • 59097

        #4
        You've got nothing like the mamob/joomla bridge? or hacks or addons?

        Comment

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

          #5
          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.
          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

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