[ic] "Error during creation of order routing log"

Adrian P Wilkinson interchange-users@icdevgroup.org
Mon Mar 24 11:40:01 2003


Hi,

I'm running Interchange V4.9.7-200303010658 and received the following error
when I just tried to place an order through the customer-facing site:

Customer Error
--------------

(log_orderline_table): There was an error adding the items to the orderline
table: import failed: DBD::mysql::st execute failed: Duplicate entry
'200303240002-1' for key 1 at /usr/local/interchange/lib/Vend/Table/DBI.pm
line 1364, chunk 1.

~/catalogs/invincible/error.log
-------------------------------

[host].blueyonder.co.uk K5yEkdTK:co.uk - [24/March/2003:16:26:07 +0000]
invincible /invinastore.cgi/process.html Route log failed.
[host].blueyonder.co.uk K5yEkdTK:co.uk - [24/March/2003:16:26:07 +0000]
invincible /invinstore.cgi/process.html ERRORS on ORDER 200303240001:
> Error during creation of order routing log:
> Route log failed. at /usr/local/interchange/lib/Vend/Order.pm line 1736.
>

Other than the product data, nothing has been changed since the last time I
was able to sucessfully place an order.  Any idea what might have caused
this and a possible resolution?

Regards, Ade.