Title: Missing user roles on mutlisite
Last modified: August 22, 2016

---

# Missing user roles on mutlisite

 *  Resolved [Tom Belknap](https://wordpress.org/support/users/dragonflyeye/)
 * (@dragonflyeye)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/missing-user-roles-on-mutlisite/)
 * Wow, people. This is a lot. It’s been a heck of a day…
 * I’ve been using WordPress forever and was a WPMU user prior to the merge… which
   was a long time ago. But my primary blog never reverted to the wp_table format
   instead of the wp_1_table format. Having noticed a problem with the multisite
   functionality – which has been sitting dormant for quite a while – I ended up
   completely screwing everything up.
 * The solution after much consternation was to just manually rename all my main
   blog tables. That worked, hurray!! But then my limited blogging account (as distinct
   from my super admin account) couldn’t log in anywhere.
 * That’s because it had no role on any blog, nor did any other user. And just like
   many, many other posts here, I was missing the list of user roles that would 
   have allowed me to correct the problem.
 * After reading a few posts, I figured out that it must be iThemes Security that’s
   the issue, so i turned that plugin on, hoping that it would restore the roles.
   And hurray!! looking at the user tables, everything looked back to normal.
 * But alas, I still couldn’t login and I still don’t have my list of roles.
 * I’m not sure what to do next. I have not seen iThemes Security specifically mentioned
   as a reason for this problem, and other issues seem to have concerned Capabilities
   Manager, which creates a table of capabilities. Any idea what I can do, besides
   deleting my account and rebuilding, that would help?

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

 *  Thread Starter [Tom Belknap](https://wordpress.org/support/users/dragonflyeye/)
 * (@dragonflyeye)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/missing-user-roles-on-mutlisite/#post-5309314)
 * UPDATE: comparing to another multisite installation that I own, I noticed that
   there is a user meta value called wp_capabilities, which of course in my installation,
   is called wp_1_capabilities. I switched that meta key to the correct parlance
   and… no luck.
 * I’m assuming there must be a place in the database where the capabilities live,
   but I’m not seeing it?
 *  Thread Starter [Tom Belknap](https://wordpress.org/support/users/dragonflyeye/)
 * (@dragonflyeye)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/missing-user-roles-on-mutlisite/#post-5309320)
 * **UPDATE OF AN UPDATE:**
 * After digging up [this article](http://wp-relief.com/2011/12/01/user-roles-in-the-wordpress-database/),
   I discovered the problem.
 * Just as with the above noted user meta table problem, _there are values in the
   wp\_options table that also refer to “wp\_1,” including the wp\_1\_user\_roles
   option_, which lists out all capabilities on the site. **Change that back to 
   the correct wp_ format – that is: rename the option_name from “wp_1_user_roles”
   to “wp_user_roles” – and all is well.** S’pose I’ll have to do the same with 
   all the other values, too.
 * Hope anyone else searching finds this post helpful.
 *  Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/)
 * (@ipstenu)
 * 🏳️‍🌈 Advisor and Activist
 * [11 years, 8 months ago](https://wordpress.org/support/topic/missing-user-roles-on-mutlisite/#post-5309463)
 * Out of curiosity, in your wp-config.php do you have BOTH defines for WP Multisite
   activation?
 *  Thread Starter [Tom Belknap](https://wordpress.org/support/users/dragonflyeye/)
 * (@dragonflyeye)
 * [11 years, 8 months ago](https://wordpress.org/support/topic/missing-user-roles-on-mutlisite/#post-5309467)
 * Meaning WP_ALLOW_MULTISITE and MULTISITE. Yes, sir.

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

The topic ‘Missing user roles on mutlisite’ is closed to new replies.

## Tags

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

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 4 replies
 * 2 participants
 * Last reply from: [Tom Belknap](https://wordpress.org/support/users/dragonflyeye/)
 * Last activity: [11 years, 8 months ago](https://wordpress.org/support/topic/missing-user-roles-on-mutlisite/#post-5309467)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics