1054 Unknown column 'zen_order_id' in 'where clause'

**Lead_Not_Follow** · 2 Feb 2008, 09:19 PM

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** · 2 Feb 2008, 09:55 PM

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

**Lead_Not_Follow** · 2 Feb 2008, 10:57 PM

Originally Posted by DrByte

Code:

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** · 15 Mar 2008, 02:20 PM

Originally Posted by Lead_Not_Follow

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!

Exact same problem I am having at the moment.
I installed 1.3.7 but updated to 1.3.8

**CMYK** · 15 Mar 2008, 02:41 PM

Originally Posted by Lead_Not_Follow

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** · 20 Apr 2008, 11:01 PM

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** · 21 Apr 2008, 12:47 AM

Originally Posted by demotex

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** · 26 Apr 2008, 10:44 AM

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

**DrByte** · 27 Apr 2008, 08:20 AM

"zen_order_id" was changed to "order_id" in v1.3.8. So, if you're getting errors about "zen_order_id", then you've got code on your site that doesn't match your database. Either you've missed something in an upgrade, or you've installed outdated addons or a combination thereof.

**demotex** · 27 Apr 2008, 11:51 AM

hi
i installed 1.3.8a and no addons
is 1.3.8a the same like 1.3.8?

Thread: 1054 Unknown column 'zen_order_id' in 'where clause'

Thread Tools

Search Thread

Display

Re: 1054 Unknown column 'zen_order_id' in 'where clause'

Re: 1054 Unknown column 'zen_order_id' in 'where clause'

Re: 1054 Unknown column 'zen_order_id' in 'where clause'

Re: 1054 Unknown column 'zen_order_id' in 'where clause'

Re: 1054 Unknown column 'zen_order_id' in 'where clause'

Re: 1054 Unknown column 'zen_order_id' in 'where clause'

Re: 1054 Unknown column 'zen_order_id' in 'where clause'

Re: 1054 Unknown column 'zen_order_id' in 'where clause'

Re: 1054 Unknown column 'zen_order_id' in 'where clause'

Re: 1054 Unknown column 'zen_order_id' in 'where clause'

Similar Threads

1054 Unknown column 'zen_order_id' in 'where clause'

1054 Unknown column 'zen_order_id' in 'where clause'

1054 Unknown column 'zen_order_id' in 'where clause'

1054 Unknown column 'zen_order_id' in 'where clause'

1054 Unknown column 'p.zen_order_id' in 'where clause'

Bookmarks

Bookmarks

Posting Permissions