Deleted Users Still showing in total box

  • Even though I have deleted the 622 additional users from my client’s site and they are no longer showing the totals area at the top says there are 622 subscribers. It used to have a forum attached to it but its been deleted because it was just full of spammers.
    Any ideas on how I can reset the totals?

    Many thanks

Viewing 2 replies - 1 through 2 (of 2 total)

  • Have you read any of these?

    found it to be caused by the fact that I deleted some users directly from the database, omitting to also delete their meta_values. Orphaned meta_values it’s called

    You bbpress forum or which ever you used will have created user meta, and this perhaps was not deleted when deleting the users. The count looks at the user meta.
    BE SURE TO BACK UP YOUR DATABASE FIRST!!!
    SQL :

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

    Thread Starter Joselena

    (@joselena)

    Thank you.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Deleted Users Still showing in total box’ is closed to new replies.