1054 Unknown column 'zen_order_id' in 'where clause'

[mtrantas]

I ran a test order through my Zen Cart and after I submitted the PayPal payment I recieved this error:

1054 Unknown column 'zen_order_id' in 'where clause'
in:
[select * from paypal where zen_order_id = '2' order by paypal_ipn_id DESC LIMIT 1]

I was not returned back to my site but instead got an error message. The order is in the Admin tool and it was actually paid for but I never was returned to the site.

Does anyone know what this is and how to correct it?

[mtrantas]

I apologize - this is the full error:

1054 Unknown column 'zen_order_id' in 'field list'
in:
[SELECT zen_order_id, paypal_ipn_id, payment_status, txn_type, pending_reason FROM paypal WHERE txn_id = '5FR094876R425540U' OR parent_txn_id = '5FR094876R425540U' ORDER BY zen_order_id DESC ]

[Lead_Not_Follow]

I am having the same issue when I go to view the order in the admin panel.

Here is what I am getting...

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

Looking for an answer as well.

[DrByte]

You are using 1.3.7 (or older) code in your PHP files, but using a 1.3.8 version of one or more of the PayPal modules.

[Lead_Not_Follow]

You are using 1.3.7 (or older) code in your PHP files, but using a 1.3.8 version of one or more of the PayPal modules.

Can you explain it for the un-educated more?

I have not done any upgrades at all. Do I need to?

How do I fix the problem? Can I just use a 1.3.7 paypal module to resolve the problem? I apologize as I'm a total newbie to this.

[DrByte]

What version of Zen Cart are you using?
How did you install it?
Have you applied any patches to it?
What addons/contributions do you have installed?

[Lead_Not_Follow]

You are using 1.3.7 (or older) code in your PHP files, but using a 1.3.8 version of one or more of the PayPal modules.

What version of Zen Cart are you using?
How did you install it?
Have you applied any patches to it?
What addons/contributions do you have installed?

Here is the info:

Server Host: linhost194.prod.mesa1.secureserver.net (68.178.232.150) Database Host: h50mysql45.secureserver.net (10.8.11.214)
Server OS: Linux 2.4.21-40.ELsmp
Database: MySQL 5.0.45-log
Server Date: 02/02/2008 09:18:40
Database Date: 02/02/2008 09:18:40
Server Up Time: 09:18:40 up 206 days, 15:21, 0 users, load average: 9.25, 8.34, 7.86
PHP Version: 4.3.11 (Zend: 1.3.0)
HTTP Server: Apache

Zen Cart 1.3.7
Database Patch Level: 1.3.7
v1.3.7 [2008-01-09 08:14:36] (Fresh Installation)


It was installed using GoDaddy's install tool (they install it for you). I have not done anything but install it, and than use a template for the layout. I can go in and edit any order not payed with via PayPal, however I get the above error on all PayPal orders. I just did a test order via PayPal and the order process works fine.

I appreciate the help. Let me know if you need any more info.

Thanks!

[DrByte]

I can go in and edit any order not payed with via PayPal, however I get the above error on all PayPal orders.

...

I just did a test order via PayPal and the order process works fine.

It doesn't make sense that you can place an order via PayPal without error, but cannot edit/view the order details via the admin ... unless you have installed a 1.3.8 PayPal module somewhere, or have altered the database in some way.

Anyway, you seem to believe that none of that has happened, so just go and manually fudge your database back to the old format and pray that everything else is fine. I DO NOT RECOMMEND THIS APPROACH, because I believe something else is wrong, but this is a bandage you can try at your own risk.

ALTER TABLE paypal CHANGE order_id  zen_order_id int(11) unsigned NOT NULL default '0';

If that doesn't solve it, delete your database and your Zen Cart install, and start over from scratch.

You might consider installing v1.3.8 instead, since 1.3.7 is more than a year old.

[Lead_Not_Follow]

Here is what it looks like when I go to that order. I'm assuming that it worked via PayPal since the order showed up and I received confirmation.

I did a test order and went as far as the PayPal screen without issues. If you want to try yourself you can by visiting the website HERE.



What is involved in doing an upgrade to v1.3.8? Will I loose all my info etc. or it something as simple as clicking a few buttons?

Thanks again for the help!

[DrByte]

Upgrade instructions:
https://www.zen-cart.com/tutorials/index.php?article=98