Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007
    Posts
    25
    Plugin Contributions
    0

    Default 1054 Unknown column 'zen_order_id' in 'where clause'

    when i try to see and edit details on my customer > order's details pages, all i can see is their addresses, not their order or the ability to update their statuses.

    the message...


    "1054 Unknown column 'zen_order_id' in 'where clause'
    in:
    [select * from zen_paypal where zen_order_id = '896' order by paypal_ipn_id DESC LIMIT 1]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."


    also, paypal payment received emails are being titled
    " Item #Store Receipt - Notification of Payment Received from"

    without an order number but 'store receipt" instead =(


    i searched for this stuff but cannot find it. please help!! thank you...

  2. #2
    Join Date
    Nov 2007
    Posts
    25
    Plugin Contributions
    0

    Default Customer Order page has become unavailable, "Item #Store Receipt"?

    when i try to see and edit details on my customer > order's details pages, all i can see is their addresses, not their order or the ability to update their statuses.

    the message...


    "1054 Unknown column 'zen_order_id' in 'where clause'
    in:
    [select * from zen_paypal where zen_order_id = '896' order by paypal_ipn_id DESC LIMIT 1]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."


    also, paypal payment received emails are being titled
    " Item #Store Receipt - Notification of Payment Received from"

    without an order number but 'store receipt" instead =(


    i searched for this stuff but cannot find it. please help!! thank you...

  3. #3
    Join Date
    Jul 2006
    Location
    Montreal, Canada
    Posts
    2,279
    Plugin Contributions
    0

    Default Re: 1054 Unknown column 'zen_order_id' in 'where clause'

    you can look at bottom of this post for few similar post .
    base on what i have read , it seems you have different version of paypal installed on your zencart .. if you do search in this forum you will get tons of result regarding this issue.

 

 

Similar Threads

  1. 1054 Unknown column 'zen_order_id' in 'where clause'
    By JDMEngineLand in forum Built-in Shipping and Payment Modules
    Replies: 6
    Last Post: 23 Feb 2010, 08:28 PM
  2. 1054 Unknown column 'zen_order_id' in 'where clause'
    By mtrantas in forum Built-in Shipping and Payment Modules
    Replies: 21
    Last Post: 19 Apr 2009, 02:18 PM
  3. 1054 Unknown column 'zen_order_id' in 'where clause'
    By Lyon in forum General Questions
    Replies: 1
    Last Post: 17 Feb 2009, 08:00 PM
  4. 1054 Unknown column 'zen_order_id' in 'where clause'
    By atomic_s in forum Built-in Shipping and Payment Modules
    Replies: 4
    Last Post: 9 Feb 2009, 11:11 AM
  5. 1054 Unknown column 'p.zen_order_id' in 'where clause'
    By alamocdc in forum Basic Configuration
    Replies: 5
    Last Post: 23 Jul 2008, 02:18 PM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR