[ic] log_transaction question

Chris Kershaw chris at endpoint.com
Fri Oct 1 18:34:58 UTC 2010

DB wrote:
>>> Further up in log_transaction I see
>>> payment_method: [value mv_payment]
>>> payment_mode: [data session payment_mode]
>>> I really don't know how these differ - maybe I really want
>>> paid: [if value mv_payment eq purchase_order]1[/if]
>> paid: [if value mv_payment eq 'purchase_order']1[/if]
>> -- 
>> Chris Kershaw
>> End Point Corp.
> Thanks  - I tried that. Sadly I'm still not having any luck. I see
> nothing useful in the IC logs.
> In a feeble attempt to troubleshoot, I put this stuff at the bottom of
> my checkout page (basically a clueless fishing expedition).
> [value mv_payment_mode]
> [value mv_payment]
> [value payment_method]
> [value data session payment_mode]
> but nothing new appeared on the page. Maybe these values don't get set
> until an order is processed.
> I looked at some past orders which were paid by purchase order. These
> orders have in the payment_method field stuff like "Purchase order 6102".
> I could accomplish my goal with a cron job that runs a mysql command or
> two, but I'd much rather do it from within IC. More beatings from the
> clue stick are welcome.

Does the "paid" column exist in the transactions table?
Have you updated the dbconf file for your database? They are located in
one of these directories: catalogs/storename/dbconf/{mysql|pgsql}


Chris Kershaw
End Point Corp.
Direct Line: 919-249-5356
Fax: 866-281-1373 

More information about the interchange-users mailing list