1054 Unknown column 'customers_paypal_payerid' in 'field list'

25 Jan 2011, 7:42 PM

New Zenner

Join Date:: Jul 2006
Posts:: 33
Plugin Contributions:: 0

1054 Unknown column 'customers_paypal_payerid' in 'field list'

I am having the same problem, but it's not a timeout error. Here it is:

1054 Unknown column 'customers_paypal_payerid' in 'field list'
in:
[SELECT customers_id, customers_firstname, customers_lastname, customers_paypal_payerid, customers_paypal_ec FROM zen_customers WHERE customers_email_address = '[email protected]' ]

If I log in and go through the shipping page, then checkout via paypal, everything works. It's only when trying to do it at the shopping cart page or the Welcome/login page.

If there is no fix to this problem, then how can I remove the Paypal buttons on the shopping cart page and welcome/login page?

Thanks.

29 Jun 2011, 10:39 PM

fjavier

New Zenner

Join Date:: Jun 2006
Posts:: 20
Plugin Contributions:: 0

Re: 1054 Unknown column 'customers_paypal_payerid' in 'field list'

Any fix for the: > 1054 Unknown column 'customers_paypal_payerid' in 'field list'... issue yet?

30 Jun 2011, 2:29 AM

drbyte

Sensei

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

Re: 1054 Unknown column 'customers_paypal_payerid' in 'field list'

That field was added to the database in v1.3.7

If you're getting an error saying "unknown column 'customers_paypal_payerid'", then that means your database is at v1.3.6 level or older, and your PHP code is at 1.3.7 or newer.
You'll need to fix things to bring them back to both being on the same level.

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