[ic] adding fields to transaction table

ic at 3edge.com ic at 3edge.com
Mon Nov 6 05:38:36 EST 2006

graham hadgraft writes: 

> Can someone explain this message please.  I have added a field to the
> end of the transactions table and have added this field in the imnport
> tag of log_transaction in the retc folder however when someone tries
> to place an order this error is thrown. 
> There were errors in your last submission: 
>    (log_orderline_table): There was an error adding the order to the
> transaction table. It was: import into transactions failed:
> DBD::mysql::st execute failed: Column count doesn't match value count
> at row 1 at 
> /home/httpd/vhosts/clearly-av.co.uk/interchange/lib/Vend/Table/DBI.pm
> line 1396, chunk 1. 
> Please correct the areas listed above which are highlighted in this
> color in the form.

Sounds like your Mysql DB is not in sync with what you try to put into it in 
etc/log_transaction. Have a check on your DB table (describe orderline) and 
see if your field is actually there. Did you restart IC at any point? 



More information about the interchange-users mailing list