v1.3.7 error at customer registration

[oidahabara]

I realized errors with customers order confirmation, than I checked customer registration and get this error message

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

I found smething about and understand that its a problem with data base, but my english is too poor and it seems to be a rather complicated matter.

Could somebody explain me in simple way, what I can do to solve this problem? Which tables could I replace?( its no problem if I loose customers datas).

[eurojen]

Hi oidahabara

The Statement means that you are inserting into the table customers_info the value 19 for the field customers_info_id and the value 0 for the field customers_info_number_of_logons and the current date/time for the fieldcustomers_info_date_account_created

The duplicate entry 1062 error message suggest that you already have a customer with and id# of 19. If you go to admin - customers - customers and check to see if you already have a customer with id 19.

If you are creating a new customer then this customers_info_id should be automatically set to the next number.

I'm not sure if your cart is live or how many customers you have, but you could back up your database and try to delete the current customer #19 and then see if your problem is resolved.

Hope that helps

Jen

[BREZ]

Try this fix...

http://www.phpbb.com/kb/article/how-...%2Bquot-error/

[pricediscrimination]

Try this fix...

http://www.phpbb.com/kb/article/how-...%2Bquot-error/

Has anyone tried this fix? Does it work?

[ellivir]

Has anyone tried this fix? Does it work?

You have to modify it to work with ZenCart since that is done for phpBB but that's the idea, yes.

Elli