admin permissions gone bad
 

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!

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. :)

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

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).

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

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.

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?

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...

Hmm you might be correct on that Nexialys.

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

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?

Please post the exact error you are getting now.

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.

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:

Worked like a charm. Good luck

(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