MyBB Community Forums

I think I just demoted myself from the admin group. How can I get back into it, because I am the only admin on the site?
Url: http://fictionlovers.org

Did you just change your usergroup?? Run this query:

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

Change the 1 to your UID if it's not 1.

I tried that and it didn't work

Because your UID is 2. Why is there no user 1?

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

Use that query.

What exactly did you do to demote yourself then...??

Edit: I did say to change the 1 to your UID if it wasn't 1...

Wait. oh it's because mine would have to be

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

What do I do then?

Is you UID 1 or is it 2?? If it's 2, change the 1 in that query to a 2, and then run the query...

Yeah I did the query and got

Quote:Your SQL query has been executed successfully ( Query took 0.0003 sec )

But I am still not an admin. what now?

How many rows does it say it affected?? I don't think you're running the query right, PM me phpMyAdmin login details and I'll do it for you.

How can I tell how many rows were affected?

Also, i don't know my login details as my host does that for me I believe.