PHP Fatal error: 1366:Incorrect integer value

[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.

[keneso]

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

[Georgecy]

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.

[lat9]

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.

[swguy]

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