PHP Fatal error: 1366:Incorrect integer value

[lynbor]

I'll suggest changing line 536 of paypalwpp.php to reflect the change made for zc157a:

                          'settle_amount' => (float)(isset($this->responsedata['PAYMENTINFO_0_SETTLEAMT']) ? urldecode($this->responsedata['PAYMENTINFO_0_SETTLEAMT']) : $this->amt),

Note the subtle difference between that and zc157, the movement of the closing parentheses from after the isset() clause to after the $this->amt element.

OK, I've made the change, now waiting to see if the next purchase has any issues.
It seems that the only issue really is that an error message is displayed to the user after a successful transaction. And all it says is "An Error has occurred" on a white background. I'll report back once I have a sale go through again.

[mc12345678]

OK, I've made the change, now waiting to see if the next purchase has any issues.
It seems that the only issue really is that an error message is displayed to the user after a successful transaction. And all it says is "An Error has occurred" on a white background. I'll report back once I have a sale go through again.

Well, there is the fact though that the transaction(s) didn't get logged in the PayPal table, but that's minor compared to 1) not receiving money, 2) not having logging/recognition of an order, and 3) customer not getting their product. :)

[lynbor]

OK, I've made the change, now waiting to see if the next purchase has any issues.
It seems that the only issue really is that an error message is displayed to the user after a successful transaction. And all it says is "An Error has occurred" on a white background. I'll report back once I have a sale go through again.

This appears to have solved the issue. I've had two more purchases and no additional orders attempted nor complaints from the customers. The log files generated were a little disconcerting though. The first sale generated 8 logs and the second one generated 6. Some ended with SUCCESS while others appeared to indicate some kind of issue may have happened. But for now, I'm not going to pursue it further. I've set the PayPal logging level back to "Alerts only" and I'll ride with it that way for a bit and see how things go. Thank you very much for the assist lat9!

[keneso]

Having same problem, apologies if I am supposed to open new thread, please let me know in case.

Almost same error log as OP by mvstudio as you can see below.

Infos:
Running 1.5.6c (I know, will update as soon as possible)
Mid december there was a migration done by hosting company to new server, before that everything was working fine, meaning orders would get in after payment.

My question:
Can I apply the suggested changes (DrByte #12, and lat9 #16) as suggested?

Thank you
Happy 2021

[31-Dec-2020 20:38:25 Europe/London] Request URI: /index.php?main_page=checkout_process, IP address: xxx.xxx.xxx.xxx
#1 trigger_error() called at [/path-to/public_html/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/path-to/public_html/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/path-to/public_html/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/path-to/public_html/includes/functions/functions_general.php:952]
#5 zen_db_perform() called at [/path-to/public_html/includes/classes/order.php:695]
#6 order->create() called at [/path-to/public_html/includes/modules/checkout_process.php:95]
#7 require(/path-to/public_html/includes/modules/checkout_process.php) called at [/path-to/public_html/includes/modules/pages/checkout_process/header_php.php:14]
#8 require(/path-to/public_html/includes/modules/pages/checkout_process/header_php.php) called at [/path-to/public_html/index.php:36]
--> PHP Fatal error: 1366:Incorrect integer value: '' for column `tesoreri_zen156c`.`orders`.`delivery_address_format_id` at row 1 :: INSERT INTO orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address) VALUES ('100', 'NAME REMOVED', '', 'ADDRESS REMOVED', '', 'TOWN REMOVED', 'ZIP REMOVED', 'STATE REMOVED', 'COUNTRY REMOVED', 'PHONE REMOVED', 'MAIL REMOVED', '5', ' ', '', '', '', '', '', '', '', '', 'NAME REMOVED', '', 'ADDRESS REMOVED', '', 'TOWN REMOVED', 'ZIP REMOVED', 'STATE REMOVED', 'COUNTRY REMOVED', '5', 'PayPal', 'paypalwpp', 'free_free', 'free', '', '', '', '', '', now(), '2', '50', '0', 'EUR', '1.000000', 'xxx.xxx.xxx.xxx - xxx.xxx.xxx.xxx') ==> (as called by) /path-to/public_html/includes/functions/functions_general.php on line 952 <== in /path-to/public_html/includes/classes/db/mysql/query_factory.php on line 171.

[lat9]

Those changes should be OK-fine! Happy 2021 to all!

[keneso]

Thank you.

I made those changes, yet I get same error: Warning: An error occured, please refresh the page and try again.

Any other suggestions please?

[mc12345678]

Thank you.

I made those changes, yet I get same error: Warning: An error occured, please refresh the page and try again.

Any other suggestions please?

The on screen message is generic on purpose, don't want to provide the details of the problem(s) to just anyone... The real cause is in the myDEBUG log file(s) that were generated... Please return to them and see what else is likely an issue now...

[keneso]

Thank you.

Sorry for creating confusion, besides the on screen message, I should have specified that the debug reports the same as my previous post #20

[DrByte]

Mid december there was a migration done by hosting company to new server, before that everything was working fine, meaning orders would get in after payment.

--> PHP Fatal error: 1366:Incorrect integer value: '' for column `tesoreri_zen156c`.`orders`.`delivery_address_format_id` at row 1 :: INSERT INTO orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address) VALUES ('100', 'NAME REMOVED', '', 'ADDRESS REMOVED', '', 'TOWN REMOVED', 'ZIP REMOVED', 'STATE REMOVED', 'COUNTRY REMOVED', 'PHONE REMOVED', 'MAIL REMOVED', '5', ' ', '', '', '', '', '', '', '', '', 'NAME REMOVED', '', 'ADDRESS REMOVED', '', 'TOWN REMOVED', 'ZIP REMOVED', 'STATE REMOVED', 'COUNTRY REMOVED', '5', 'PayPal', 'paypalwpp', 'free_free', 'free', '', '', '', '', '', now(), '2', '50', '0', 'EUR', '1.000000', 'xxx.xxx.xxx.xxx - xxx.xxx.xxx.xxx')

It seems your new server is using a much newer MySQL version. And newer MySQL versions have "strict mode" enabled by default. I'm guessing your old server used an older version and/or had strict mode turned off, whether intentionally or as a byproduct of the old version's defaults.

While most of v1.5.7's code has been adapted to accommodate such issues, your 1.5.6 site won't have those benefits. Until you get your code upgraded, you could temporarily turn strict mode off in your MySQL. This is not recommended, but it's a bandage until you do the very important upgrade to make your Zen Cart compatible with the new server you've begun using.

[keneso]

Thank you.
Looks like I have to reschedule some jobs.