Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Posts
    33
    Plugin Contributions
    0

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

  2. #2
    Join Date
    Jun 2006
    Posts
    20
    Plugin Contributions
    0

    Default Re: PayPal Express problem

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

  3. #3
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: PayPal Express problem

    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.

 

 

Similar Threads

  1. 1054 Unknown column 'customers_whole' in 'field list'
    By directdesign in forum All Other Contributions/Addons
    Replies: 5
    Last Post: 9 Mar 2011, 02:09 PM
  2. 1054 Unknown column 'p.products_height' in 'field list'
    By Slash74 in forum General Questions
    Replies: 6
    Last Post: 13 Nov 2009, 10:58 AM
  3. 1054 Unknown column 'customers_paypal_payerid' in 'field list' using PayPal Express
    By Mike_Dean in forum PayPal Express Checkout support
    Replies: 13
    Last Post: 30 Sep 2009, 11:19 AM
  4. 1054 Unknown column 'c.customers_referral' in 'field list'
    By helpme in forum General Questions
    Replies: 1
    Last Post: 23 Jul 2009, 05:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR