Title: Problems Downgrading From Multisite
Last modified: August 21, 2016

---

# Problems Downgrading From Multisite

 *  Resolved [John Blanchard](https://wordpress.org/support/users/johnblanchard/)
 * (@johnblanchard)
 * [13 years ago](https://wordpress.org/support/topic/problems-downgrading-from-multisite/)
 * 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)](https://wordpress.org/support/users/ipstenu/)
 * (@ipstenu)
 * 🏳️‍🌈 Advisor and Activist
 * [13 years ago](https://wordpress.org/support/topic/problems-downgrading-from-multisite/#post-3852256)
 * > 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](https://wordpress.org/support/users/johnblanchard/)
 * (@johnblanchard)
 * [13 years ago](https://wordpress.org/support/topic/problems-downgrading-from-multisite/#post-3852258)
 * 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](http://cl.ly/PkgS)
 *  Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/)
 * (@ipstenu)
 * 🏳️‍🌈 Advisor and Activist
 * [12 years, 12 months ago](https://wordpress.org/support/topic/problems-downgrading-from-multisite/#post-3852281)
 * 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](https://wordpress.org/support/users/johnblanchard/)
 * (@johnblanchard)
 * [12 years, 12 months ago](https://wordpress.org/support/topic/problems-downgrading-from-multisite/#post-3852284)
 * 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.

## Tags

 * [admin](https://wordpress.org/support/topic-tag/admin/)
 * [multisite](https://wordpress.org/support/topic-tag/multisite/)
 * [users](https://wordpress.org/support/topic-tag/users/)

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 4 replies
 * 2 participants
 * Last reply from: [John Blanchard](https://wordpress.org/support/users/johnblanchard/)
 * Last activity: [12 years, 12 months ago](https://wordpress.org/support/topic/problems-downgrading-from-multisite/#post-3852284)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics