MyBB Community Forums

Full Version: Took myself off as admin..$ Reward
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
Well I tried this new plugin VIP Membership so I switched myself to a premium member instead of a admin. There are no other staff, what can I do?
Huh Huh

I need my admin powers back,
I have access to the Hosting CP, Domain CP, and FTP

Help me, and there maybe a reward such as paypal money Angel
Run this query in phpMyAdmin:

UPDATE `mybb_users` SET `usergroup` = '4' WHERE `uid` = '1'; 
(2011-08-21, 03:04 PM)pyridine Wrote: [ -> ]Run this query in phpMyAdmin:

UPDATE `mybb_users` SET `usergroup` = '4' WHERE `uid` = '1'; 

I'm so sorry, but what exactly is that?
I'm really new to sites, and I have FileZilla if that helps you.
^ that is a database query to be run using the database manager (eg. phpmyadmin) at your webhost panel
(2011-08-21, 03:11 PM)KronicArts Wrote: [ -> ]
(2011-08-21, 03:04 PM)pyridine Wrote: [ -> ]Run this query in phpMyAdmin:

UPDATE `mybb_users` SET `usergroup` = '4' WHERE `uid` = '1'; 

I'm so sorry, but what exactly is that?
I'm really new to sites, and I have FileZilla if that helps you.
If you have cPanel, log in to it and go to PHPMyAdmin. Then, at the "SQL" tab, paste the following code and hit "RUN" or "SUBMIT" or whatever.
UPDATE `mybb_users` SET `usergroup` = '4' WHERE `uid` = '1';
Ugh,
I am getting this:
http://gyazo.com/ddbc09dd3a8ca8f02b9a82f200c1e9e7


When I go to the SQL tab and paste that code and hit "go"
The table probably has a different name. You need to change mybb_ to match the table prefix you chose during installation.
(2011-08-21, 03:35 PM)KronicArts Wrote: [ -> ]Ugh,
I am getting this:
http://gyazo.com/ddbc09dd3a8ca8f02b9a82f200c1e9e7


When I go to the SQL tab and paste that code and hit "go"

If you gave a custom prefix while installing MyBB, modify the code so that the "mybb" part is replaced by your custom prefix.
Not working,
The database name is "luxuryte_kronic" so how would I do that?
I've been trying UPDATE mybb_kronic SET usergroup = '4' WHERE uid = '1';
Look at the sidebar on your left. What are some of the names of the tables there? (e.g. mybb_forums, mybb_adminlogs, mybb_users...)
Pages: 1 2