Error when trying to delete dumb users..

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Paprika
    Senior Member
    • Jun 2002
    • 133

    Error when trying to delete dumb users..

    I was trying to prune out all the banned users on my forum and in the process got this error:

    Code:
    Database error in vBulletin 3.0.8:
    
    Invalid SQL: SELECT * FROM mos_users WHERE vb_userid = IN(2705,932,2327,2516,1006,398,830,2655,2518,2175,293,2521,1225,761,2603,2637,274,2519,2520,3035,2134,2135,2517,828,2515,2523,583,2522,1778,753,270,1041,1095,520,261,2184,2594,736,1257,2776,3071,1897,567,2039,2308,2793,2050)
    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 'IN(2705,932,2327,2516,1006,398,830,2655,2518,2175,293,2521,1225
    
    mysql error number: 1064
    
    Date: Sunday 06th of November 2005 12:29:47 AM
    Script: http://www.teen-moods.net/forums/admincp/user.php?do=prune_updateposts&startat=50
    Referer: http://www.teen-moods.net/forums/admincp/
    Username: Paprika
    IP Address: xxx.xxx.xxx.xxx
    I'm kinda urked about it because it done a few steps then crashed, now some data may be out of sync
  • Paprika
    Senior Member
    • Jun 2002
    • 133

    #2
    I'm sorry, maybe I haven't been reading the announcments but i assume support for the 3.0.x has been stopped?

    Comment

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

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