Blog Documentation Book a Demo
Options

Upgraded to 1.0.1 after 0.9.2 phpBB move LOST ADMIN PRIVS

PRSop2000PRSop2000
edited October 2006 in Vanilla 1.0 Help
HELP! I successfully moved over all my users and posts and categories from phpBB but when I log in as the Admin user and go to settings I get ONE option (categories). Is there any way I can get FULL privs back?

Comments

  • PRSop2000PRSop2000
    It has me listed as Moderator, not Admin.
  • NickENickE New
    edited October 2006
    The following SQL query should work:update LUM_User set RoleID=4 where Name='your user name' limit 1;
  • PRSop2000PRSop2000
    Thank You... before I ran the SQL I took a peek at the user area of my DBase and noticed that somehow I had two accounts... the system was recognizing the wrong one so I deleted it and left the other that had a role ID of 6. Now when I log in I have full admin privs.
This discussion has been closed.