Zen Cart Logo
Forums / Built-in Shipping and Payment Modules / 1054 Unknown column 'zen_order_id' in 'where clause'

1054 Unknown column 'zen_order_id' in 'where clause'

Locked

Views: 7,781

Results 21 to 25 of 25
This thread is locked. New replies are disabled.
26 Apr 2008, 9:44 AM
#21
demotex avatar

demotex

New Zenner

Join Date:
Apr 2008
Posts:
8
Plugin Contributions:
0

1054 Unknown column 'zen_order_id' in 'where clause'

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

27 Apr 2008, 7:20 AM
#22
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

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

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

27 Apr 2008, 10:51 AM
#23
demotex avatar

demotex

New Zenner

Join Date:
Apr 2008
Posts:
8
Plugin Contributions:
0

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

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

27 Apr 2008, 1:25 PM
#24
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

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

1.3.8a is 1.3.8 with a couple patches.

19 Apr 2009, 1:18 PM
#25
kezerb avatar

kezerb

New Zenner

Join Date:
Sep 2008
Posts:
46
Plugin Contributions:
0

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

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?