Why are my roles not visible in a Multi-site/Network?

  1. Determine your Multisite Blog ID. I will use 99 as an example
  2. Go into the database
  3. Go to this table: wp_##_options (wp_99_options) — you will have a table for each blog
  4. Find the record where option_name = wp_user_roles
  5. Change the text wp_user_roles to wp_##_user_roles (“wp_99_user_roles”)

The table you are editing will have option_id, blog_id, option_name, option_value, autoload. However, DO NOT CHANGE ANY RECORD except the record where option_name = wp_user_roles. There will only be a single record in this table like this.

wp_user_roles is used when there is no Multisite install, and here, it appears as though it was just a bug when the table was created.

Related Posts:

  1. Prevent user creating new users with specific roles
  2. WPMU – new users are automatically subscribed to the main blog – how to prevent that?
  3. Update User Role Across Network when Main Site User is Updated
  4. Assign role to user on first login, if they are first (after admin)
  5. Get the User ID Who Owns a Given Blog ID in Multisite
  6. Make a user administrator to a sub directory site and a contributor to main site in multisite network
  7. How to change user starting role in WordPress MultiSite?
  8. Create Custom Multisite User Role to Reduce Capabilities
  9. Copy user role on multisite so the user can access subsites with same role
  10. WordPress Multisite Add User
  11. can’t create user without email for an author after converting single site to multisite
  12. Easily adding multiple existing users to a multisite site
  13. A different role for each site in a multisite
  14. How to create child/sub user under parent user
  15. How create a multisite setup with “phantom” accounts and passwords?
  16. Is there any way to give all users access to one blog in a multisite network without using a plugin?
  17. How To Add Custom Form Fields To The User Profile Page?
  18. Where are available Roles Defined in the wp_ database?
  19. Where can I find documentation on what characters are allowed in user names and why?
  20. Is there a is_user_logged_in() for multisite?
  21. WordPress Multisite allow site admin to add user without email confirmation
  22. Network not displaying all sites and users
  23. How to use alias domain for multisite installation?
  24. Issue with Custom Roles in Multisite
  25. Give to site admin the option to “skip confirmation email” when adding new user
  26. How to enable a site administrator to edit users in a WordPress network/ multisite setup?
  27. Different back-end colour scheme for the different sites of a multisite
  28. How can I display all Multisite blogs where this user is administrator?
  29. Restrict users on multisite WordPress install
  30. Possible to make custom role in multisite that can add sites?
  31. Allowing logged in users to comment without moderation across a multisite installation
  32. Can you have multi-site WP and keep users separate?
  33. WordPress Multisite Layered Admins
  34. How to add multiple existing users to a multisite site?
  35. How to get a user role of a specific blog in multisite?
  36. the blog owner multisite
  37. How can I get multisite primary blog (url or path) for current user?
  38. Can I use multisite functions in a single-site installation?
  39. How to add edit users capability to a custom role?
  40. How can I delete a user from entire multisite nework
  41. delete_user_meta : how to delete all the metadata of a given user (witout SQL)
  42. How to search users globally on a multisite install?
  43. Within the database, where is the flag which says that a user has Super Admin rights?
  44. Avoid having infinite loops
  45. Create custom role, multisite, add users/sites?
  46. Displaying a message upon user registration
  47. Query users by capability – uninstall/deactivate callback
  48. access the plugins for each role in WordPress multisite
  49. Allow Author on Site A capability to upload files on Site B in Multi Site
  50. Multisite – One user allowed access to all sites?
  51. Add a user to a specific blog when they register?
  52. Good way to block users within a multisite setup without deleting them?
  53. Subsite access without being a member of the subsite in wp multisite network
  54. Multisite user roles – capabilities not working
  55. WordPress stuck in deleting user
  56. Restrict Capability of Administrator to Create, Edit and Delete Pages in Multisite
  57. How to display users with posts published between two dates (Sorted by Post-Count) [Multisite]
  58. Multisite – maximum number of users with specific role
  59. Understanding State in WordPress Multisites
  60. Remove superadmin role from the “change role to” menu in user listing
  61. How to change a user role after registering in multisite?
  62. How To Disable Add new users On Subsites In Multisite?
  63. How to sync roles across Multisite?
  64. Wait ajax to complete before continue loop
  65. Delete user from multisite when removed from subsite
  66. Combining user database tables while keeping all other data in seperate for multiple sites?
  67. Multisite network admin – User’s role not showing up
  68. How to delete user from MU site when the user is removed from their site?
  69. Sharing users across multiple sites, each on their own database
  70. WordPress multisite, allow non super admins to create sites
  71. How to share User Database between Two Multisite Installations + More
  72. Creating teams of users in WordPress
  73. Give users acces to admin a single post or set up WP network?
  74. Restrict users of site 1 to login in site 2 in wordpress multisite
  75. “My Sites” incorrectly showing all network sites for all logged in users
  76. Language per user role, how can I achieve this?
  77. Admin users not able to see network menus
  78. Possible to have duplicate usernames on different two multisites
  79. Multisite – each site with it’s own set of users
  80. User Roles in multisite – odd behavior
  81. Users getting linked unwanted to main mu in WordPress multisite (WPMU)
  82. Multisite – site user limited only for this site
  83. WordPress single sign on using cookies with shared user role functionality between more than 2 wordpress subdomains
  84. Importing Posts into New Website with Same User ID’s
  85. WordPress automatic Login on other page?
  86. Is Multisite the RIGHT option for my case?
  87. Should I use MultiSite for a subdomain based wp site?
  88. Multisite “Skip Confirmation Email” Log Out Problem
  89. Get current user outside of WordPress Multisite
  90. Multisite vs Role Scoper
  91. WordPress MU users – how are they organized?
  92. Get users from all/specific blog by user_role and current_user role
  93. How can I display all Multisite blogs where this user is administrator?
  94. How to give “author” user role appropriate capabilities to add PollDaddy polls? WordPress multisite
  95. Multisite and users being listed on network administration dashboard and not main site dashboard
  96. Using a number for limiting registering or banning on multisite
  97. Unsure of my options, Multi-blog?
  98. WordPress Multisite (Network) some site users added to main site users list as subscriber
  99. WordPress Multisite restict user access
  100. Multisite Login Access Restrictions

Leave a Comment