Mailing List Archive: Interchange: users

adding column to orderline

Index | Next | Previous | View Threaded

tom at readyink

May 15, 2008, 1:15 PM

Post #1 of 3 (103 views)
Permalink

adding column to orderline

I tried to add a column to orderline table and also to the orderline.mysql
file. The checkout then failed with a generic error

Exiting log_transaction - /cgi-bin/store/process Route log failed.

Does anyone know offhand why this is? Ive never had problems adding
fields to transactions table.

Speaking of generic errors, the same 5.2 site uses the admin interface
with no problems, except "Clone Item" returns "Premature end of script
headers" for unknown reasons.

Maybe it is time to upgrade this system,

thank you in advance,
tom a - t birdphotos.com

_______________________________________________
interchange-users mailing list
interchange-users[at]icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

gert at 3edge

May 15, 2008, 1:35 PM

Post #2 of 3 (97 views)
Permalink

Re: adding column to orderline [In reply to]

> -----Original Message-----
> From: interchange-users-bounces[at]icdevgroup.org [mailto:interchange-
> users-bounces[at]icdevgroup.org] On Behalf Of tom[at]readyink.com
> Sent: donderdag 15 mei 2008 23:15
> To: interchange-users[at]icdevgroup.org
> Subject: [ic] adding column to orderline
>
> I tried to add a column to orderline table and also to the
> orderline.mysql
> file. The checkout then failed with a generic error
>
> Exiting log_transaction - /cgi-bin/store/process Route log failed.
>
> Does anyone know offhand why this is? Ive never had problems adding
> fields to transactions table.

Check below:
[item-list]Added [item-code] to orderline:
[import table=orderline type=LINE continue=NOTES no-commit=1]

Add here the extra orderline field that you added. Perhaps that solves
things
(needs catalog reconfig before it takes effect).

> Speaking of generic errors, the same 5.2 site uses the admin interface
> with no problems, except "Clone Item" returns "Premature end of script
> headers" for unknown reasons.

Sounds like a familiar bug, but can't think of what it was/is atm.

CU,

Gert

> Maybe it is time to upgrade this system,
>
> thank you in advance,
> tom a - t birdphotos.com
>
>
>
>
>
>
> _______________________________________________
> interchange-users mailing list
> interchange-users[at]icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users

_______________________________________________
interchange-users mailing list
interchange-users[at]icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

lists at gmnet

May 16, 2008, 3:17 AM

Post #3 of 3 (92 views)
Permalink

Re: adding column to orderline [In reply to]

On Thu, 2008-05-15 at 16:15 -0400, tom[at]readyink.com wrote:
> I tried to add a column to orderline table and also to the orderline.mysql
> file. The checkout then failed with a generic error
>
> Exiting log_transaction - /cgi-bin/store/process Route log failed.
>
> Does anyone know offhand why this is? Ive never had problems adding
> fields to transactions table.
>
> Speaking of generic errors, the same 5.2 site uses the admin interface
> with no problems, except "Clone Item" returns "Premature end of script
> headers" for unknown reasons.
>
> Maybe it is time to upgrade this system,
>
> thank you in advance,
> tom a - t birdphotos.com
>

edit etc/log_transaction. there is a place in there where you need to
add the new field that you just maide if want to record to the orderline
table.

rick

_______________________________________________
interchange-users mailing list
interchange-users[at]icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com