No announcement yet.

I lost admin!

  • Filter
  • Time
  • Show
Clear All
new posts

  • I lost admin!

    Hey Everybody!

    I made a very, very, stupid mistake. While playing with subscriptions I put myself into another usergroup that dosent have admin privlages.

    And.. now I'm locked out of my board's ACP.

    Is there a getadmin file I can run? Something to edit in phpMyAdmin? Anything?

    Owner of VB! :cool:
    "Life is good in the valley!"
    IP Tab it!

  • #2
    You can run this query in phpmyadmin:

    UPDATE user SET usergroupid=6 WHERE username='your username'

    The default usergroupid for the Administrators group is 6. If yours is different (see the usergroup table in phpmyadmin) then change the number accordingly. If you use table prefixes then you need to change user to include the prefix.

    Backup first!


    • #3
      1. In your config.php add your ID to the superadministrators list and to the undeletableusers list (the latter is important so that it won't fail again )
      2. Run the following Query (e. g. though phpMyAdmin):
        UPDATE user SET usergroupid = 6 WHERE userid = xxx
        where xxx is your userid.
      3. Try to login to your Admin-CP. If it works and you can see everything, you're almost finished.
      4. Go to Usergroups -> Adminpermissions: Is your name listed there? If yes: Go to Edit Permissions and set all permissions to yes if they aren't.
      If 3 or 4 didn't work run the following query:
      INSERT INTO administrator (userid, adminpermissions) VALUES (xxx, 65535)
      where xxx is your userrid.

      If the query succeeded, restart at 3. If it didn't, tell us what error you've got.

      If 3 and 4 succeede you should be finished now. (hopefully )

      Important Notes:
      1. I don't give any warranties, that it works.
      2. Do so at your own risk.
      3. It's recommended to backup your database first.
      Last edited by Stadler; Sat 6 Mar '04, 11:15pm.
      Hints & Tips:
      [[vB3] More Spiders / Indexers / Archives for vB3 - list]|[List of one-time-emails to ban]


      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.