Support » Fixing WordPress » transferred my blog, there’s no superadmin

  • AliKat


    I had a wpmu 2.9.2 install that i upgraded to 3.0 – I then took a mysql dump of one of my sites and imported it into a wp 3.0 installation. To achieve this I deleted a few of the tables from the fresh install, then did find replace on various values to match the new domain (wp_7 prefix became just wp_, etc) and imported the sql back into the DB.

    Everything worked except there is no superadmin. There is only one user, admin, but seems I can not install new plugins from the backend, or access certain options (you do not have sufficient privellages) I also don’t have the option to update (re-install) wp from the backend.

    Can someone please tell me what table and values I need to change in my DB to fix this? Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)
  • AliKat


    also, when i try to navigate to /wp-admin/update-core.php i get:

    “You do not have sufficient permissions to access this page.”

    Andrew Nacin


    Lead Developer

    I imagine you went through a Tools > Network upgrade? If not, then you’re missing network-level tables like wp_site, wp_blogs, and wp_sitemeta, no?

    It’s the site_admins meta key in the wp_sitemeta table, corresponding to the site_id as it exists in wp_site (you likely only have one row in that table).

    It’s serialized, and stores the user_login. array( 'admin' ) looks like a:1:{i:0;s:5:"admin";} when serialized.

    Additionally, you can hard-code your super admins in wp-config.php with $super_admins =array( 'admin', 'nacin' ); but note that this will then remove all UI for managing super admins (i.e. no checkbox on user-edit.php) and the DB will be ignored.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘transferred my blog, there’s no superadmin’ is closed to new replies.