Orders not displaying products ordered

Locked

Results 1 to 2 of 2

This thread is locked. New replies are disabled.

20 Dec 2010, 02:34

cryogenicz

New Zenner

Join Date:: Apr 2007
Posts:: 12
Plugin Contributions:: 0

Orders not displaying products ordered

Zen Cart Version 1.3.7

Customer places order and gets error like this:

1062 Duplicate entry '1132' for key 1
in:
[INSERT INTO ad_stats (orders_id, advertizer_id) VALUES ('1132', '3')]

And does not go to order success.

Order is inserted into order log, but does not show products ordered. shows as 0 products ordered.

What do you think is wrong?!

Thank you!

-Graham

20 Dec 2010, 02:56

cryogenicz

New Zenner

Join Date:: Apr 2007
Posts:: 12
Plugin Contributions:: 0

Re: Orders not displaying products ordered

Here's what happened (I half was solved the problem) I had deleted an order using super orders, but it did not delete an entry for the advertiser, so the next time an order was placed it errored because it could not over-write the duplicate order ID entry.

How do I fix this so It doesn't happen again. Can I make a change in the database so that it will over-write old entries if it wants to?

Thanks!

-Graham