PHP Fatal error: 1366:Incorrect integer value
Hello everyone.
I'm all of the sudden getting the following error log:
[06-Apr-2020 10:08:56 America/Detroit] Request URI: /ipn_main_handler.php, IP address: XXXXXXXXXXX
#1 trigger_error() called at [/CATALOG/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/CATALOG/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/CATALOG/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/CATALOG/includes/functions/functions_general.php:952]
#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 <== in /CATALOG/includes/classes/db/mysql/query_factory.php on line 171.
Could anyone help me decipher it so I can figure out how to fix the problem?
Thank you in advance for the help!
Re: PHP Fatal error: 1366:Incorrect integer value
My interpretation of what is going on is that at some point there was an attempt to store a record that failed such that when data was again presented to retrieve that record, no record was found and therefore the paypal_ipn_id was empty. Problem is that when that empty record is attempted to be updated, it obviously fails...
Would recommend taking some of that other data (parent txn_id and parent_txn_id) and see if you can find information either through paypal or in the database.
Re: PHP Fatal error: 1366:Incorrect integer value
What about switching off IPN and going to PayPal Express?
Re: PHP Fatal error: 1366:Incorrect integer value
Quote:
Originally Posted by
swguy
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.
Re: PHP Fatal error: 1366:Incorrect integer value
Re: PHP Fatal error: 1366:Incorrect integer value
I'm using PayPal express. :(
Re: PHP Fatal error: 1366:Incorrect integer value
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/
Re: PHP Fatal error: 1366:Incorrect integer value
Quote:
Originally Posted by
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/
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!
Re: PHP Fatal error: 1366:Incorrect integer value
Quote:
Originally Posted by
lat9
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 :no:
Re: PHP Fatal error: 1366:Incorrect integer value
Is there a fix yet? A few transactions are hitting this problem.