[Delphiprogrammi]

Originally Posted by seg

I found that a user's warning level was not lowering after 60 day (the maturity date I set. I checked the users account and found that the warning level was at 5, but the warnings were blank (no number). When I tried to correct the issue I received the following db error:

Database error in vBulletin 3.6.0:
 
Invalid SQL:
UPDATE forumuser SET
    ### Bitfield: forumuser.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, options + 256),
        options = IF(options & 512, options, options + 512),
        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: forumuser.adminoptions ###
        adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
        adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
    usertitle = 'Member',
    customtitle = 0,
    username = 'private',
    email = 'private',
    languageid = 0,
    homepage = '',
    birthday_search = 'private',
    birthday = 'private',
    showbirthday = 0,
    icq = '',
    aim = '',
    yahoo = '',
    msn = '',
    skype = '',
    parentemail = '',
    referrerid = 0,
    ipaddress = 'private',
    posts = 192,
    alerts = 1,
    warns = 6,
    warning_level = 0,
    warning_bans = 0,
    usergroupid = 2,
    reputationlevelid = 5,
    reputation = 10,
    warnings = 6,
    infractions = 0,
    ipoints = 0,
    pmpopup = 0,
    autosubscribe = -1,
    threadedmode = 0,
    showvbcode = 1,
    styleid = 0,
    timezoneoffset = '-8',
    daysprune = 0,
    joindate = 1140481140,
    lastactivity = 1158105360,
    lastpost = 1158104940,
    membergroupids = '',
    genpermoverride = 536870911,
    adminignore = ''
WHERE userid = 1283;
 
MySQL Error  : Unknown column 'warns' in 'field list'
Error Number : 1054

I marked private on some of the user's info. What can I do to repair this problem? Do I go directly into MySQL and add the warns amount?

hmmmz since more users complain about this type of errors i need to check the system.why on earth is your warns field missing ????

ALTER TABLE forumuser ADD COLUMN warns INT(5) DEFAULT '0';

i will check that