[JorgeX]

Hi........anyone can tell me how fix this error when trying to edit an user? (Users - Search user -> Edit user) Thanks a lot!

Originally Posted by DB Error

Database error in vBulletin 3.6.3:

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, options + 256),
options = IF(options & 512, options - 512, options),
options = IF(options & 32, options - 32, options),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 131072, options - 131072, options),
options = IF(options & 4096, options, options + 4096),
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 = 'Usuario',
customtitle = 0,
username = 'Ranses',
email = 'ranses_a@hotmail.com',
languageid = 4,
homepage = '',
birthday_search = '1972-05-11',
birthday = '05-11-1972',
showbirthday = 2,
icq = '',
aim = '',
yahoo = '',
msn = '',
skype = '',
parentemail = '',
referrerid = 0,
ipaddress = '200.68.254.2',
posts = 0,
ucash = '0.00',
usergroupid = 3,
reputationlevelid = 5,
reputation = 10,
warnings = 0,
infractions = 0,
ipoints = 0,
pmpopup = 1,
autosubscribe = -1,
threadedmode = 0,
showvbcode = 2,
styleid = 0,
timezoneoffset = '-3',
daysprune = 0,
joindate = 1163906160,
lastactivity = 1163906160,
lastpost = 0,
membergroupids = ''
WHERE userid = 834;

MySQL Error : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date : Sunday, November 19th 2006 @ 12:28:03 AM
Script : http://games.fusionnetworks.com.ar/f....php?do=update
Referrer : http://games.fusionnetworks.com.ar/f...?do=edit&u=834
IP Address : 190.50.168.78
Username : JorgeX
Classname : vB_Database

Sorry........posted in vbulletin.com.