mysql error number: 1064

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Vanhalen4041
    New Member
    • Apr 2003
    • 17

    mysql error number: 1064

    I get this Error In The Admin Cp When trying To Ban a User

    Database error in vBulletin Control Panel 2.3.0:

    Invalid SQL: SELECT userid
    FROM user
    WHERE username='Chattxxxx_Electxxx'
    AND 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 '' at line 4

    mysql error number: 1064

    Date: Wednesday 03rd of December 2003 12:49:45 AM
    Script: http://www.xxx-xxx.net/forum//forum/admin/user.php
    Referer: http://www.xxx-xxxx.net/forum/admin/...it&userid=1255
  • RandomLove
    Senior Member
    • Aug 2002
    • 246

    #2
    Sorry, but if you search for: error 1064 you'll find dozens of posts discussing this.

    Cheers.

    Comment

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

      #3
      Reupload the original user.php file from the 2.3.0 zip file. If you still have this problem then run this query in phpMyAdmin:

      REPAIR TABLE user;

      Note: The mysql error number is virtually worthless in troubleshooting problems.
      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...