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?

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

[DrByte]

Try this: http://www.zen-cart.com/forum/showth...569#post786569

[Mike_Dean]

Try this: http://www.zen-cart.com/forum/showth...569#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...

[DrByte]

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