Okay, I was testing my ranks and I made myself mod now I cant change back to admin? how can I fix this..lol
Hi Bugz,
If you can't access the ACP (try going to yourforum.com/admin/), then the only way you can get back is by manually editing the database.
First of all, login into phpmyadmin and find your MyBB database. Then, go to the mybb_usergroups table, and find the gid for the Administrators group (it is more than likely to be 4).
Then, go to the mybb_users group, find your account and change the usergroup column to that number.
Edit: delayed response
you can run below SQL query at the database manager (eg.
phpMyAdmin) of your web host panel (
guidance)
UPDATE mybb_users SET usergroup='4' WHERE uid='your uid'
(2013-08-04, 04:27 PM).m. Wrote: [ -> ]Edit: delayed response
you can run below SQL query at the database manager (eg. phpMyAdmin) of your web host panel (guidance)
UPDATE mybb_users SET usergroup='4' WHERE uid='your uid'
in here?
http://prntscr.com/1jcuay and i dont understand what to do next
or this?
http://prntscr.com/1jcuz4 do I put that code in there? instead of what its showing in that pic?
^ no, you can select
mybb_users at the left side column (or just the database at the left side) and
SQL tab at the right
if you are confused then please see the referred
guidance
