PHP Fatal error: 1366:Incorrect integer value

[swguy]

What about switching off IPN and going to PayPal Express?

[lat9]

What about switching off IPN and going to PayPal Express?

Er, the PayPal Express Checkout goes through the ipn_main_handler.php to record the order's information, too.

[swguy]

oh! Didn't realize that.

[mvstudio]

I'm using PayPal express.

[swguy]

I am embarrassed by my lack of knowledge of how PayPal updates orders - @lat9 would you consider writing up an explanation of this process? It might give us insights that would help us fix the OP's issue. We could put it here:

https://docs.zen-cart.com/user/payment/paypal_misc/

[lat9]

I am embarrassed by my lack of knowledge of how PayPal updates orders - @lat9 would you consider writing up an explanation of this process? It might give us insights that would help us fix the OP's issue. We could put it here:

https://docs.zen-cart.com/user/payment/paypal_misc/

I'll be happy to, @swguy. It'll take me a while since the processing is fairly convoluted and I've already got a headache just thinking about it!

[mvstudio]

I'll be happy to, @swguy. It'll take me a while since the processing is fairly convoluted and I've already got a headache just thinking about it!

I'm sorry didn't mean to cause any trouble nor headaches

[hairydog]

Is there a fix yet? A few transactions are hitting this problem.

[DrByte]

#5 zen_db_perform() called at [/CATALOG/ipn_main_handler.php:439]
--> PHP Fatal error: 1366:Incorrect integer value: '' for column `koolwedd_TEMP`.`paypal_payment_status_history`.`paypal_ipn_id` at row 1 :: INSERT INTO paypal_payment_status_history (paypal_ipn_id, txn_id, parent_txn_id, payment_status, pending_reason, date_added) VALUES ('', '2PR15233LC148450S', '2SC76806KT052782U', 'Completed', '', now()) ==> (as called by) /CATALOG/includes/functions/functions_general.php on line 952

The SQL error is a result of trying to put an empty text string into a decimal-only field in the database. In non-strict mode the database would just convert that to 0 automatically. But many servers use strict-mode by default nowadays.

EDIT: previous "solution" removed ... misread the details

[lynbor]

I seem to be having this issue as well on one of my systems. v1.57, Database Patch Level: 1.5.7 with PHP v7.2.34, curl 7.73

I'm seeing and hearing from customers that even though the order processing has completed successfully they do not get a "success" page presented. As a result, many customers order the same item 2 or 3 times. I've checked IPN communication which passed. And I see this error a lot in my logs. I also just turned on logging for the paypal module to see if more info can be discovered.

[ names and codes altered for security reasons ]

PHP Fatal error: 1366:Incorrect decimal value: '14.95 USD' for column 'settle_amount' at row 1 :: INSERT INTO paypal (order_id, txn_type, module_name, module_mode, reason_code, payment_type, payment_status, pending_reason, invoice, first_name, last_name, payer_business_name, address_name, address_street, address_city, address_state, address_zip, address_country, address_status, payer_email, payer_id, payer_status, payment_date, business, receiver_email, receiver_id, txn_id, parent_txn_id, num_cart_items, mc_gross, mc_fee, mc_currency, settle_amount, settle_currency, exchange_rate, notify_version, verify_sign, date_added, memo) VALUES ('1144', 'cart', 'paypalwpp', 'PayPal', 'None', 'PayPal Express Checkout (instant)', 'Completed', 'None', 'EC-8XW6XX42M8XXX633K', 'Branden', 'Murcam', '', '', '', '', '', '', '', '', '[email protected]', 'TQ4PUV5SVA2B4', 'unverified', '2020-10-04 00:30:16', '', 'paypal.website.com', '', '84W2214UB609470W', '', '1', '14.95', '0.73', 'USD', '14.95 USD', 'USD', '1', '0', '', now(), '{Record generated by payment module}') ==> (as called by) /home/public_html/opm/includes/functions/database.php on line 44 <== in /home/public_html/opm/includes/classes/db/mysql/query_factory.php on line 170.