Log in

View Full Version : someone help emergancy cant set administrator permission


Vackrick
11-10-2008, 06:05 AM
Database error in vBulletin 3.7.3:

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 & 131072, adminpermissions, adminpermissions + 131072),
adminpermissions = IF(adminpermissions & 262144, adminpermissions, adminpermissions + 262144),
### Bitfield: administrator.customphppermissions ###
customphppermissions = IF(customphppermissions & 8, customphppermissions, customphppermissions + 8),
cssprefs = '',
dismissednews = ''
WHERE userid = 15;

MySQL Error : Unknown column 'customphppermissions' in 'field list'
Error Number : 1054
Request Date : Monday, November 10th 2008 @ 03:03:14 AM
Error Date : Monday, November 10th 2008 @ 03:03:15 AM
Script : *****************************/forum/admincp/adminpermissions.php?do=update
Referrer : ************************/forum/admincp/adminpermissions.php?do=edit&u=15

Please help pls pls pls pls

i did not backup... also

please help pls

now i set user admin permission got database error....

snakes1100
11-10-2008, 10:27 AM
Disable your hacks, that is not a default vbulletin field.

Disable your hacks 1 by 1 until the error goes away.

You might have to remove any non default xml file as well from the includes/xml directory.

Dismounted
11-11-2008, 03:49 AM
You most likely have a bitfield_*.xml you have left in the /includes/xml directory after uninstalling a modification.