Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Join Date
    Apr 2008
    Posts
    377
    Plugin Contributions
    1

    Default 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!
    M.Valenti
    Contemporary Artist - Entrepreneur
    http://www.manuelavalenti.com - http://www.byvalenti.com

  2. #2
    Join Date
    Jul 2012
    Posts
    15,131
    Plugin Contributions
    17

    Default 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.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

  3. #3
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,208
    Plugin Contributions
    273

    Default Re: PHP Fatal error: 1366:Incorrect integer value

    What about switching off IPN and going to PayPal Express?
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.

  4. #4
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    9,669
    Plugin Contributions
    73

    Default Re: PHP Fatal error: 1366:Incorrect integer value

    Quote Originally Posted by swguy View Post
    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.

  5. #5
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,208
    Plugin Contributions
    273

    Default Re: PHP Fatal error: 1366:Incorrect integer value

    oh! Didn't realize that.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.

  6. #6
    Join Date
    Apr 2008
    Posts
    377
    Plugin Contributions
    1

    Default Re: PHP Fatal error: 1366:Incorrect integer value

    I'm using PayPal express.

  7. #7
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,208
    Plugin Contributions
    273

    Default 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/
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.

  8. #8
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    9,669
    Plugin Contributions
    73

    Default Re: PHP Fatal error: 1366:Incorrect integer value

    Quote Originally Posted by swguy View Post
    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!

  9. #9
    Join Date
    Apr 2008
    Posts
    377
    Plugin Contributions
    1

    Default Re: PHP Fatal error: 1366:Incorrect integer value

    Quote Originally Posted by lat9 View Post
    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

  10. #10
    Join Date
    Sep 2006
    Posts
    139
    Plugin Contributions
    1

    Default Re: PHP Fatal error: 1366:Incorrect integer value

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

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v156 MySQLi error 1366: Incorrect string value
    By chadlly2003 in forum General Questions
    Replies: 19
    Last Post: 3 Jan 2020, 05:57 AM
  2. Replies: 7
    Last Post: 22 Dec 2019, 07:07 PM
  3. v154 Issue with Authorize.net AIM updating table - error 1366 incorrect integer value
    By inklingsolutions in forum Built-in Shipping and Payment Modules
    Replies: 48
    Last Post: 29 Dec 2016, 09:09 PM
  4. Replies: 2
    Last Post: 22 Jun 2013, 03:48 AM
  5. 1366 Incorrect integer value Problems with MySQL 5 strict-mode
    By Max70 in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 13
    Last Post: 10 Dec 2009, 07:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR