Zen Cart Logo
Forums / Managing Customers and Orders / Customer account creation error

Customer account creation error

Locked

Views: 1,168

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
14 Dec 2011, 3:53 PM
#1
michaelchu avatar

michaelchu

Zen Follower

Join Date:
Nov 2011
Posts:
121
Plugin Contributions:
0

Customer account creation error

When I tried to test my new store with the first order by creating a new customer account I received this error:

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

Any ideas? Thanks.

14 Dec 2011, 4:33 PM
#2
michaelchu avatar

michaelchu

Zen Follower

Join Date:
Nov 2011
Posts:
121
Plugin Contributions:
0

Re: Customer account creation error

I'm wondering if the Master Password module I installed had caused this?

25 Dec 2011, 4:41 PM
#3
michaelchu avatar

michaelchu

Zen Follower

Join Date:
Nov 2011
Posts:
121
Plugin Contributions:
0

Re: Customer account creation error

No one has seen or know of this error befor? Any suggestion woud be greatly appreciated.

25 Dec 2011, 6:11 PM
#4
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,693
Plugin Contributions:
56

Re: Customer account creation error

It means you've been hand deleting or adding entries to one of the tables (perhaps customers). Don't do this.

26 Dec 2011, 12:05 AM
#5
michaelchu avatar

michaelchu

Zen Follower

Join Date:
Nov 2011
Posts:
121
Plugin Contributions:
0

Re: Customer account creation error

Thank you for the reply. I have only deleted the test customer from the admin area. I do not know how how to hand delete entries, not sure how I would have done that by accident. But regardless, how would I correct the issue currently, as this error occurs anytime a new customer tries to create an account? Thanks.

26 Dec 2011, 2:04 AM
#6
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,693
Plugin Contributions:
56

Re: Customer account creation error

You already asked that question over here:

http://www.zen-cart.com/forum/showthread.php?t=189938

Please follow up to that thread. It's confusing when you open multiple threads on the same problem.