(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 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 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, ) % line   37, file: lepage-catalogue.php

le catalogue Lepage


A B C D E F G H I J K L M N O P Q R S T U V W X Y Z A-Z

VIVACES

GRAMINÉES

PLANTES DE RIVES

FOUGÈRES

BULBES D'AUTOMNE

BULBES DE PRINTEMPS

BRUYÈRES

NOUVEAUTE

TOXIQUES