Deleted users still show in count?

[inder93]

I had around 6000 users on my multisite network. I deleted 4500 users directly from database with these SQL queries.

DELETE from wp_users where ID IN (1,2,3,....);
DELETE from wp_usermeta where user_id IN (1,2,3,....);

I checked from database, users are deleted successfully but in WordPress dashboard it still showing 6000 counts. When I search deleted user, it's not showing I think there is an issue with user count please let me know how to fix this.

[spacedmonkey]

Hello @inder93.

It is not recommended to delete database tables directly. You should call wp_delete_site directly. There are a number of caches that are cleared when calling this function. To fix your issue, I would flush object caches or maybe call clean_blog_cache.