1054 Unknown column 'zen_order_id' in 'where clause'

[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

[Lead_Not_Follow]

I think I'm going to just try to change the code first and see what happens (I'll of course do a backup first).

If I was to find the code needed to change as you mentioned, where would I go about looking?

I'm going to assume \includes\modules\payment\paypal but than where?

Doing the upgrade to v1.3.8 and saving everything looks like it's more than I think I can handle at the moment...

[DrByte]

The SQL statement I posted earlier is something you would run via phpMyAdmin or Admin->Tools->Install SQL Patch

[demotex]

hi
i have the same problem with paypal and my mysql say this here after putting in the code:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1



what can i do?

[DrByte]

what can i do?

The *best* way to deal with the "unknown column 'zen_order_id'" message is to upgrade properly to v1.3.8.
*EVERY* other approach is playing with fire by having mixed versions of PHP vs database.

[kezerb]

I got

1054 Unknown column 'zen_order_id' in 'field list'
in:
[INSERT INTO zen_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 ('5', 'cart', 'None', 'PayPal Express Checkout (instant)', 'Completed', 'None', 'EC-2RX88237P55948141', 'NAME', 'NAME', 'NAME', 'NAME', 'ADDRESS', 'ADDRESS', 'ADDRESS', 'ADDRESS', '', 'Confirmed', 'EMAIL', 'XPECLKBJQ6K82', 'verified', '2009-04-19 13:07:13', '', 'crypt-critter.btconnect.com', '', '25L92196LR519463E', '', '1', '0.76', '0.23', 'GBP', '0', 'GBP', '1', '0', '', now(), '')]

Which is different from the OP's but I tried the code and it still doesn't work
Can anyone help?