[cerebralgent]

Had an assistant delete a user we had set for admin and I guess he deleted one to many names and deleted the main admin. I dont how you can delete the main admins privileges but now we have no access to the buddypress options or the main admin options like editing users and blog backends. We do still have the other uses like, widgets, posting, settings.

We can no longer get to the pages to set back the admins statues, keep getting a “No permissions” reply.

Does anyone know what happened and how to fix it?!! Help

[Hugo Ashmore]

You might have to restore things by going into the DB and setting values back to what they should be for that user.

wp_usermeta table is a start, look for the user and ensure that wp_capabilities is :

a:1:{s:13:”administrator”;s:1:”1″;}

and the wp_user_level field is:

10

You may also need to go into the wp_sitemeta table and find the reference there to the site_admins in that row is where the site is told how many admin and who it must I guess have at least a initial value of:

a:1:{i:0;s:5:”admin”;}

As with all things of this nature do NOT do any work before backing up your DB, I cannot vouch for the detail I have shown or that it won’t cause irreversible harm

[cerebralgent]

Cool, im checking that right now. Thanks. It was a nuckle head move but I know this can be fixed easily and without having to restore all the web files to an earlier date.

[Hugo Ashmore]

Yep bottom line is that it’s simply a set of DB values that need changing, but as with all things it’s easy to say that and easy to point to the fields that need changing but disaster can always strike when playing with databases directly.