Zen Cart Logo
Forums / Built-in Shipping and Payment Modules / Unknown column 'zen_order_id' in 'field list'

Unknown column 'zen_order_id' in 'field list'

Locked

Views: 2,044

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
7 Apr 2008, 7:48 PM
#1
rramirezb avatar

rramirezb

New Zenner

Join Date:
Oct 2007
Posts:
59
Plugin Contributions:
0

Unknown column 'zen_order_id' in 'field list'

Hello,

Some days ago I've started to have problems with paypal payments.
My catalog at: https://www.relojescasio.es working fine. But when people pay by paypal, there is an issue:

The money comes into my paypal account correctly.
But no order is processed. I receive no order to MY email.
No order appears on the order history in my admin panel.

I've checked the configuration for the paypal module. I've cheked my paypal account too. Everything seems to be ok.

The problems appears when the client finishes the paypal transaction, but then the browser does not re-direct to the store. Instead appeas the following error message:
"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 = '8CA488078R36****' OR
parent_txn_id = '8CA488078R361****' ORDER BY zen_order_id DESC ]

Any help please?

7 Apr 2008, 7:52 PM
#2
rramirezb avatar

rramirezb

New Zenner

Join Date:
Oct 2007
Posts:
59
Plugin Contributions:
0

Re: Unknown column 'zen_order_id' in 'field list'

The really strange thing is that I've been working with paypal for some months with no problem, and since last friday it doesn't work at all.
Even I've disabled the module to avoid problems with customer's orders.

One strange thing too: one customers payed with paypal... I get the money in my paypal account, but I had no order in ZC admin, and I had not this client in the clients list of ZC.

7 Apr 2008, 7:52 PM
#3
colemanpa avatar

colemanpa

Zen Follower

Join Date:
Oct 2007
Location:
Fairbanks, Alaska
Posts:
423
Plugin Contributions:
0

Re: Unknown column 'zen_order_id' in 'field list'

Just a thought but it mite help if you posted what version of zencart you are using, and what payment modules you have installed.

7 Apr 2008, 8:09 PM
#4
rramirezb avatar

rramirezb

New Zenner

Join Date:
Oct 2007
Posts:
59
Plugin Contributions:
0

Re: Unknown column 'zen_order_id' in 'field list'

Sorry,
I'm using Zen Cart 1.3.7.1 and the Paypal IPN module I'm not sure (in the php file appears this: version $Id: paypal.php 6528 2007-06-25 23:25:27Z drbyte $)

4 Sep 2008, 12:13 PM
#5
vixbow avatar

vixbow

New Zenner

Join Date:
Mar 2005
Posts:
4
Plugin Contributions:
0

Re: Unknown column 'zen_order_id' in 'field list'

I am having the same problem. Anyone know what is happening? I'm using the same version of ZC as the poster.

Thanks in advance for any help.