1054 Unknown column 'zen_order_id' in 'where clause'

[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

[Lead_Not_Follow]

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

That did it!

Thanks a TON! I really really really appreciate it!

So I'm going to assume that since that fixed the problem that I should upgrade to v1.3.8 anyways?

[CMYK]

That did it!

Thanks a TON! I really really really appreciate it!

So I'm going to assume that since that fixed the problem that I should upgrade to v1.3.8 anyways?

Holy ########!!!

That fixed it also ...
thankyou very much.

[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.

[demotex]

hi drbyte
i am already working with version 1.3.8a
what can i do?