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


Reply With Quote
