Semere79 |
05-14-2009 03:14 AM |
How do you remove any traces of this from the database? I started working on it quite some time ago and never got it going. Now anytime I try to save anything to define rights to my individual administrators I get the following errors... I think I just need to get rid of it out of the database but not sure exactly what to do...
Code:
Database error in vBulletin 3.8.2:
Invalid SQL:
UPDATE vb_administrator SET
### Bitfield: vb_administrator.adminpermissions ###
adminpermissions = IF(adminpermissions & 4, adminpermissions - 4, adminpermissions),
adminpermissions = IF(adminpermissions & 8, adminpermissions - 8, adminpermissions),
adminpermissions = IF(adminpermissions & 16, adminpermissions - 16, adminpermissions),
adminpermissions = IF(adminpermissions & 32, adminpermissions - 32, adminpermissions),
adminpermissions = IF(adminpermissions & 64, adminpermissions - 64, adminpermissions),
adminpermissions = IF(adminpermissions & 128, adminpermissions - 128, adminpermissions),
adminpermissions = IF(adminpermissions & 256, adminpermissions - 256, adminpermissions),
adminpermissions = IF(adminpermissions & 512, adminpermissions - 512, adminpermissions),
adminpermissions = IF(adminpermissions & 1024, adminpermissions - 1024, adminpermissions),
adminpermissions = IF(adminpermissions & 2048, adminpermissions - 2048, adminpermissions),
adminpermissions = IF(adminpermissions & 4096, adminpermissions - 4096, adminpermissions),
adminpermissions = IF(adminpermissions & 8192, adminpermissions - 8192, adminpermissions),
adminpermissions = IF(adminpermissions & 16384, adminpermissions - 16384, adminpermissions),
adminpermissions = IF(adminpermissions & 65536, adminpermissions - 65536, adminpermissions),
adminpermissions = IF(adminpermissions & 131072, adminpermissions - 131072, adminpermissions),
adminpermissions = IF(adminpermissions & 262144, adminpermissions - 262144, adminpermissions),
blogpermissions = 3,
### Bitfield: vb_administrator.customadminperms ###
customadminperms = IF(customadminperms & 1, customadminperms - 1, customadminperms),
cssprefs = 'vBulletin_3_Default',
dismissednews = '66,67,70,72,74'
WHERE userid = 1;
MySQL Error : Unknown column 'adminpermissions' in 'field list'
Error Number : 1054
Request Date : Wednesday, May 13th 2009 @ 10:55:58 PM
Error Date : Wednesday, May 13th 2009 @ 10:55:58 PM
Script : http://www.myforum.com/forum/admincp/adminpermissions.php?do=update
Referrer : http://www.myforum.com/forum/admincp/adminpermissions.php?do=edit&u=1
IP Address : xx.xxx.xx.xx
Username : Admin
Classname : vB_Database
MySQL Version : 5.0.67-community
|