No announcement yet.

Error 1064 during moderation of new users.

  • Filter
  • Time
  • Show
Clear All
new posts

  • Error 1064 during moderation of new users.

    Just wondering what I should do to get past this error. I got this today trying to moderate 500 new users to my forum. First I hit, IGNORE ALL. Then I put about 10 users on ACCEPT and 20 users on DELETE. I pressed submit, and here's what I got:

    Database error in vBulletin 3.0.0 Beta 7:

    Invalid SQL:
    SELECT text FROM phrase
    WHERE phrasetypeid = 3000
    AND varname = 'moderation_deleted'
    AND languageid IN(-1,0,)
    ORDER BY languageid DESC

    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 ')
    ORDER BY languageid DESC' at line 4

    mysql error number: 1064

    Date: Friday 23rd of July 2004 09:49:28 PM
    Username: ibeblunt
    IP Address:

    I'm running vb with no hacks.
    Last edited by ibeblunt; Sat 4 Dec '04, 7:12pm.

  • #2
    Sorry but we cannot provide support for pre-release versions. Yours is seriously out-of-date.

    I suggets trying a repair of the database to see if this corrects the immediate problem. And either way, you should upgrade to 3.0.3.
    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.