No announcement yet.

Error when trying to delete dumb users..

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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:

    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
    Username: Paprika
    IP Address:
    I'm kinda urked about it because it done a few steps then crashed, now some data may be out of sync

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


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


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