Deleted users in phpMyadmin but they're not deleted in dashboard

  • I recently updated a site I hadn’t been editing in a while. It had accumulated 37,000+ users- mostly spam. Because it was a newly updated site we decided to delete all of the subscribers and only keep the administrators and authors. I manually deleted the 37,000+ subscribers in phpMyAdmin. They no longer show up in the users>subscribers- it says no subscribers found. But in the top bar it still shows them in parenthesis by subscribers. And I have a newsletter plugin that wants me to upgrade because of this large number. How can I get that to the correct new subscriber number?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator bcworkz

    (@bcworkz)

    Did you clean out the corresponding usermeta entries? This is where the counts are determined by doing a count query for each role.

    Thread Starter weezieb

    (@weezieb)

    I guess I didn’t do that. I’ll take a look! Thanks so much for responding. I’ll post back if it works. Thanks again!

    How can I delete the user_meta in bulk using phpMyadmin I’d hate to have to page through 1000 records and check each by hand.

    Dion

    (@diondesigns)

    If your tables are named wp_users and wp_usermeta, then the following query on your WordPress database will remove usermeta from users you previously deleted in the wp_users table:

    DELETE FROM wp_usermeta WHERE user_id NOT IN (SELECT ID FROM wp_users)

    Adjust the table names if your table prefix is something other than wp_. If you have more than a couple hundred users in the wp_users table, this query could take a while to run.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Deleted users in phpMyadmin but they're not deleted in dashboard’ is closed to new replies.