Dr Byte, I hope you can help me out with a issue I am having with the paypal IPN handler (ipn_main_handler.php/type/ec)
First a little background. I have 3 carts set up for 1 site, in 3 different sub folders (purchase, purchase_euro and purchase_can) for each of the associated currencies. Now before you ask, the reason I went that way instead of the currency conversion is because they have some misc price differences that don't match up to the conversion rate.
The checkout is using the PPWPP module, which works fine on the credit card processing. But when they click on the Pay Now with Paypal button, this error comes up:
Code:
1054 Unknown column 'zen_order_id' in 'field list'
in:
[SELECT zen_order_id, paypal_ipn_id, payment_status, txn_type, pending_reason FROM _zenCADpaypal WHERE txn_id = '' ORDER BY zen_order_id DESC ]
The Pay with Paypal button works on the main US cart, but not on the euro or the canadian carts. You can see the carts at:
http://www.unifieddirect.net/puchase
Please....please say you can help me out, I got to get this puppy wrapped up.
Thanks in advance for a response.
JF
Bookmarks