[ic] Orders not matching up with users in the UI

[Cameron]

----- Original Message -----
From: "Paul Jordan" <paul@gishnetwork.com>
To: <interchange-users@icdevgroup.org>
Sent: Monday, January 20, 2003 3:06 AM
Subject: RE: [ic] Orders not matching up with users in the UI


> > I've just gone live with a site and taken some orders, but in the UI,
i'm
> > finding some weird stuff. Viewing the Pending Orders section shows all
the
> > orders with the appropriate Order number, yet clicking on that
> > order number
> > brings up the View Order page, but with none of the details filled in!
The
> > order has definately been entered into the Orderline table, and
> > the customer
> > definately exists in the user table, so what could be causing the
> > View Order
> > page to break in this manner?
> >
> > Note: if i bring up the View Customer page, the order numbers associated
> > with the client are all wrong. I did at one stage change the Last order
> > number on the administration page (it has TEST in the number), and
yeah...
> > things seem to have gone pear shaped. Any idea where this may be
breaking
> > and what i need to do to fix it?
>
>
> Hi Cameron,
>
> If I remember correctly, didn't you build a log_transaction from scratch?
> This sounds to me like data is not getting written correctly to the
tables.
> I say *correctly, becuase you mention that there is data getting written
to
> these tables. The Order View page does not read from userdb, as you imply
> above, it reads the written data that was copied into transactions table.
>
> Try posting your IC version, and a couple records from 'transaction' and
> corresponding 'orderline'...
>
> It sounds to me like this is a log_transaction issue. Compare it to a
> foundation copy.
>
> Paul
>

v 4.8.6
Transaction:
       101010   101010  HAesHaq9  U00008  worldwide (Worldwide Delivery 7-10
days US$ 35.00)  1  283  35    318  first  last   address   suburb  state
zip  US  phone    email        AL   US   20030119 19:10:18  20030119  7
pending     0  0  0


Orderline:         101010-1  1904  Item Name 283  1  283



looks right to me :/