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?