I’m having this error when I try to test my shopping cart again using the same email. I setup my cart that a user doesn’t need to register anymore and they can automatically purchase without an account.

See my error below :

1062 – Duplicate entry ‘INSERT CUSTOMERS EMAIL HERE’ for key 2
insert into customers (purchased_without_account, customers_firstname, customers_lastname, customers_email_address, customers_telephone, customers_fax, customers_newsletter, customers_password) values (’1′, ‘FIRST NAME’, ‘AND THE LAST NAME’, ‘EMAIL ADDRESS AGAIN, ‘PHONE’, ”, ”, “DATA STRING HEREf2′)
TEP_DB_ERRORR

I knew that the customers_email_address field is set to unique. So what I did I used the mysql code below to fix the problem:

ALTER TABLE `customers` DROP INDEX `customers_email_address`

Copy , paste and Run SQL query in your phpMyAdmin.

Please let me know if you have another way to fix this problem. Thanks in advance.