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

[Mike_Dean]

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)
I enter my PayPal email address and password (all good)
I takes me to the confirmation page (all good)
But when I hit continue, I get this message on a blank screen.. (not good.!!)


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


Hoping someone can help.

[DrByte]

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.

[Mike_Dean]

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

[DrByte]

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

[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

[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?

[RodG]

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

[Mike_Dean]

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

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 !!)

[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;

[Mike_Dean]

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