[ic] Re: Order Problem when too many items in cart - Resolved

[Sheamus Nulty]

----- Original Message -----
From: "David Black" <DavidBlack@theWaveCave.com>
To: <interchange-users@interchange.redhat.com>
Sent: 08 January 2002 19:08
Subject: [ic] Re: Order Problem when too many items in cart


> > From: "Sheamus Nulty" <snulty@celticlinks.com>
> > To: <interchange-users@interchange.redhat.com>
> > Date: Tue, 8 Jan 2002 14:35:09 -0000
> > Subject: [ic] Order Problem when too many items in cart
> > Reply-To: interchange-users@interchange.redhat.com
> >
> > Folks,
> >
> > I've come across a problem which at the moment I'm unable to fix.
> Basically,
> > when I try to add an order to my system which has more than 9 line items
> in
> > the basket the checkout page is returned with no error. The following
> > information is logged to the error log
> >
> > 62.17.148.65 x4VhzwYP:62.17.148.65 - [08/January/2002:13:24:44 +0000] cl
> > /cgi-bin/cl/process.html Route log failed.
> > 62.17.148.65 x4VhzwYP:62.17.148.65 - [08/January/2002:13:24:44 +0000] cl
> > /cgi-bin/cl/process.html ERRORS on ORDER CL0201080003:
> > > Error during creation of order routing log:
> > > Route log failed. at /usr/local/interchange/lib/Vend/Order.pm line
1543.
> >
> > >From the Administration system I can see that the order was actually
> added
> > but only a total of 9 line items have been added to the orderline table.
> > I've checked my mysql logs and its not reporting any errors as it seems
> that
> > only 9 items have been requested to be added.
> >
> > I've turned on debugging and I can't seem to find any more information
as
> to
> > why the route log is failing as the import  information diplayed in
debug
> is
> > the same for the entries that don't get added to the database.
> >
> > I would really appreciate any help to try and resolve this matter. I'm
> > running Interchange V4.8.2 on Redhat 7.0 with mysql 3.23.41
> >
> > Thanks
> >
> > Sheamus
>
> I just tested my system, and apparently, I'm having the same problem.
> I can't find any references to "Route log failed" in the archives, though.
> Has anyone else encountered (and hopefully, solved) this problem?
>
> Regards,
> --
> David Black
>
After much debugging, it came down to a stupid little mistake on my part.
Basically, when I changed our order numbering I forgot to extended the code
field in the orderline table. So basically when the system tried to enter
the 10th item i.e. CL0110020088-10, its code was the same as the 1st item
i.e.  CL0110020088-1 because the 0 was being dropped as the code field was
only 14 characters. To resolve the problem just extend the orderline code
field as you desire.

Regards

Sheamus