Forums / PayPal Express Checkout support / 1054 Unknown column 'customers_paypal_payerid' in 'field list' using PayPal Express

1054 Unknown column 'customers_paypal_payerid' in 'field list' using PayPal Express

Locked

Started by mike_dean on 25 Sep 2009, 10:56 PM · Views: 4,331

Results 1 to 14 of 14
This thread is locked. New replies are disabled.
25 Sep 2009, 10:56 PM
#1
mike_dean avatar

mike_dean

Totally Zenned

Join Date:
Feb 2006
Location:
Central Coast, NSW, Australia
Posts:
531
Plugin Contributions:
0

1054 Unknown column 'customers_paypal_payerid' in 'field list' using PayPal Express

Ok..

Yes, I have read through all the numerous posts, and I've tried numerous options..

Initially I was getting the familiar 10413 error..

I made a few changes as per thread suggestions..

Now when I try and checkout after clicking the PEC button on the cart,

It takes me to Payapal (all good) :smile:
I enter my PayPal email address and password (all good) :smile:
I takes me to the confirmation page (all good) :smile:
But when I hit continue, I get this message on a blank screen.. (not good.!!) :censored:

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

If I hit my 'back' button on the browser, it takes me back to a PayPal page that cannot be edited, and the only selectable option on that screen is to cancel the process and return to the store...

Which in turn takes me back to the store login page.

I have tried both the Auto Create Account and the opposite within the PEC settings, and it still throws up the same message..

I had the debug mode on, but none of the emails really either makes sense, or shed any light..

I have been using Paypal standard with no major errors..

Paypal are offering a rebate on all PayPal fees for October when upgrading to PEC.. so goodie I thought.. :oops:

Hoping someone can help.

Norts And Ones
Norts And Ones

26 Sep 2009, 12:17 AM
#2
drbyte avatar

drbyte

Sensei

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

Re: 1054 Unknown column 'customers_paypal_payerid' in 'field list' using PayPal Express

Mike_Dean:

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

That means you've done something to alter your "customers" table that's caused the "customers_paypal_payerid" field to no longer be part of that table.
You'll continue to get that error until you put it back correctly.

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

26 Sep 2009, 7:17 AM
#3
mike_dean avatar

mike_dean

Totally Zenned

Join Date:
Feb 2006
Location:
Central Coast, NSW, Australia
Posts:
531
Plugin Contributions:
0

Re: 1054 Unknown column 'customers_paypal_payerid' in 'field list' using PayPal Express

DrByte:

That means you've done something to alter your "customers" table that's caused the "customers_paypal_payerid" field to no longer be part of that table.
You'll continue to get that error until you put it back correctly.

What am I supposed to be 'putting back' I have not touched anything in the data base table..

All I did was installed and configured PEC ??

Norts And Ones
Norts And Ones

26 Sep 2009, 12:03 PM
#4
drbyte avatar

drbyte

Sensei

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

Re: 1054 Unknown column 'customers_paypal_payerid' in 'field list' using PayPal Express

Please click "Reply" below, and answer all the questions in the "Posting Tips" area.

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

26 Sep 2009, 2:35 PM
#5
mike_dean avatar

mike_dean

Totally Zenned

Join Date:
Feb 2006
Location:
Central Coast, NSW, Australia
Posts:
531
Plugin Contributions:
0

Re: 1054 Unknown column 'customers_paypal_payerid' in 'field list' using PayPal Express

Thanks Dr,

Version = 1.3.8a
Upgraded = No (Clean Version with all patches)
Mods installed = Ozpost Shipping, Rewards Points

I have checked the forum and have been unable to rectify the issue.

The problem is only encountered when using PayPal Express Checkout, and all that I did was to click the Install Button in Admin, and then configured as required..

No other DB changes were made..

PayPal Standard still functions as normal, as it has done for the past few years.

Thanks,
Mike

Norts And Ones
Norts And Ones

26 Sep 2009, 2:42 PM
#6
drbyte avatar

drbyte

Sensei

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

Re: 1054 Unknown column 'customers_paypal_payerid' in 'field list' using PayPal Express

What is the structure of your "customers" table in your database?
Have you done anything to import customer data from some external source at some point?

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

26 Sep 2009, 3:46 PM
#7
rodg avatar

rodg

Deceased

Join Date:
Jan 2007
Location:
Australia
Posts:
6,263
Plugin Contributions:
4

Re: 1054 Unknown column 'customers_paypal_payerid' in 'field list' using PayPal Express

Mike_Dean:

Thanks Dr,

Version = 1.3.8a
Upgraded = No (Clean Version with all patches)
Mods installed = Ozpost Shipping, Rewards Points

I have checked the forum and have been unable to rectify the issue.

The problem is only encountered when using PayPal Express Checkout, and all that I did was to click the Install Button in Admin, and then configured as required..

