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!

[Marco van Herwaarden]

I hope you did not solve it by adding such a column?

[Analogpoint]

Originally Posted by Marco van Herwaarden

I hope you did not solve it by adding such a column?

The thought of doing that never crossed my mind until you mentioned it. You made me smile, because I'm sure there are people who would do that.

[GrendelKhan{TSU]

did you ever find the fix for this? I have the EXACT same problem/error. +_+

[Opserty]

You have an extra bitfield_****.xml file in your includes/xml folder which was not removed when you removed a modification recently, I reckon.

(I think Admin Permissions follow the same rule as the other permissions).

[Shawn Yue]

I Thing You Must Reupload The Error File Or Contact http://www.vbulletin.com

Go Member Area Post A Support Ticket About This Issue And They Will Support You With Help

I Got This Error Before I Went There Post A Ticket And I Fix This Error

Or You Want A Quick Support Go www.vbulletin.com/forum

Thank You

[Marco van Herwaarden]

No Shawn,

There is not need to re-upload any files or open a support ticket. Also vBulletin.com is not the place to troubleshoot problems with a modification.

Opserty already posted the correct solution.

[GrendelKhan{TSU]

Originally Posted by Opserty

You have an extra bitfield_****.xml file in your includes/xml folder which was not removed when you removed a modification recently, I reckon.

(I think Admin Permissions follow the same rule as the other permissions).

well.. I went and removed EVERY bitfield .xml I had in the includes/xml folder....
and I still get the same error!!!!

I'm kinda at a loss now.


thoughts?

[Marco van Herwaarden]

If you really removed every bitfield file in that directory then:
- It is not possible that you still get the same error
- Standard vBulletin will not work anymore and will give you errors.

actually, removing all bitfield files will not update the bitfields... so the bug still occurs...