No announcement yet.

DB error

  • Filter
  • Time
  • Show
Clear All
new posts

  • DB error

    I have ti close hoke system and nowe I can create user from my admincp
    but why shuld I must close that ????
    are this bugg ?

    When I try to put in new user from the admin section I get this db error

    Invalid SQL:
    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

    plz howe shuld I fix this Issus ?
    Last edited by warrior; Sat 11th Oct '08, 2:04am.

  • #2
    If you mean the hook system?

    It will be one of the modifications that you have added that is breaking your forums.

    Try removing them or check for versions that match with your version of vbulletin.


    • #3
      Invalid SQL 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.