All Members Count on Site-Wide Activity is Wrong

[William]

I accidentally left a site I’m working on open to membership by anyone, and it got hundreds of spam memberships. I removed all the spam members, and now there are only my admin account and the test accounts I’ve set up left; but ALL MEMBERS on the Site-Wide Activity page shows 405 members.

Everything else seems to be OK — I can’t figure out where to fix this, presumably there’s a field in the database that contains this value but I can’t figure out where it is.

Active BP=related plugins: BUddyPress, BP Group Documents, BP Profile Search, BuddyBoss Inbox, BuddyBoss Media, BuddyBoss Wall, BuddyPress Edit Activity, BuddyPress Group-O-Matic Pro, BuddyPress XProfile Custom Fields Type. Theme is Boss. child theme + Boss. WP, the plugins, and the theme are all up to date.

Anyone have an idea where to look in the DB to fix this (or know of another fix for the problem)?

[William]

On the Groups page and on the individual groups, the group counts are correct — it’s just on the Site-Wide Activities page where the total user count is incorrect.

[Anonymous]

Hi

bp_get_total_member_count() function is used to get count

You will need to create wp-user and wp-usermeta tables

bp_core_get_active_member_count()

http://oik-plugins.eu/buddypress-a2z/oik_api/bp_core_get_active_member_count/

Above link will give you can idea which tables need to be cleaned
Regards
Varun Dubey

[William]

Perfect – I’ll have a look at the tables based on the code on the bp_get_total_member_count page, and post the results of my cleanup.