Users Not Showing Up In wp-users in phpMyAdmin

I’ve been trying to figure out why I can’t sync my users in multisite to work in my subdomains. I think I have found a clue.

In wp_users there is only me - no users. There should be 129 or 130 right now.

They show up when I go into Users in Dashboard, and they are in phpmyadmin in in wp_swpm_members_tbl but they are not in users.

I think this may be my problem but I don’t know how to fix it.

Got any advice?

  • Adam Czajczyk
    • Support Gorilla

    Hello Mary,

    I hope you're well today and thank you for your question!

    I suppose that the "wp_swpm_members_tbl" is a database table for the membership plugin that you are using on your site. This is however not a "users table" in terms of WordPress database and it's used just for "internal purposes" of the plugin.

    On a Multisite WordPress install user database works in a different way than in case of a single WP site. When user signs up on a main site she/he doesn't automatically appear on a user list of all sub-sites. Yes, such a user will be assigned capabilities equal to a "subscriber role" but won't be added as a subscriber-role user.

    An example:

    - I've got a and a where is a main site.

    - user registers on a
    - user becomes a main site user and shows up on a list there (as a subscriber by default)
    - user can visit all sub-sites but is not a user of those sub-sites


    - user registers on a
    - user appears on a user list on but not on a user list for an for main

    That being said, could you please shed some more light of what your goal here is? I understand that you'd wish to synchronize users accounts but it would help a bit if I knew what's the purpose of that :slight_smile:

    Also, you may be interested in one (or both) of these plugins:

    Multisite User Management

    It lets you define default user roles for all sub-sites of your install so when user registers on any of the sub-sites she/he automatically becomes a registered user of the main site and all other sub-sites (being assigned those defined user roles).

    Join my multisite

    It's a similar tool but presenting a slightly different approach. Sub-site admins can automatically add users from across the network to their site and can also put a button on the site so those users could join (register) on their site with just one click if they already have an account on any other site of the network.

    Best regards,

  • Mary
    • Wisp of the WP Loop

    Thank you Adam. These two plugins aren't really appropriate. I am just having registration on the main site.

    What I need is a way to import my users to the sub-domains. I've tried your User Synchronization but it doesn't seem to work for me.

  • Milan
    • WordPress Wizard

    Hello Mary ,

    Hope you are well today and won't mind me chiming here. :slight_smile:

    May we access your site and see how's users are being managed there ? If that's okay to you, please grant us staff access to your site via WPMU DEV > Support > Support Access > Grant Access

    Let us know once you do that.
    Best Regards,

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.