• Resolved John Blanchard

    (@johnblanchard)


    I am setting up a new site which was formerly a multisite install. I have gone through everything I can find on downgrading from multisite, and have followed all the steps. My WordPress install still shows no admin controls, and I am unable to add or delete users, update WordPress, install plugins, etc.

    I have completed the steps below and still do not have the proper admin access, even with newly created admin users through phpMyAdmin:

      Remove all the lines added to wp-config.php
      * Revert back to older .htaccess file or delete it and regenrate it by going to Settings > Permalinks
      * Remove the two fields added to the users table that are multisite-only (deleted and spam columns).
      * Remove the following tables in database
      (prefixed by your DB prefix which is generally wp_):
      o wp_blogs
      o wp_blog_versions
      o wp_registration_log
      o wp_site
      o wp_sitemeta
      o wp_signups
      o wp_sitecategories (if you have global terms enabled)

    I cannot find anything in phpMyAdmin or the actual WordPress install that shows any multisite data is left. I’m out of options and am hoping someone can come up with something to help me out.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    My WordPress install still shows no admin controls, and I am unable to add or delete users, update WordPress, install plugins, etc.

    Are you 100% sure you’re an admin on the site?

    Go in via mySQL, pop open the wp_usermeta table, find your ID, and toss this in for meta_value: a:1:{s:13:"administrator";b:1;}

    Thread Starter John Blanchard

    (@johnblanchard)

    Yes, I have even created two new Admin users to be sure. Still no luck.

    Here’s a link of what the user properties are currently:
    http://cl.ly/PkgS

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    Okay, go into wp_options and look for “wp_user_roles”

    MAKE SURE that “wp_user_roles” matches your table prefix. So if your names are named wp_aygwre6723_ then it’ll be wp_aygwre6723_user_roles and so on.

    Also what plugins are you running?

    Thread Starter John Blanchard

    (@johnblanchard)

    That worked. I was able to go in and change the wp_user_roles to match and the admin controls are restored.

    Thank you!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Problems Downgrading From Multisite’ is closed to new replies.