I deleted the group I was in which allowed me to go to ADMINCP, Now I am Member and cannot access the AdminCP, what do I do?
Go to your hosts control panel and launch phpMyAdmin.
Navigate to your MyBB database and run the following command:
UPDATE mybb_users SET usergroup=4 WHERE uid=1
You will be assigned to admin again!!!
Note:
Assuming your UID is 1 (default for first member : admin).
Assuming your database table prefix is mybb_ (default), if not, change what is.
Assuming your usergroup is 4 (default for Administrators), if not, change what is.
(2013-01-27, 09:22 PM)effone Wrote: [ -> ]Go to your hosts control panel and launch phpMyAdmin.
Navigate to your MyBB database and run the following command:
UPDATE mybb_users SET usergroup=4 WHERE uid=1
You will be assigned to admin again!!!
Note:
Assuming your UID is 1 (default for first member : admin).
Assuming your database table prefix is mybb_ (default), if not, change what is.
Assuming your usergroup is 4 (default for Administrators), if not, change what is.
I don't know where to enter that command, I went ot the MyBB Database, now where?
Go to phpMyAdmin in your CPanel- then go to SQL and run that query which effone said you have to run.
Take a look on this thread, everything is explained how to run query etc...
http://community.mybb.com/thread-44380.html
(2013-01-27, 09:34 PM)JovanJ. Wrote: [ -> ]Go to phpMyAdmin in your CPanel- then go to SQL and run that query which effone said you have to run.
Take a look on this thread, everything is explained how to run query etc...
http://community.mybb.com/thread-44380.html
I got an error:
#1146 - Table 'ruralzon_mybb800.mybb_users' doesn't exist
Is your 'ruralzon_mybb800.mybb_users' table name like that or it's just mybb_users? You don't need database name before table name when you are run a query. Click on database and then run query.
(2013-01-27, 09:40 PM)JovanJ. Wrote: [ -> ]Is your 'ruralzon_mybb800.mybb_users' table name like that or it's just mybb_users? You don't need database name before table name when you are run a query. Click on database and then run query.
Oh ok, lemme try this.
(2013-01-27, 09:40 PM)JovanJ. Wrote: [ -> ]Is your 'ruralzon_mybb800.mybb_users' table name like that or it's just mybb_users? You don't need database name before table name when you are run a query. Click on database and then run query.
I don't understand, what do I need to do?
(2013-01-27, 09:47 PM)JordanMussi Wrote: [ -> ]http://community.mybb.com/thread-44380.html should help you.
Edit: Ninja'd
I did this and the other person who commented on this threads tutorial but it still comes up with the error:
#1146 - Table 'ruralzon_mybb800.mybb_users' doesn't exist
