Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Jul 2007
    Posts
    27
    Plugin Contributions
    0

    Default 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!

  2. #2
    Join Date
    Jul 2005
    Posts
    537
    Plugin Contributions
    0

    Default Re: MySQL error: 1054 Unknown column 'zen_order_id' in 'field list'

    In the "Similar Threads" list at the bottom of this page are some other discussions of the same topic.

    "It seems you're using mixed v1.3.8 and v1.3.7 code on the same site"

 

 

Similar Threads

  1. MySQL error 1054: Unknown column 'p.products_group_a_price' in 'field list'
    By funna_21 in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 19 Nov 2011, 11:31 PM
  2. 1054 Unknown column 'zen_order_id' in 'field list'
    By Mc G in forum Built-in Shipping and Payment Modules
    Replies: 3
    Last Post: 9 Apr 2010, 01:48 PM
  3. ERROR 1054 Unknown column 'zen_order_id' in 'field list'
    By paperthreads in forum PayPal Express Checkout support
    Replies: 6
    Last Post: 16 Feb 2010, 04:03 AM
  4. 1054 Unknown column 'zen_order_id' in 'field list'
    By bunnyzoe in forum PayPal Website Payments Pro support
    Replies: 0
    Last Post: 6 Jun 2009, 08:18 PM
  5. 1054 Unknown column 'zen_order_id' in 'field list' ... and orders are not created
    By Dave63 in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 26 Nov 2008, 09:25 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg