Stock by Attribute v4.0 addon for v1.3.5-1.3.9

[mc12345678]

I found another error I try to explain it to you, in catalog -> SBA aka if I press the link sort


copy error log

[27-May-2020 02:14:37 Europe/Rome] Request URI: /admin/products_with_attributes_stock.php?action=auto_sort&search_order_by=p.products_m odel, IP address: 151.64.208.91
#1 trigger_error() called at [/web/htdocs/www.miosito.com/home/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/web/htdocs/www.miosito.com/home/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/web/htdocs/www.miosito.com/home/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/web/htdocs/www.miosito.com/home/admin/products_with_attributes_stock.php:695]

[27-May-2020 02:14:37 Europe/Rome] PHP Fatal error: 1366:Incorrect integer value: '' for column 'sort' at row 1 :: UPDATE products_with_attributes_stock set sort = '' WHERE stock_id = '3' LIMIT 1; ==> (as called by) /web/htdocs/www.miosito.com/home/admin/products_with_attributes_stock.php on line 695 <== in /web/htdocs/www.miosito.com/home/includes/classes/db/mysql/query_factory.php on line 167

For me the modolu SBA after last modification is fine and it is fantastic and thank you very much for creating it, I am trying everything in your form for any errors that I will report as I find them, explaining the best I can. thanks again I continue my test...

Hmm. Trying to remember why I wrote this the way I did...

Basically it oges: if there are no records to report, set the sort order to the non-existent value and then increment on it... I guess what I was trying to do was to request the software to use the default value for the field instead of trying to always use a field value of zero.. Really at the time it came down to seeing that it worked in the environment that was used to test.

While currently a value of 0 can be substituted (or the value "unnecessarily" cast as an integer) I do plan to further implement the targetted goal of identifying the expected value to implement the potential of the table having an other than 0 default value...