Forums / Managing Customers and Orders / Deleted customer. Get 1062 Duplicate entry '10 for key 1 when they sign up again

Deleted customer. Get 1062 Duplicate entry '10 for key 1 when they sign up again

Locked

Started by tono on 28 Mar 2008, 9:23 AM · Views: 972

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
28 Mar 2008, 9:23 AM
#1
tono avatar

tono

New Zenner

Join Date:
Sep 2007
Posts:
2
Plugin Contributions:
0

Deleted customer. Get 1062 Duplicate entry '10 for key 1 when they sign up again

Hello, I was delete a customer from Admin-Customer, then I try re-sign up with same information (email, name etc), then appear on the screen text like this :

1062 Duplicate entry '10 for ket 1
in:
[insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('10', '0', now())]

Then I tries:

  • optimizing the database after deleting a customer from Tools - Store manager, and...
  • sign up again with the same info

but the text above still shown. I am use Version 1.3.7.1. Do you have ideas?

Thanks
Tono