[Delphiprogrammi]

Originally Posted by Luggruff

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?

ALTER TABLE user ADD COLUMN warns INT(5) DEFAULT '0';
UPDATE user SET warning_level=0,warns=0;

the first query will add the missing warns field (the errormessage problem) the second query will reset the warning_level and warns fields to 0 FOR ALL users