What do you mean by migrated?
Transferred to a new install?
Upgraded to a new version of BP ?
Both?
Did you use any of the tools in the new version:
…/wp-admin/tools.php?page=bp-tools
I transfered to a new install.
I should mention that my email newsletter application, has 71,463 members registered. It registers all users signing up.
@shanebp I did run the tool, which didn’t do anything.
How did you transfer / copy the database?
A simple copy via phpmyadmin.
Based on your screenshots, I’d guess users were added or duplicated.
Try comparing the total number of rows, dev vs. new install, for the users and activity tables.
Looking in the user list, in the pending section, i do find dupes:
But in the DB, there’s only one entry.
It may be a WP issue.
To confirm, deactivate BP.
If it remains, try deactivating other plugins.
Then it would seem to be a WP issue.
Or something happened during the migration.
look at multiple ways of importing the users.
investigate the DB itself and make changes directly in the DB via SQL queries.
create dev environments in which you export/import using various methods.
probably the direct use of the DB itself will be the most reliable.
check the original DB re duplicates.
best wishes!
ps: these are just a few off the cuff suggestions…maybe it’s another issue…maybe upon import a particular parameter on users forces them to become “pending.” you can either fix it before you import or after. or go via the DB and not any kind of “user import” feature…
Did you try to import using CSV plugin?
Pending users are being duplicated for no reason, but they aren’t actually pending in most cases. They’ve had their accounts confirmed. I’ve checked with the old WP install, they are confirmed before we migrated – But went into the pending section when we imported the db.
Then the 10k missing users, they are in the DB – they’re in the standard wp_users table.
But somehow they’ve ended up in the pending section, just that there is 3-4 times duplicates of them.
And it seems to be all due to the miscommunication between WP and BP.
I think I need to clean up the pending table…
@heilyn we can’t use CSV because of the number of users involved.
