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

Unknown column 'zen_order_id' in 'field list'

Locked

Started by rramirezb on 7 Apr 2008, 7:48 PM · 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.

4 Sep 2008, 6:56 PM
#6
drbyte avatar

drbyte

Sensei

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

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

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.