1062 - Duplicate entry '2' for key 1

[Andge]

Hi,

 

I just emptied my customer, address and orders database tables and now when I try to create an account I get this error after entering my info:

-----------------------------------------------------------------------------------------------------

1062 - Duplicate entry '2' for key 1

 

insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('2', '0', now())

 

[TEP STOP]

-----------------------------------------------------------------------------------------------------

How do I fix it?

 

Thank You,

Andrew

[OceanRanch]

Sounds like you didn't empty the customers_info table when you emptied the other three tables. There was probably an entry for #1 and #2 already in the customer_info table. Try truncating it via phpmyadmin.

 

HTH

Tom

[Andge]

Sounds like you didn't empty the customers_info table when you emptied the other three tables. There was probably an entry for #1 and #2 already in the customer_info table. Try truncating it via phpmyadmin.

 

HTH

Tom

<{POST_SNAPBACK}>

 

Okay, thanks.

 

Andrew.