Adding new user bug

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • SFC
    Senior Member
    • Jan 2006
    • 109
    • 3.0.5

    Adding new user bug

    Database error in vBulletin 3.7.2:

    Invalid SQL:
    SHOW TABLE STATUS LIKE user';

    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 'user'' at line 1
    Error Number : 1064
    Request Date : Monday, September 1st 2008 @ 08:25:25 PM
    Error Date : Monday, September 1st 2008 @ 08:25:25 PM
    Script : http://www.bracesreview.com/forums/a....php?do=update
    Referrer : http://www.bracesreview.com/forums/a...ser.php?do=add
    IP Address : 74.236.92.157
    Username : admin
    Classname : vB_Database
    MySQL Version : 4.1.22-standard
    Last edited by SFC; Mon 1 Sep '08, 4:44pm.
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Invalid SQL 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

    • Pogo
      Senior Member
      • May 2001
      • 569

      #3
      This is most likely a bug in Photopost vBGallery 2.4.3 in the file includes/vbgallery/useradmin_update_data.php.

      Perhaps it is fixed here but I can't see the code.
      this is my sig

      Comment

      • appsfinder
        Member
        • Sep 2008
        • 46
        • 4.1.x

        #4
        thanks this link helped me

        Comment

        • warrior
          Senior Member
          • Apr 2002
          • 182

          #5
          Here is the solution about this I have try nowe whit this and Its work
          Last edited by Zachery; Sun 19 Oct '08, 4:34am. Reason: removed
          ccc

          Comment

          • Zachery
            Former vBulletin Support
            • Jul 2002
            • 59097

            #6
            If you need to you can provide a link to the issue on their website, but don't include third party code modificaitons here. Thank you.

            Comment

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