Another checkout issue (PayPal/Customers)

[kmoodysoh]

ZC Version = 1.5.8
PHP Version = 7.4.33

It looks like this happens when using the "Check out with PayPal" button on the shopping cart when no account is created. Using that button takes me to PayPal. I noticed it does not pass any shipping or tax information, then when you click continue to review order on PayPal, the error is generated and the "Warning: an error occured, please let us know" page displays. The customer shows the charge pending on their account, but I don't have anything pending on my end. The error generated is as follows.

[07-Dec-2022 18:50:12 America/Chicago] Request URI: /ipn_main_handler.php?type=ec&token=EC-5GY63375GW3422510&PayerID=MXZFN2VAVAA7G, IP address: X.XXX.XXX.XXX
#1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:667]
#2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:634]
#3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:275]
#4 queryFactory->Execute() called at [/includes/functions/database.php:130]
#5 zen_db_perform() called at [/includes/modules/payment/paypalwpp.php:2265]
#6 paypalwpp->ec_step2_finish() called at [/includes/modules/payment/paypalwpp.php:2013]
#7 paypalwpp->ec_step2() called at [/ipn_main_handler.php:80]
--> PHP Fatal error: 1364:Field 'registration_ip' doesn't have a default value :: INSERT INTO customers (customers_firstname, customers_lastname, customers_email_address, customers_email_format, customers_telephone, customers_fax, customers_gender, customers_newsletter, customers_password, customers_paypal_payerid) VALUES ('W***m', 'F***r', 'w***.com', 'TEXT', '', '', '', '0', '*****', '*****') ==> (as called by) /includes/functions/database.php on line 130 <== in /includes/classes/db/mysql/query_factory.php on line 667.

I've been needing to upgrade my PHP to 8.0 so I will do that to see if it still produces this error and will reply once I test.

[swguy]

If registration_ip doesn't have a default value, something is messed up in your database. Try this command in phpMyAdmin (not Install SQL Patches) and report back with the error if any:

ALTER TABLE customers MODIFY COLUMN registration_ip varchar(45) NOT NULL default '';

Note: if your database has a prefix (like zc_ or zen_) then add that (change "customers" to "zc_customers" or whatever)

[kmoodysoh]

Ok. I had to update 'registration_ip' as well as 'last_login_ip'. Both of those were set to Default None. Changing those fields to Default As Defined (blank) fixed these errors.
I've never edited that table since my last "new" install so I'm not sure how it would have been changed.

Thank you again for your quick response!!

[swguy]

To verify:
- this database is an upgrade from a prior version, correct?
- did you run the zc_install procedure?
- were there errors produced? Do you happen to have the logs?

[kmoodysoh]

I upgraded from the 1.5.7 release. As far as I can remember, there were no errors when I ran the zc_install upgrade. Unfortunately I don't think I have any logs from then to provide but I will try to dig around the server logs and see if I see anything.

[swguy]

OK thanks for checking. Server logs not needed.