Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 39
  1. #21
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    11,408
    Plugin Contributions
    80

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

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

  2. #22
    Join Date
    May 2009
    Posts
    1,217
    Plugin Contributions
    2

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

    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?

  3. #23
    Join Date
    Jul 2012
    Posts
    16,488
    Plugin Contributions
    17

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

    Quote Originally Posted by keneso View Post
    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...
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  4. #24
    Join Date
    May 2009
    Posts
    1,217
    Plugin Contributions
    2

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

    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

  5. #25
    Join Date
    Jan 2004
    Posts
    66,350
    Blog Entries
    7
    Plugin Contributions
    271

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

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

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  6. #26
    Join Date
    May 2009
    Posts
    1,217
    Plugin Contributions
    2

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

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

  7. #27
    Join Date
    May 2009
    Posts
    1,217
    Plugin Contributions
    2

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

    While in process to prepare for upgarde I asked hosting, and they removed strict mode, and it worked for one transaction.

    Couple days ago there was yet another transaction which failed, meaning no orders in admin, and no emails, but funds in PayPal account.

    Thank you

  8. #28
    Join Date
    Jan 2015
    Location
    Cyprus
    Posts
    36
    Plugin Contributions
    0

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

    Hi Guys trying to reset all products master master directory ids in 1.5.7c php 7.4 mysql 5.7 (ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION)
    I get PHP Fatal error: 1366:Incorrect integer value as shown in the log below.

    [17-Oct-2021 13:25:56 UTC] Request URI: /admin/index.php?cmd=store_manager&action=update_all_master_categories_id, IP address: xx.xx.xx.xx
    #1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:170]
    #2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:142]
    #3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:269]
    #4 queryFactory->Execute() called at [/admin/store_manager.php:175]
    #5 require(/admin/store_manager.php) called at [/admin/index.php:11]
    --> PHP Fatal error: 1366:Incorrect integer value: '' for column 'master_categories_id' at row 1 :: UPDATE products SET master_categories_id='' WHERE products_id='2691' ==> (as called by) /admin/store_manager.php on line 175 <== in /includes/classes/db/mysql/query_factory.php on line 170.

  9. #29
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    11,408
    Plugin Contributions
    80

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

    Quote Originally Posted by Georgecy View Post
    Hi Guys trying to reset all products master master directory ids in 1.5.7c php 7.4 mysql 5.7 (ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION)
    I get PHP Fatal error: 1366:Incorrect integer value as shown in the log below.

    [17-Oct-2021 13:25:56 UTC] Request URI: /admin/index.php?cmd=store_manager&action=update_all_master_categories_id, IP address: xx.xx.xx.xx
    #1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:170]
    #2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:142]
    #3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:269]
    #4 queryFactory->Execute() called at [/admin/store_manager.php:175]
    #5 require(/admin/store_manager.php) called at [/admin/index.php:11]
    --> PHP Fatal error: 1366:Incorrect integer value: '' for column 'master_categories_id' at row 1 :: UPDATE products SET master_categories_id='' WHERE products_id='2691' ==> (as called by) /admin/store_manager.php on line 175 <== in /includes/classes/db/mysql/query_factory.php on line 170.
    You'll need to perform some "database surgery", since it appears that the product with id=2691 doesn't have an associated record in the products_to_categories table.

    If you inspect that product via phpMyAdmin, what shows as its master_categories_id? Is it a valid categories_id? If so, you can simply add a record to the products_to_categories table that associates products_id 2691 to its master_categories_id.

  10. #30
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    8,973
    Plugin Contributions
    119

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

    You may be able to track down some of these anomalies using the Audit tool:

    https://www.zen-cart.com/downloads.php?do=file&id=2261
    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.
    Do you benefit from Zen Cart? Then please support the project.

 

 
Page 3 of 4 FirstFirst 1234 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