Admin Problem On my Site

[Snooopy`]

I was messing with groups and i accidentally removed my Super admin. now i cant get it back. HELPPPPP

[Gaijin]

Get access to your SQL DB and change the group there.

[Snooopy`]

What should i look for in there

[MattR]

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

[Snooopy`]

I ran this but nothing happened

---

How exatcly do i run this

[MattR]

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

[WirelessWave]

May i ask what UID is pleaseÉ

[Snooopy`]

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

[MattR]

Right, then run that query, if you do it right, it'll work fine.

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.

[Snooopy`]

Ok 1 sec il try this all again

---

It says the query ran but it still didnt work lol