Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2006
    Location
    Hanover, PA
    Posts
    71
    Plugin Contributions
    0

    Default 1054 Unknown column ERROR

    I upgraded to the latest version and when I tried to amend comments on an order, the following shows up:

    1054 Unknown column 'zen_order_id' in 'where clause'
    in:
    [select * from zen_paypal where zen_order_id = '5' 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.

    Any idea what it is? I can do anything with the order status or comments.
    [FONT=Century Gothic].: Stef :.[/FONT]

  2. #2
    Join Date
    Dec 2005
    Location
    Cincinnati Ohio
    Posts
    1,030
    Plugin Contributions
    13

    Default Re: 1054 Unknown column ERROR

    This means you've used a 1.3.8 or newer PayPal module on a site that has pre-1.3.8 PayPal PHP files on it. Make sure all files including template over ride files if any meet with the latest version you upgraded to.
    PCI Certified Web Hosting - ControlScan, Security Metrics (Platinum Partner), McAfee, TrustKeeper
    Business Class Web Hosting - Linux and cPanel Powered

  3. #3
    Join Date
    Oct 2006
    Location
    Hanover, PA
    Posts
    71
    Plugin Contributions
    0

    Default Re: 1054 Unknown column ERROR

    Not too sure what you mean.
    [FONT=Century Gothic].: Stef :.[/FONT]

  4. #4
    Join Date
    Oct 2006
    Location
    Hanover, PA
    Posts
    71
    Plugin Contributions
    0

    Default Re: 1054 Unknown column ERROR

    My orders are also not showing up in my admin after being payed for by PayPal.
    [FONT=Century Gothic].: Stef :.[/FONT]

  5. #5
    Join Date
    Dec 2005
    Location
    Cincinnati Ohio
    Posts
    1,030
    Plugin Contributions
    13

    Default Re: 1054 Unknown column ERROR

    Have you entered the PDT token from paypal into the Paypal mod inside the payment modules in the admin.

    If not enter that and the orders should show up. This http://www.zen-cart.com/wiki/index.php/PayPal maybe of some assistance for that
    PCI Certified Web Hosting - ControlScan, Security Metrics (Platinum Partner), McAfee, TrustKeeper
    Business Class Web Hosting - Linux and cPanel Powered

 

 

Similar Threads

  1. 1054 Unknown column error
    By godin5150 in forum General Questions
    Replies: 3
    Last Post: 30 Sep 2008, 06:03 AM

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