No other DB changes were made..

PayPal Standard still functions as normal, as it has done for the past few years.

Thanks,
Mike

If it helps any, the ozpost module doesn't modify (or even access) the customers table, so this can be eliminated as a possible cause.

Cheers
Rod

NOTE: We are sorry that Rod is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

26 Sep 2009, 9:53 PM
#8
mike_dean avatar

mike_dean

Totally Zenned

Join Date:
Feb 2006
Location:
Central Coast, NSW, Australia
Posts:
531
Plugin Contributions:
0

Re: 1054 Unknown column 'customers_paypal_payerid' in 'field list' using PayPal Express

DrByte:

What is the structure of your "customers" table in your database?
Have you done anything to import customer data from some external source at some point?

Thanks Dr,

Here is my Customer Table structure.

Again, I have not uploaded anyting recently that would modify it.

The only recent changes I made were uploading the Oz Post module.. But as per Rod's message, it does not have anything to do with the customers table..

customers_id
customers_gender
customers_firstname
customers_lastname
customers_dob
customers_email_address
customers_nick
customers_default_address_id
customers_telephone
customers_fax
customers_password
customers_newsletter
customers_group_pricing
customers_email_format
customers_authorization
customers_referral

I did find an additional entry in the table when looking yesterday, which was the COWOA field, why that was there I do not know, as I have not installed any such modules.

I deleted that entry, but it made no difference to the error that PEC was throwing up.

I Appreciate your help here.

Thanks,
Mike

RodG:

If it helps any, the ozpost module doesn't modify (or even access) the customers table, so this can be eliminated as a possible cause.

Cheers
Rod

Thanks Rod.. it does help, although I dont have OzPOst on at the moment (Still trying to resolve the spelling error Prepaid Stachel as opposed to Prepaid Satchel !!)

Norts And Ones
Norts And Ones

27 Sep 2009, 6:47 AM
#9
drbyte avatar

drbyte

Sensei

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

Re: 1054 Unknown column 'customers_paypal_payerid' in 'field list' using PayPal Express

The 2 missing fields were added in v1.3.7. You can add them by putting this in your SQL Patch tool, or via phpMyAdmin:```
ALTER TABLE customers ADD customers_paypal_payerid VARCHAR(20) NOT NULL default '' AFTER customers_referral;
ALTER TABLE customers ADD customers_paypal_ec TINYINT(1) UNSIGNED DEFAULT 0 NOT NULL AFTER customers_paypal_payerid;

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

27 Sep 2009, 8:24 AM
#10
mike_dean avatar

mike_dean

Totally Zenned

Join Date:
Feb 2006
Location:
Central Coast, NSW, Australia
Posts:
531
Plugin Contributions:
0

Re: 1054 Unknown column 'customers_paypal_payerid' in 'field list' using PayPal Express

DrByte:

The 2 missing fields were added in v1.3.7. You can add them by putting this in your SQL Patch tool, or via phpMyAdmin:```
ALTER TABLE customers ADD customers_paypal_payerid VARCHAR(20) NOT NULL default '' AFTER customers_referral;
ALTER TABLE customers ADD customers_paypal_ec TINYINT(1) UNSIGNED DEFAULT 0 NOT NULL AFTER customers_paypal_payerid;


Thanks Dr..  

That fixed that problem, now I'm getting (what appears to be) the more common problem, 

10413 Transaction refused because of an invalid argument. See additional error messages for details. - The totals of the cart item amounts do not match order amounts.

I've tried every conceivable config in order totals and still no joy...

Paypal keeps sending me back to Page 1, and when I click through the order, I get the error

Grrrrrr...

Norts And Ones
Norts And Ones

27 Sep 2009, 4:42 PM
#11
drbyte avatar

drbyte

Sensei

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

Re: 1054 Unknown column 'customers_paypal_payerid' in 'field list' using PayPal Express

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

28 Sep 2009, 11:50 AM
#12
mike_dean avatar

mike_dean

Totally Zenned

Join Date:
Feb 2006
Location:
Central Coast, NSW, Australia
Posts:
531
Plugin Contributions:
0

Re: 1054 Unknown column 'customers_paypal_payerid' in 'field list' using PayPal Express

DrByte:

Try this: http://www.zen-cart.com/forum/showthread.php?p=786569#post786569

Thanks Dr. but alas no joy..

Still throws me back to Page 1 of the Checkout Process and after clicking thru, I get the same error...

Norts And Ones
Norts And Ones

28 Sep 2009, 11:52 AM
#13
drbyte avatar

drbyte

Sensei

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

Re: 1054 Unknown column 'customers_paypal_payerid' in 'field list' using PayPal Express

Please post your paypal debug logs: http://www.zen-cart.com/forum/showthread.php?t=61199

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