Skip to content

Duplicate user emails when making large numbers of users #155

Description

@CactusWren2020

When I make large numbers of users (1000+), some user emails will be duplicated. This is problematic since Wordpress doesn't allow multiple users with the same email.

The rate of duplicate emails may be on the order of 2/1000.

One way of fixing this might be implementing a query for duplicate emails like:
select user_email, count(user_email) from wp_users group by user_email having count(user_email)>1;

and then deleting n - (n - 1) of the resulting duplicates.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions