and how to fixed this?
--------------- Added [DATE]1209809065[/DATE] at [TIME]1209809065[/TIME] ---------------
and now i get some error message :
Quote:
Database error in vBulletin 3.7.0:
Invalid SQL:
UPDATE user SET
### Bitfield: user.adminoptions ###
adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
usertitle = 'Ayam Sutra',
customtitle = 0,
birthday_search = '',
birthday = '',
referrerid = 0,
caninvitation = 0,
usergroupid = 5,
joindate = 1204861620,
lastactivity = 1209808740,
lastpost = 1209808320,
membergroupids = '',
vbp_receivespoints = 1,
vbp_storeaccess = 1,
vbbux = 180,
vbbank = 0,
vbp_nextbankinterest = 0,
vbp_genericperm = 0,
vbp_modperm = 0,
vbp_adminperm = 0,
vbp_nametextcolor = '',
vbp_nameglowcolor = '',
vbp_nameshadowcolor = '',
vbp_titletextcolor = '',
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),
displaygroupid = 0
WHERE userid = 5818;
MySQL Error : Unknown column 'caninvitation' in 'field list'
Error Number : 1054
Request Date : Saturday, May 3rd 2008 @ 11:00:04 AM
Error Date : Saturday, May 3rd 2008 @ 11:00:04 AM
Script : http://anakayam.us/forum/admincp/user.php?do=update
Referrer : http://anakayam.us/forum/admincp/use...do=edit&u=5818
IP Address : 209.190.12.11
Username : zHaZha
Classname : vB_Database
MySQL Version : 4.1.22-standard
|
|