admin permissions gone bad

[narutorasengan]

NVM its fixed

i wanted to promote one of my super mods, i made them an admin, wanted to change the admin permissions...

but then bam, i get this after i submit, please im in a rush i need help, i never really messed with the mySQL database, so i don't know why this happened...

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE administrator SET
### Bitfield: administrator.adminpermissions ###
adminpermissions = IF(adminpermissions & 4, adminpermissions, adminpermissions + 4),
adminpermissions = IF(adminpermissions & 8, adminpermissions, adminpermissions + 8),
adminpermissions = IF(adminpermissions & 16, adminpermissions, adminpermissions + 16),
adminpermissions = IF(adminpermissions & 32, adminpermissions, adminpermissions + 32),
adminpermissions = IF(adminpermissions & 64, adminpermissions, adminpermissions + 64),
adminpermissions = IF(adminpermissions & 128, adminpermissions, adminpermissions + 128),
adminpermissions = IF(adminpermissions & 256, adminpermissions, adminpermissions + 256),
adminpermissions = IF(adminpermissions & 512, adminpermissions, adminpermissions + 512),
adminpermissions = IF(adminpermissions & 1024, adminpermissions, adminpermissions + 1024),
adminpermissions = IF(adminpermissions & 2048, adminpermissions, adminpermissions + 2048),
adminpermissions = IF(adminpermissions & 4096, adminpermissions, adminpermissions + 4096),
adminpermissions = IF(adminpermissions & 8192, adminpermissions, adminpermissions + 8192),
adminpermissions = IF(adminpermissions & 16384, adminpermissions, adminpermissions + 16384),
adminpermissions = IF(adminpermissions & 65536, adminpermissions, adminpermissions + 65536),
adminpermissions = IF(adminpermissions & 32768, adminpermissions - 32768, adminpermissions),
### Bitfield: administrator.vbgadminperms ###
vbgadminperms = IF(vbgadminperms & 1, vbgadminperms, vbgadminperms + 1),
cssprefs = '',
dismissednews = ''
WHERE userid = 12;

MySQL Error : Unknown column 'vbgadminperms' in 'field list'
Error Number : 1054
Date : Friday, November 2nd 2007 @ 05:59:36 PM




thanks in advance!