I was messing with groups and i accidentally removed my Super admin. now i cant get it back. HELPPPPP
Get access to your SQL DB and change the group there.
What should i look for in there
You didn't remove yourself as super admin, you just removed yourself as admin. Run this in phpMyAdmin:
PHP Code:
UPDATE `mybb_users` SET `usergroup` = '4' WHERE `uid` = 'X';
Change the X to your UID.
That's assuming you edited your user account, or did you edit the admin usergroup itself??
I ran this but nothing happened
How exatcly do i run this
(12-17-2009, 12:27 PM)MattR Wrote: [ -> ]That's assuming you edited your user account, or did you edit the admin usergroup itself??
...
Choose your database from the list on the left, then click the SQL tab along the top. Change the X to your UID, click Go.
And how can you say running it didn't work and then ask
how to run it...?? :S
May i ask what UID is pleaseÉ
Ok This was the situation
I Added a group promotion and i guess i made it so it would change ur primary group
i made myself the leader, and it took my admin away.
Snooopy` 17th Dec 2009, 14:16 user/groups - add_leader(1, Snooopy`, 8, CX l33t)
Snooopy` 17th Dec 2009, 14:13 tools/tasks - edit(5, Promotion System)
Snooopy` 17th Dec 2009, 14:12 user/group_promotions - edit(1, E3l1t3)
Those are the admin logs
the UID is 1
Right, then run that query, if you do it right, it'll work fine.
(12-17-2009, 12:36 PM)Genius Wrote: [ -> ]May i ask what UID is pleaseÉ
The number at the end of the URL when you view your profile, it's your unique identifier.
Ok 1 sec il try this all again
It says the query ran but it still didnt work lol