Unknown column customers_paypal_payerid

[dhcernese]

I have 1.3.8a and am testing PayPal Express Checkout. I have [finally] created a sandbox buyer and seller, and the payment module is in sandbox mode w/debug and email.

I clicked on the first PayPal checkout in the cart and used the personal (buyer) test account during my first test. I got all the correct PayPal debug emails.

After hitting "Continue" on the PayPal screen, my browser returns to the IPN page with this:

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]' ]

How could it not have the right column if the PayPal module is installed and configured correctly already?

[dhcernese]

How could it not have the right column if the PayPal module is installed and configured correctly already?

I should mention, this being my development site it does not have an SSL certificate if that could hose up the works, but I didn't receive any errors from PayPal.

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

How could it not have the right column if the PayPal module is installed and configured correctly already?

Good question, but clearly it doesn't. You'll need to fix that before you can continue.
You can see the correct structure of the table in the /zc_install/sql/mysql_zencart.sql file.

[dhcernese]

Good question, but clearly it doesn't. You'll need to fix that before you can continue.
You can see the correct structure of the table in the /zc_install/sql/mysql_zencart.sql file.

This appears to be a side-affect of my development site. Sorry. Somehow the database is out of sync with my live site.