Had the same problem.
The issue was in wp_options table.
Find line where option name is wp_user_roles and look what’s going on there. This line is responsible for user roles, and if they are an a mess, users canot be shown as well.
Better copy option_value from the other table.
(Change wp_ to your prefix).
Related Posts:
- How do I remove/delete an old super admin user?
- Setting up a wordpress network with third level domains
- How will self-hosted WordPress work with Google Page Speed Service?
- Troubleshooting a “You do not have sufficient permissions to access this page” error
- Benefits or Problems for using Sub-Directory vs Sub-Domain install of WP Network
- What methods should be used to fend off splogs in a multiuser install? [closed]
- WordPress 3 Multisite using subdomains.- DNS on Cpanel question
- Remove Site Name from register form – Multisite
- Set up collaborative site
- How to disable Multisite sign-up page?
- How To Provide Sub-Blogs Their Own Domain Names?
- Add role across network in multisite
- “You need a higher level of permission” after admin changing. Why?
- Advanced Custom Fields Multisite Upload/Imagery Issue [closed]
- NGINX Multisite Rewrite rules
- On Multisite: Loop to Show First Four Images of Recent Posts Across Network
- “Preview Changes” button doesn’t show changes for previously published posts/pages
- Tax_query not working on multisite
- Can I manage more wordpress sites with one wordpress administrator page? [closed]
- Add menu page on multisite
- Subsites in Multisite installation throwing 404 error on wp-admin in IIS 7
- Identical members roles on all sites in a multisite
- Fixing media links after importing to multisite
- WP-CLI can’t list posts
- htmll lang=”de” but admin page in English
- Woocommerce and different checkout field for different countries
- Why is multisite rest API keep giving me results for root site only?
- How to stay logged in on a multisite with different domains?
- wordpress multisite subsite rewrite rules not working for videos
- What should I do? A multisite, a single website or many websites? [closed]
- Dissolve Multisite while making site #5 the main site?
- Can a user spread virus on my Multisite?
- Disabling outbound connectivity on web servers [closed]
- Use another author.php if different multisite subsite?
- “Organize my uploads into month- and year-based folder” Option Not Visible in Multisite
- Multisite installation not in root – how to make live?
- Can’t view network plugins.php or upgrade-core.php on multisite
- Can I use WP to create a multisite importing the posts of 3 old WP website?
- Configuring multi-site with domain mapping
- Multisite theme control not working
- Copy Root Multisite Site
- WordPress Multisite domain mapping with different IPs
- Howto disable comment moderation emails for admins, but not for authors
- Multisite: Retain awareness of what posts came from which site?
- Merge Multisites with Shared Network Media Library
- Multisite – Lost Password Link is for wrong site
- Multisite – Looking for ideas to best manage a main site change
- Change Administrator to Super Administrator (multi-site)
- My subdomain on WordPress Multisite has gone
- Automatically login user across multisite
- Removing Mutlisite lines stop DB connection
- Renaming admin user on multisite install by MySQL
- Multisite WPLANG won’t save
- How to display users with posts published between two dates (Sorted by Post-Count) [Multisite]
- How to move a WordPress multisite?
- get_option( ‘home’ ) not returning value in database
- Contact Form 7 in Multisite [closed]
- I want to create a 300 multi-site wordpress network using subdomains
- Update blog option during create new blog?
- Cannot select signup_meta upon multisite user activation
- Create “/blog” sub-site on WP multisite network
- Share contents/posts between sites in a WordPress 5.6
- Create a CSS file in plugin folder when theme is activated
- $wpdb->update prefixes database name to table when executing query
- Wait ajax to complete before continue loop
- switch_to_blog() not functioning while querying post_types, Why?
- Multisite default theme and child applied to network
- Change WordPress Multisite Domain
- Remove W3 Total Cache minified files on custom page outside of WordPress [closed]
- Pros and Cons of Post Types vs. Multiple Blogs
- Multisite sites output on a single page
- Multisite cookies are being shared across domains unwanted
- multisite – unable to connect to network administration
- Restrict users of site 1 to login in site 2 in wordpress multisite
- Unable to execute Ajax request, status code 400
- A database for each category?
- Redirect a WordPress Multisite url after it has been change to a new one
- How to make the redirects right? IP to domain name folders
- WordPress multisite redirect one custom non www domain to www
- Multisite issue
- How to Add Super Admin for WordPress multi-site
- Max number of sub folders
- Can’t access 2nd site (sub) dashboard of WordPress Multisite
- wordpress multisite config issue needs help
- what if one user in WPMU change the theme files?
- Multisite read_more link displays URL twice
- WordPress and SQL – Update and Insert from another table if column value doesn’t exist
- Multisite: Run a subdomain install from a directory install
- Network – My sites are unavailable
- Plugin data shared in Multisite
- Remove blog slug from WPMU?
- WordPress multisite and one database
- Planning on Multisite Before Creating A Network
- Registration Page
- Can admins on network install view and edit users accounts?
- Unsure of my options, Multi-blog?
- WordPress Multisite with HTML template as Root
- WordPress Multisite (Network) some site users added to main site users list as subscriber
- Trying to create site-wide Active Directory sync with Multisite
- different image for mobile template block theme