How can I restore admin capabilities?

1 Views

So yeah, I’m a genius. I managed delete all my admin capabilities (thank you very much Membership plugin). I could restore them, …if I had admin access, lol.

Anywhoo, how can I give all my capabilities back to admin? I have access to the database via PHPMyAdmin but have no idea where or what to add back to the DB.

Read More

Any help would be appreciated. Thanks!

Post Views: 1

Related posts

Leave a Reply

6 comments

  1. The string below actually represents an array in serialized form.

    a:1:{s:13:"administrator";s:1:"1";}

    Here:
    a:1 means an array with a single element
    s:13 means string and the length of the string followed by

    Array 
{
     "administrator" => "1"
}

    Once that is in the table, you can use the unserialize() function to return it to an array for use in your code.

    Many thanks.

  3. Ok, sorry for asking. I figured it out. But for future people, here’s a suggestion.

    Step 1 (BACKUP!!!!) – backup your database, if the next step screws you over and you don’t have a backup it’s your own fault.

    Step 2 – Use PHPMyAdmin or similar tool to access your DB, find the wp_usermeta table and then sort by user_id. User #1 is your admin. Next find your wp_capabilities field and click edit (this is the part that got screwed up).

    I replaced what I had that was screwed up. This:

    a:3:{s:15:"membershipadmin";s:1:"1";s:10:"M_add_ping";s:1:"1";s:10:"subscriber";s:1:"1";}

    with this (which I copied from another WP database):

    a:4:{s:13:"administrator";s:1:"1";s:15:"membershipadmin";s:1:"1";s:11:"M_add_level";s:1:"1";s:10:"M_add_ping";s:1:"1";}

    Before I check my own answer, can anyone confirm my answer, or explain the contents of this field and how it should properly be listed? You may take my answer and rewrite it as your own, and if it’s proper I’ll check your answer.

  4. This is pretty simple. All I did was open phpmyaddmin, I selected a database from my former website I created, searched for wp_usermeta, clicked on user_capabilities, and since admin id is 1, all I did was copy the strings 

    (a:2:{s:13:"administrator";b:1;s:13:"bbp_keymaster";b:1;})

    and pasted it in my problematic db. Clicked save, log out the log back in and I got my roles back

  5. I had the same problem and all these solutions didn’t help me.

    The one which eventually worked for, was:

    1. Log in to your PHP Admin to edit the database
    2. Find the table wp_usermeta and see what the ID is of the admin (probably 1)
    3. Now find the wp_capabilities field
    4. Replace the line with the following line:

    a:14:{s:13:”administrator”;b:1;s:15:”membershipadmin”;b:1;s:24:”membershipadmindashboard”;b:1;s:22:”membershipadminmembers”;b:1;s:21:”membershipadminlevels”;b:1;s:28:”membershipadminsubscriptions”;b:1;s:22:”membershipadmincoupons”;b:1;s:24:”membershipadminpurchases”;b:1;s:29:”membershipadmincommunications”;b:1;s:21:”membershipadmingroups”;b:1;s:20:”membershipadminpings”;b:1;s:23:”membershipadmingateways”;b:1;s:22:”membershipadminoptions”;b:1;s:32:”membershipadminupdatepermissions”;b:1;}

    Update and now you have permission to everything in the membership plugin.

  6. I made the database changes as instructed but when I signed in as an administrator I still could’nt alter users or pages.

    When comparing the database field for user roles I noticed it was different from other WordPress installations. My solution was this:

    Find the field named “wp_user_roles” in the table named [database prefix]_options, e.g. “wp_options”, and make sure it has all capabilities for administrators. It’s a serialized string with a lot of information so I think the easiest thing to do is to copy the data from a clean WordPress install.