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]

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]

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!!!! :eek: :eek:

I'm kinda at a loss now. :confused:


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.

[nexialys]

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

[Marco van Herwaarden]

Hmm you might be correct on that Nexialys.

Anyway, you should only remove those files that belong to uninstalled (or never fully installed) modifications.

[GrendelKhan{TSU]

ok.. what I meant is...

I removed all EXCEPT: bitfield_vbulletin.xml
whenI removed that...the forums went down completely. so I put that one back.

all the others were off though. So, unless I missed something or it was a random ghost in the machine error. I nixed them all.

(oh by "removed".. to be exact, I mean I changed the files names to end in.... "*.XMLXXXXXXX" (ie making them irrelevant files))

Should I have to turn off all the plugins as well?

[Marco van Herwaarden]

Please post the exact error you are getting now.

[nexialys]

you have to do a simple action when rebuilding bitfields:

1- go to your admincp, open the tab to access the link... do not click it yet
2- go to your ftp, and delete/mode all the bitfields except the vbulletin one
3- click the link to Rebuild Bitfields ...

if you change a page before clicking the rebuild link, your site will be down, because it needs the files AND the rebuild.. you have to do it in a single shot.

if the problem continue to occur, deactivate the hooks system in your admincp, delete the bitfields and Rebuild Bitfields... maybe it is related to a hook.

[fukdawrld]

I'm not sure if u fixed this..but i had the same issue and the suggestions above didn't personally help.


I did this:

This is a problem caused by PhotoPost's VB Gallery. To fix it, run this query:
ALTER TABLE administrator ADD vbgadminperms INT( 10 ) UNSIGNED NOT NULL DEFAULT 0


Worked like a charm. Good luck

[Opserty]

(For anyone else that comes along...)

Please do not run SQL queries to fix this problem. (As given in the above post)

I have already provided the correct solution in post #5