[Delphiprogrammi]

Originally Posted by provedel

I am getting this error after install of AWS and wanto to change anything in profile of users...

Database error in vBulletin 3.6.7:
 
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, options + 512),
        options = IF(options & 32, options - 32, options),
        options = IF(options & 2048, options - 2048, options),
        options = IF(options & 131072, options - 131072, options),
        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, adminoptions + 1),
        adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
    usertitle = 'Administra??o',
    customtitle = 1,
    username = 'Fabio',
    email = 'fabiosz@ig.com.br',
    languageid = 0,
    homepage = '',
    birthday_search = '0000-01-04',
    birthday = '01-04-0000',
    showbirthday = 3,
    icq = '',
    aim = '',
    yahoo = '',
    msn = '',
    skype = '',
    parentemail = '',
    referrerid = 0,
    ipaddress = '200.165.254.57',
    posts = 3167,
    alerts = 0,
    warns = 0,
    warning_level = 0,
    warning_bans = 0,
    usergroupid = 6,
    displaygroupid = 0,
    membergroupids = '34',
    reputationlevelid = 12,
    reputation = 180,
    warnings = 0,
    infractions = 0,
    ipoints = 0,
    pmpopup = 0,
    autosubscribe = -1,
    threadedmode = 0,
    showvbcode = 2,
    styleid = 0,
    timezoneoffset = '-3',
    daysprune = -1,
    joindate = 1088773200,
    lastactivity = 1184613480,
    lastpost = 1184349060
WHERE userid = 270;
 
MySQL Error  : Unknown column 'alerts' in 'field list'
Error Number : 1054
Date         : Monday, July 16th 2007 @ 03:41:05 PM
Script       : http://forum.plurall.org/admincp/user.php?do=update
Referrer     : http://forum.plurall.org/admincp/user.php?do=edit&u=270
IP Address   : 201.37.21.114
Username     : Sauron
Classname    : vb_database

Any help?

[SQL]
ALTER TABLE user ADD COLUMN alerts INT(5) DEFAULT '0';
[/SQL]