[Luggruff]

Originally Posted by Delphiprogrammi

then you could edit it under the usermanager there is a column warnings information set those values all to 0 and submit the form (you will have to do that for each user through)

Yeah, for 1500 users. Especially when it won't let you update the userprofiles anymore.
Error as following:

Database error in vBulletin 3.6.0:

Invalid SQL:
UPDATE user SET
    ### Bitfield: user.options ###
        options = IF(options & 8, options - 8, options),
        options = IF(options & 1024, options, options + 1024),
        options = IF(options & 16, options, options + 16),
        options = IF(options & 256, options - 256, options),
        options = IF(options & 512, options - 512, options),
        options = IF(options & 32, options - 32, options),
        options = IF(options & 2048, options, options + 2048),
        options = IF(options & 4096, options - 4096, options),
        options = IF(options & 1, options, options + 1),
        options = IF(options & 2, options, options + 2),
        options = IF(options & 4, options, options + 4),
        options = IF(options & 64, options, options + 64),
        options = IF(options & 128, options - 128, options),
        options = IF(options & 32768, options - 32768, options),
    ### Bitfield: user.adminoptions ###
        adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
        adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
    usertitle = 'c.\")',
    customtitle = 2,
    username = 'woicer',
    email = 'woicer@crackinggear.net',
    languageid = 2,
    homepage = 'http://www.habbohotel.se',
    birthday_search = '0000-01-01',
    birthday = '01-01-0000',
    showbirthday = 1,
    icq = '',
    aim = '',
    yahoo = '',
    msn = '',
    skype = '',
    parentemail = '',
    referrerid = 0,
    ipaddress = '',
    posts = 2270,
    alerts = 0,
    warns = 0,
    warning_level = 0,
    warning_bans = 0,
    isstaffrank = '0',
    staffrank = '',
    staffrank_opentag = '',
    staffrank_closetag = '',
    usergroupid = 5,
    reputationlevelid = 7,
    reputation = 88,
    warnings = 0,
    infractions = 0,
    ipoints = 0,
    pmpopup = 0,
    autosubscribe = -1,
    threadedmode = 0,
    showvbcode = 2,
    styleid = 0,
    timezoneoffset = '2',
    daysprune = 0,
    joindate = 1108033200,
    lastactivity = 1157998800,
    lastpost = 1157952060,
    membergroupids = ''
WHERE userid = 632;

MySQL Error  : Unknown column 'warns' in 'field list'
Error Number : 1054
Date         : Monday, September 11th 2006 @ 02:42:28 PM
Script       : http://www.hlforum.org/admcp/user.php?do=update
Referrer     : http://www.hlforum.org/admcp/user.php?do=edit&u=632
IP Address   : 81.235.17.12
Username     : Luggruff
Classname    : vb_database

A solution is needed. And fast?