Query with GROUP BY... problem with the new MySQL version 5.7
I'm upgrading an old DataAssist website with the new version (2.2.0 beta) and I've a problem with a query with "GROUP BY" declaration.
This is the error (see screenshot):
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'website_namedb.tbl_applications.id_applications' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
This is the query:
SELECT tbl_products.name_products, tbl_products.applications_products, tbl_products.applications_imagenew_products, tbl_products.url_products, tbl_applications.id_applications, tbl_applications.desc_it_applications, tbl_applications.desc_en_applications, tbl_applications.desc_ru_applications, tbl_applications.desc_es_applications, tbl_applications.desc_fr_applications, tbl_applications.desc_de_applications, tbl_applications.desc_ro_applications, tbl_applications.image_applications, tbl_applications.imagedett_applications, tbl_applications.imageg_applications, tbl_applications.video_applications, tbl_applications.article_applications, tbl_applications.stato_applications, tbl_applications.image_new_applications FROM tbl_products INNER JOIN tbl_applications ON tbl_products.id_products = tbl_applications.article_applications WHERE tbl_applications.stato_applications = 1 AND tbl_products.stato_products = 1 AND tbl_products.applications_products = 1 GROUP BY tbl_products.id_products ORDER BY tbl_products.name_products ASC
How can I fix it?
I'm using the last version of MySQL server (5.7).