Forums / Upgrading from 1.3.x to 1.3.9 / 1054 Unknown column ERROR

1054 Unknown column ERROR

Locked

Views: 2,146

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
24 Apr 2008, 3:43 PM
#1
triplemoons avatar

triplemoons

New Zenner

Join Date:
Oct 2006
Location:
Hanover, PA
Posts:
71
Plugin Contributions:
0

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. :huh:

.: Stef :.

25 Apr 2008, 3:59 AM
#2
knuckle_101 avatar

knuckle_101

Totally Zenned

Join Date:
Dec 2005
Location:
Cincinnati Ohio
Posts:
1,034
Plugin Contributions:
3

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

25 Apr 2008, 7:09 PM
#3
triplemoons avatar

triplemoons

New Zenner

Join Date:
Oct 2006
Location:
Hanover, PA
Posts:
71
Plugin Contributions:
0

Re: 1054 Unknown column ERROR

Not too sure what you mean. :unsure:

.: Stef :.

25 Apr 2008, 7:34 PM
#4
triplemoons avatar

triplemoons

New Zenner

Join Date:
Oct 2006
Location:
Hanover, PA
Posts:
71
Plugin Contributions:
0

Re: 1054 Unknown column ERROR

My orders are also not showing up in my admin after being payed for by PayPal.

.: Stef :.

25 Apr 2008, 8:43 PM
#5
knuckle_101 avatar

knuckle_101

Totally Zenned

Join Date:
Dec 2005
Location:
Cincinnati Ohio
Posts:
1,034
Plugin Contributions:
3

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