(mysqli): select CHAR_P_GENRE,ID_ARTICLE,BE_P_TOXIQUE FROM ARTICLE
inner join PLANTE on ID_ARTICLE=PKFKID_ARTICLE
where CHAR_P_GENRE<>'' and BE_P_TOXIQUE=1 and BE_A_ACTIVE=1 and CHAR_P_GENRE like "D%"
and ID_ARTICLE in(select distinct PKFKID_ARTICLE from ARTICLE_APPARTENIR_COLLECTION where PKFKID_COLLECTION =1)
group by trim(CHAR_P_GENRE) order by CHAR_P_GENRE ASC
Query: select CHAR_P_GENRE,ID_ARTICLE,BE_P_TOXIQUE FROM ARTICLE
inner join PLANTE on ID_ARTICLE=PKFKID_ARTICLE
where CHAR_P_GENRE<>'' and BE_P_TOXIQUE=1 and BE_A_ACTIVE=1 and CHAR_P_GENRE like "D%"
and ID_ARTICLE in(select distinct PKFKID_ARTICLE from ARTICLE_APPARTENIR_COLLECTION where PKFKID_COLLECTION =1)
group by trim(CHAR_P_GENRE) order by CHAR_P_GENRE ASC failed. Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'LEPAGEV3.PLANTE.CHAR_P_GENRE' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'LEPAGEV3.PLANTE.CHAR_P_GENRE' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
ADOConnection._Execute(select CHAR_P_GENRE,ID_ARTICLE,BE_P_TOXIQUE FROM ARTICLE inner join PLANTE on ID_ARTICLE=PKFKID_ARTICLE where CHAR_P_GEN..., false) % line 1082, file: adodb-mysqli.inc.php
ADODB_mysqli.execute(select CHAR_P_GENRE,ID_ARTICLE,BE_P_TOXIQUE FROM ARTICLE inner join PLANTE on ID_ARTICLE=PKFKID_ARTICLE where CHAR_P_GEN...) % line 5142, file: datalib.php
select_list(Object:ADODB_mysqli, select CHAR_P_GENRE,ID_ARTICLE,BE_P_TOXIQUE FROM ARTICLE inner join PLANTE on ID_ARTICLE=PKFKID_ARTICLE where CHAR_P_GEN...) % line 608, file: datalib.php
dl_catalogue_select_list_genre_by_id_toxique(Object:ADODB_mysqli, 1, D) % line 37, file: lepage-catalogue.php
