+- Support Forums (https://www.supportforums.net)
+-- Forum: Categories (https://www.supportforums.net/forumdisplay.php?fid=87)
+--- Forum: Webmaster Support (https://www.supportforums.net/forumdisplay.php?fid=36)
+---- Forum: Forum Software Help (https://www.supportforums.net/forumdisplay.php?fid=49)
+---- Thread: Admin Problem On my Site (/showthread.php?tid=3706)
Admin Problem On my Site - Snooopy` - 12-17-2009
I was messing with groups and i accidentally removed my Super admin. now i cant get it back. HELPPPPP
RE: Admin Problem On my Site - Gaijin - 12-17-2009
Get access to your SQL DB and change the group there.
RE: Admin Problem On my Site - Snooopy` - 12-17-2009
What should i look for in there
RE: Admin Problem On my Site - MattR - 12-17-2009
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??
RE: Admin Problem On my Site - Snooopy` - 12-17-2009
I ran this but nothing happened
How exatcly do i run this
RE: Admin Problem On my Site - MattR - 12-17-2009
(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
RE: Admin Problem On my Site - WirelessWave - 12-17-2009
May i ask what UID is pleaseÉ
RE: Admin Problem On my Site - Snooopy` - 12-17-2009
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
RE: Admin Problem On my Site - MattR - 12-17-2009
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.
RE: Admin Problem On my Site - Snooopy` - 12-17-2009
Ok 1 sec il try this all again
It says the query ran but it still didnt work lol