Number of Users in WP is different than in Database HUH?

  • On the USERS main screen in WP dashboard, I show 547 total users. In my php users database (cPanel), I show 422. Anyone have any idea why the difference? And how can I bring the totals into alignment?

Viewing 1 replies (of 1 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    You may have users in wp_usermeta who are not in wp_users. See if that’s the case with this SQL:

    SELECT user_id FROM wp_usermeta WHERE user_id not in (select ID from wp_users)

    You can do that as query in phpmyadmin

    If you find them then you may have been hacked or had a database crash.

Viewing 1 replies (of 1 total)
  • The topic ‘Number of Users in WP is different than in Database HUH?’ is closed to new replies.

Tags