Forums / General Questions / 1062 Duplicate entry '0' for key 1 error on Customer Creation

1062 Duplicate entry '0' for key 1 error on Customer Creation

Locked

Results 1 to 2 of 2

This thread is locked. New replies are disabled.

22 Mar 2007, 11:31 AM

ccn1

Zen Follower

Join Date:: Sep 2004
Location:: London. UK.
Posts:: 152
Plugin Contributions:: 0

1062 Duplicate entry '0' for key 1 error on Customer Creation

Hi All,

We just noticed (Due to a severe lack of new customers) that when creating a new customer, we get the following error.

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

We are running on 1.3.7

Our URL to take a peek at is: https://www.boardgameclub.co.uk

Any advice would be appreciated

Many thanks in advance.

22 Mar 2007, 4:27 PM

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 177

Re: 1062 Duplicate entry '0' for key 1 error on Customer Creation

You might check to see whether the auto-increment settings are correct on all your database tables. There's a script in the zc_install/sql folder that you can assist in correcting them if needed.

If that still doesn't help, what version of PHP and MySQL and Zen Cart are you using?