Hi
i mistakenly deleted my admin username through admin cp and now can't log in or moderate anything
i have the access to ftp and mysql
any ideas what should i do?
i don't wanna reinstall it?
okay make a new user and edit its group in phpmyadmin.
crsoft Wrote:okay make a new user and edit its group in phpmyadmin.
how to do that?
which table to edit?
what code do i need becoz i am the only mod/admin on my site
give me an example as well
thx
okay, i am able to log in now as admin but i have one more problem
i can't backup database and other important stuff
it says
Quote:You do not have permission to access this part of the administration control panel.
looks like i have not done the correct details
what should i do?
i think the forum is taking me as moderator..
thx
Admin is NOT the uid. Hover over the profile link of your user, and enter the number (the user id).
You also don't need to make it red.
1. Sign up again
2. Go into phpmyadmin
3. Set the new user as usergroup 4 and set the uid to 1 (assuming your old uid was 1)
That should do it. Sadly if you deleted the user via admincp then all the posts are no longer associated. You will need additional mysql queries via phpmyadmin to restore those old posts and PMs.
labrocca Wrote:1. Sign up again
2. Go into phpmyadmin
3. Set the new user as usergroup 4 and set the uid to 1 (assuming your old uid was 1)
That should do it. Sadly if you deleted the user via admincp then all the posts are no longer associated. You will need additional mysql queries via phpmyadmin to restore those old posts and PMs.
i still can`t do it,
can you tell me what exact query to do,
here is the url
Forum
you can see it says 3 registred users and shows only 2 in member list
or should i do the reinstall
Thanks for your fast support
Kamran Wrote:i still can`t do it,
can you tell me what exact query to do,
http://community.mybboard.net/showthread.php?tid=19647
Kamran Wrote:here is the url
Forum
you can see it says 3 registred users and shows only 2 in member list
Once you get access to your Admin CP, please do a rebuild and recount of your statistics (in the maintenance section of your Admin CP)
Quote:UPDATE mybb_adminoptions SET caneditaperms='yes' WHERE uid='YOUR_USER_ID'
this query doesn't do any difference