PHP Fatal error: 1366:Incorrect integer value

[mc12345678]

Thanks a lot,
Based on your instructions I discover more than one disabled product without a master category (Warning: No Master Category ID has been set for this Product). Unfortunately ZC does not allow me to either delete the product(as is not needed) or add the Master category to the product. Any further help will be appreciated.

It is helpful to identify what has been attempted to add/modify the master category. For example, in the checkboxes that are presented, was the product attempted to be linked to another category?
What about back at the products/category listing for the root of the store, does the lone product appear possibly at the last page of categories so that it could be copied as a linked product to another category?

Again, explaining what has been tried (please be as specific as possible) it is eaiser to describe what to try and what may work. I *am* going to try in a little bit to populate a test store with a product that has an "empty" master category that is not linked elsewhere and see what can be done. This was previously something relatively easily resolved, but in streamlining the code to operate "normally" such issues are now harder to resolve from within the admin.

[Georgecy]

The link manager shows no links. And when trying to move the product in a new category it has no effect. It seems around 10 products which are related have no master category id

[swguy]

Did you try following the advice I gave you to use the Audit plugin?

[Georgecy]

Hi Scott,
Sorry I did not see the initial post but the Audit plug in worked great and solved all the issues. I manage to fix and delete the problematic items and the reset of Master category ids worked without problem.
Thank you all guys for the great work you are doing.

[Georgecy]

Hi Guys, suddenly I can not enter any products in Zencart 1.5.7d. The error is PHP Fatal error: 1366:Incorrect integer value: '' for column 'products_xsell_sort_order' at row 1 and the log is below.
[25-Jul-2022 10:34:34 UTC] Request URI: /macadmin1/index.php?cmd=product&cPath=402&action=insert_product, IP address: xxx
#1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/includes/functions/database.php:44]
#5 zen_db_perform() called at [/admin/includes/modules/update_product.php:72]
#6 require(/admin/includes/modules/update_product.php) called at [/admin/product.php:33]
#7 require(/admin/product.php) called at [/admin1/index.php:11]
--> PHP Fatal error: 1366:Incorrect integer value: '' for column 'products_xsell_sort_order' at row 1 :: INSERT INTO products (products_quantity, products_type, products_model, products_xsell_sort_order, products_price, products_date_available, products_weight, products_status, products_virtual, products_tax_class_id, manufacturers_id, products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute, product_is_free, product_is_call, products_quantity_mixed, product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order, products_discount_type, products_discount_type_from, products_price_sorter, products_image, products_date_added, master_categories_id) VALUES ('0', '1', '', '', '84.0336', null, '0', '1', '0', '1', '0', '1', '1', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '0', 'Apple Watch 7 + AirPods 2 June Offer CampaignFB.jpg', now(), '402') ==> (as called by) /includes/functions/database.php on line 44 <== in /includes/classes/db/mysql/query_factory.php on line 171.

[carlwhat]

Hi Guys, suddenly I can not enter any products in Zencart 1.5.7d. The error is PHP Fatal error: 1366:Incorrect integer value: '' for column 'products_xsell_sort_order' at row 1 and the log is below.
[25-Jul-2022 10:34:34 UTC] Request URI: /macadmin1/index.php?cmd=product&cPath=402&action=insert_product, IP address: xxx
#1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/includes/functions/database.php:44]
#5 zen_db_perform() called at [/admin/includes/modules/update_product.php:72]
#6 require(/admin/includes/modules/update_product.php) called at [/admin/product.php:33]
#7 require(/admin/product.php) called at [/admin1/index.php:11]
--> PHP Fatal error: 1366:Incorrect integer value: '' for column 'products_xsell_sort_order' at row 1 :: INSERT INTO products (products_quantity, products_type, products_model, products_xsell_sort_order, products_price, products_date_available, products_weight, products_status, products_virtual, products_tax_class_id, manufacturers_id, products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute, product_is_free, product_is_call, products_quantity_mixed, product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order, products_discount_type, products_discount_type_from, products_price_sorter, products_image, products_date_added, master_categories_id) VALUES ('0', '1', '', '', '84.0336', null, '0', '1', '0', '1', '0', '1', '1', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '0', 'Apple Watch 7 + AirPods 2 June Offer CampaignFB.jpg', now(), '402') ==> (as called by) /includes/functions/database.php on line 44 <== in /includes/classes/db/mysql/query_factory.php on line 171.

the problem looks to be with a paid plugin. specifically this one here:

https://www.thatsoftwareguy.com/zenc...ed_family.html

my guess is that you are running into a problem with mysql strict mode. you can either turn off mysql strict mode, or contact the developer for an updated version.

best.

[mc12345678]

The link manager shows no links. And when trying to move the product in a new category it has no effect. It seems around 10 products which are related have no master category id

So, I created a product assigned to the test examples category. I then set the master_categories_id to '' for that product. I then went to Catalog->Categories/Products. Then I typed in the products_id that was associated with that product in the search field. The product appeared in the list. I then copied the product as a linked product to the category desired (at this point it was back to the Test Examples category). I then again went to "copy" the product but this time going to the link manager, I was presented with the product and the ability to change the master category through the dropdown selection.

So, then I followed the consideration previously described by lat9 about the products_to_categories table having bad information. In this case I removed all information from that table associated with my "problem" product. I again reset the master category to ''. So basically, the database would have data that there is a "product" but it isn't associated with anything.

This time, when I went through the copy as a linked product process, it appeared "successful" but the product did not appear anywhere other than by searching on its products_id. I then again attempted to access the link manager from the copy product action, and this time the series of checkboxes did not appear, but the product was shown at the top of the list and that there was an invalid master category assigned.

I admit that in a way I gave up trying to find a way to create a record in the products_to_categories table for this product at this point. But of course I thought, what about possibly moving the product? Nope, that wasn't a success either even though no message was provided on screen. A debug log was generated, but...

When I then added a record to the products_to_categories table for this one product even if it was to the main category I was then able to correct the issue as described above. So, yeah, first thing/important thing is to ensure that the products_id exists in the products_to_categories table in order to move forwards even if correcting this within the admin is otherwise not so easy, it still can be done until those options too are removed.