While I haven't tested this suggested change yet and I recognize that the above query was last incorporated when the database was *not* set to provide STRICT type operations, do you think you could try this revision?
In the current fileset (unchanged for a while now), the query that is assembled to give that result begins on line 1123 which is 10 lines before the query is executed. I would say then that if you were to go to line 1002 of your current admin/products_with_attributes_stock.php file and change the code from:
Code:
$query_products = "SELECT distinct pa.products_id
To:
Code:
$query_products = "SELECT distinct pa.products_id, d.products_name
By adding the comma and the additional field name, that perhaps the issue in this query would go away?
Note also, that as of this "second" the github fileset has not yet been updated to reflect that change either. I'll take a look as soon I can especially at any new queries to ensure they are "strict"-like compatible.
Could you
Bookmarks