Database error when changing admin permissions.

محروم.كوم · #1 08-05-2010, 02:40 AM

Whenever I attempt to change any Admin Permission settings I get this database error:

Database error in vBulletin 3.8.6:

Invalid SQL:
UPDATE vbadministrator SET
### Bitfield: vbadministrator.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),
canadminangularadver = 0,
### Bitfield: vbadministrator.garsadminperms ###
garsadminperms = IF(garsadminperms & 1, garsadminperms - 1, garsadminperms),
### Bitfield: vbadministrator.dbtech_vbactivityadminperms ###
dbtech_vbactivityadminperms = IF(dbtech_vbactivityadminperms & 1, dbtech_vbactivityadminperms - 1, dbtech_vbactivityadminperms),
### Bitfield: vbadministrator.customadminperms ###
customadminperms = IF(customadminperms & 1, customadminperms - 1, customadminperms),
### Bitfield: vbadministrator.mapermissions ###
mapermissions = IF(mapermissions & 1, mapermissions - 1, mapermissions),
### Bitfield: vbadministrator.dbtech_vbshopadminperms ###
dbtech_vbshopadminperms = IF(dbtech_vbshopadminperms & 1, dbtech_vbshopadminperms - 1, dbtech_vbshopadminperms),
### Bitfield: vbadministrator.dbtech_usertagadminperms ###
dbtech_usertagadminperms = IF(dbtech_usertagadminperms & 1, dbtech_usertagadminperms - 1, dbtech_usertagadminperms),
cssprefs = '',
dismissednews = ''
WHERE userid = 430;

MySQL Error : Unknown column 'customadminperms' in 'field list'
Error Number : 1054
Request Date : Wednesday, August 4th 2010 @ 10:29:16 PM
Error Date : Wednesday, August 4th 2010 @ 10:29:16 PM
Script : http://creativx.net/forums/admincp/a....php?do=update
Referrer : http://creativx.net/forums/admincp/a...?do=edit&u=430
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.48-log

Can someone please help me?

Thanks! __DEFINE_LIKE_SHARE__

أدوات الموضوع
مشاهدة صفحة طباعة الموضوع أرسل هذا الموضوع إلى صديق
انواع عرض الموضوع
الانتقال إلى العرض العادي الانتقال إلى العرض المتطور العرض الشجري