New Zenner
- Join Date:
- Jul 2007
- Posts:
- 27
- Plugin Contributions:
- 0
MySQL error: 1054 Unknown column 'zen_order_id' in 'field list'
Hi,
after someone checks out with the express paypal option, they are forwarded to this link, /cart/index.php?main_page=checkout_process
and they see a white page with this text:
1054 Unknown column 'zen_order_id' in 'field list'
in:
[INSERT INTO paypal (zen_order_id, txn_type, reason_code, payment_type, payment_status, pending_reason, invoice, first_name, last_name, payer_business_name, address_name, address_street, address_city, address_state, address_zip, address_country, address_status, payer_email, payer_id, payer_status, payment_date, business, receiver_email, receiver_id, txn_id, parent_txn_id, num_cart_items, mc_gross, mc_fee, mc_currency, settle_amount, settle_currency, exchange_rate, notify_version, verify_sign, date_added, memo) VALUES ('4', 'cart', 'None', 'PayPal Express Checkout (instant)', 'Completed', 'None',
and the text given goes on to show the users info
How might I fix this?
Thanks!
