Skip to:
Content
Pages
Categories
Search
Top
Bottom

Did I just loose 10k users?


  • hatherley
    Participant

    @hatherley

    Hey guys!

    Just launched our new site version but when I migrated I went from having 60k users to 50k. And I gained a huge amount of pending accounts. I really don’t know where to begin looking for the issue…

    Screenshot from dev server:
    users

    Screenshot from live site:
    users

    Anyone have a clue as to what has happened here?

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

  • shanebp
    Moderator

    @shanebp

    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


    hatherley
    Participant

    @hatherley

    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.


    hatherley
    Participant

    @hatherley

    @shanebp I did run the tool, which didn’t do anything.


    shanebp
    Moderator

    @shanebp

    How did you transfer / copy the database?


    hatherley
    Participant

    @hatherley

    A simple copy via phpmyadmin.


    shanebp
    Moderator

    @shanebp

    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.


    hatherley
    Participant

    @hatherley

    Looking in the user list, in the pending section, i do find dupes:

    dupes

    But in the DB, there’s only one entry.


    shanebp
    Moderator

    @shanebp

    It may be a WP issue.
    To confirm, deactivate BP.
    If it remains, try deactivating other plugins.


    hatherley
    Participant

    @hatherley

    Tried both, no results 🙁


    shanebp
    Moderator

    @shanebp

    Then it would seem to be a WP issue.
    Or something happened during the migration.


    dainismichel
    Participant

    @dainismichel

    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…


    heilyn
    Participant

    @heilyn

    Did you try to import using CSV plugin?


    hatherley
    Participant

    @hatherley

    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.

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Did I just loose 10k users?’ is closed to new replies.
Skip to toolbar