I delete myself as admin how can I solve this.
Its a new forum that I started with a few post and 1 member that is also the admin.
Run this SQL query in phpmyadmin:
UPDATE mybb_users SET usergroup='4' WHERE username='your username'
Or, you could ask the other admin to promote you.
Sorry that does not work for me because I just start this new forum. And there also are no other users (only 15 spamusers)
Ok, try this
UPDATE mbb_users SET usergroup='4' WHERE username='your username'
No did not work.
I get the message that 0 rows are cheanged.
My name is also not in the list of users in mmb_users.
My name is on the forum but not clickable
http://abdijtorenbuurt.nl/forum/index.php
Solved I use a back up.
try below queries one by one (Edit : changed prefix ..)
DELETE FROM `mbb_datacache` WHERE `title` = 'usergroups';
UPDATE `mbb_users` SET usergroup='4' WHERE uid='1'
UPDATE `mbb_usergroups` SET `cancp` = '1' WHERE `gid` = '4';
I solve it by using a back up
Oh, I thought you just deleted your admin rights
I didn't know you deleted the whole user