Zen Cart Logo
Forums / General Questions / 1054 Unknown column 'zen_order_id' in 'where clause'

1054 Unknown column 'zen_order_id' in 'where clause'

Locked

Views: 927

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
16 Jan 2009, 7:27 PM
#1
heerosferret avatar

heerosferret

New Zenner

Join Date:
Nov 2007
Posts:
25
Plugin Contributions:
0

1054 Unknown column 'zen_order_id' in 'where clause'

when i try to see and edit details on my customer > order's details pages, all i can see is their addresses, not their order or the ability to update their statuses.

the message...

"1054 Unknown column 'zen_order_id' in 'where clause'
in:
[select * from zen_paypal where zen_order_id = '896' order by paypal_ipn_id DESC LIMIT 1]
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."

also, paypal payment received emails are being titled
" Item #Store Receipt - Notification of Payment Received from"

without an order number but 'store receipt" instead =(

i searched for this stuff but cannot find it. please help!! thank you...

16 Jan 2009, 7:51 PM
#2
heerosferret avatar

heerosferret

New Zenner

Join Date:
Nov 2007
Posts:
25
Plugin Contributions:
0

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

when i try to see and edit details on my customer > order's details pages, all i can see is their addresses, not their order or the ability to update their statuses.

the message...

"1054 Unknown column 'zen_order_id' in 'where clause'
in:
[select * from zen_paypal where zen_order_id = '896' order by paypal_ipn_id DESC LIMIT 1]
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."

also, paypal payment received emails are being titled
" Item #Store Receipt - Notification of Payment Received from"

without an order number but 'store receipt" instead =(

i searched for this stuff but cannot find it. please help!! thank you...

16 Jan 2009, 10:21 PM
#3
tony_sar avatar

tony_sar

Totally Zenned

Join Date:
Jul 2006
Location:
Montreal, Canada
Posts:
2,276
Plugin Contributions:
0

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

you can look at bottom of this post for few similar post .
base on what i have read , it seems you have different version of paypal installed on your zencart .. if you do search in this forum you will get tons of result regarding this issue.