Cannot save customer edits?

I go to Customers and choose a customer to edit.  I make changes and then hit save or save and continue editing, and I get an error that a customer with this email address already exists.  I cannot edit any customer.  This is V3.9.  Can anyone help?

Perhaps you have duplicate customers, somehow.

Run this query to find out which emails are duplicated:

select Email from dbo.Customer
group by Email
having Count(Email) > 1

I just figured out what it's doing.  When I hit edit next to a user, it brings up the edit page and then the email address switches to the email address I am logged in as.  So when I hit save, it's trying to update the that I was trying to edit to my email address.

This is a bug, no?

lisab91 wrote:

Can you elaborate further on "then the email address switches to the email address I am logged in as" please?