Can't edit user?

[Shazz]

PHP Code:

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE user SET
    ### Bitfield: user.options ###
        options = IF(options & 8, options - 8, options),
        options = IF(options & 1024, options - 1024, options),
        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),
    usertitle = 'Banned',
    customtitle = 0,
    username = 'CAp i TOLL Z',
    email = 'ass@aim.com',
    languageid = 1,
    homepage = '',
    birthday_search = '1975-03-04',
    birthday = '03-04-1975',
    showbirthday = 2,
    icq = '',
    aim = '',
    yahoo = '',
    msn = '',
    skype = '',
    parentemail = '',
    posts = 1,
    referrerid = '221',
    ipaddress = '*edit out',
    acceptbattles = 1,
    battle_wins = 0,
    battle_losses = 0,
    battle_ko = 0,
    usergroupid = 8,
    reputationlevelid = 5,
    reputation = 10,
    pmpopup = 0,
    autosubscribe = -1,
    threadedmode = 0,
    showvbcode = 1,
    styleid = 0,
    timezoneoffset = '-5',
    daysprune = 0,
    joindate = 1151804880,
    lastactivity = 1151805420,
    lastpost = 1151805060,
    advpmoptions_savecopy = 1,
    advpmoptions_receipt = 0,
    advpmoptions_deleteoriginal = 0,
    membergroupids = '',
    vbp_receivespoints = 1,
    vbp_storeaccess = 1,
     = 0,
    vbp_nextbankinterest = 0,
    vbp_genericperm = 0,
    vbp_modperm = 0,
    vbp_adminperm = 0,
    vbp_nametextcolor = '',
    vbp_nameglowcolor = '',
    vbp_nameshadowcolor = '',
    vbp_namefonttype = '',
    vbp_titletextcolor = '',
    vbp_titleglowcolor = '',
    vbp_titleshadowcolor = '',
    vbp_titlefonttype = '',
    vbp_changealwaysitems = '',
    ### Bitfield: user.vbp_displayflags ###
        vbp_displayflags = IF(vbp_displayflags & 1, vbp_displayflags - 1, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 2, vbp_displayflags - 2, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 4, vbp_displayflags - 4, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 8, vbp_displayflags - 8, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 16, vbp_displayflags - 16, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 32, vbp_displayflags - 32, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 64, vbp_displayflags - 64, vbp_displayflags),
        vbp_displayflags = IF(vbp_displayflags & 128, vbp_displayflags - 128, vbp_displayflags),
    ### Bitfield: user.vbp_otherflags ###
        vbp_otherflags = IF(vbp_otherflags & 1, vbp_otherflags - 1, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 2, vbp_otherflags - 2, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 4, vbp_otherflags - 4, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 8, vbp_otherflags - 8, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 16, vbp_otherflags - 16, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 32, vbp_otherflags - 32, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 64, vbp_otherflags - 64, vbp_otherflags),
        vbp_otherflags = IF(vbp_otherflags & 256, vbp_otherflags - 256, vbp_otherflags),
    ### Bitfield: user.vbp_immunity ###
        vbp_immunity = IF(vbp_immunity & 1, vbp_immunity - 1, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 2, vbp_immunity - 2, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 4, vbp_immunity - 4, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 8, vbp_immunity - 8, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 16, vbp_immunity - 16, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 32, vbp_immunity - 32, vbp_immunity),
        vbp_immunity = IF(vbp_immunity & 64, vbp_immunity - 64, vbp_immunity)
WHERE userid = 223;

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 '= 0,
    vbp_nextbankinterest = 0,
    vbp_genericperm = 0,
    vbp_m
Error Number : 1064
Date         : Tuesday, July 18th 2006 @ 12:44:44 PM
Script       : http://www.dawritersblock.com/admincp/user.php
Referrer     : http://www.dawritersblock.com/admincp/user.php?do=edit&u=223
IP Address   : *edit out
Username     : Shazz
Classname    : vb_database 

It happends when i try and Update someones profile.
Like Search Users> change something then hit save.
This happends =\
I haven't installed any hacks or plugins..
________
Ducati 350 Desmo

[ericgtr]

Are you sure you don't have any mods installed? I don't believe nextbankinterest is a default table. Do you (or did you) have any point system installed? If so I would disable or uninstall it and try again.

[Shazz]

Yea i found out that was the problem when i ran GZIP
thanx though
________
Ford Maverick history