Erreur générale

SQL ERROR [ mysql4 ]

Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'yankee2.l.ID_VOIT' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

SQL

select distinct p.nom,q.serie,q.numero,q.place,q.point_total,q.id_pilote_course, case when l.id_voit is null then 0 else exists(select * from S_VOIT_PAGE p where p.id_voit=l.id_voit and p.id_pilote=q.numero) end as pil from RES_PILOTE p inner join RES_PILOTE_COURSE pc on p.ID=pc.ID_PILOTE left join RES_QUALIF q on q.id_pilote_course=pc.id left join FVRC_TYPE_COURSE tc on tc.id=q.openpromo left join RES_LIEN_ALBUM l on l.id_course=pc.id_course and l.id_categorie=pc.id_categorie and l.id_type=pc.id_type and l.manche=q.manche and l.serie=q.serie and l.qualif=1 where pc.id_course=6 and pc.id_categorie=1 and pc.id_type=4 and q.manche=3 group by p.nom,q.serie,q.numero,q.place,q.point_total,q.id_pilote_course order by q.place

BACKTRACE

FILE: includes/db/mysql.php
LINE: 176
CALL: dbal->sql_error()

FILE: course/includes/functions.php
LINE: 614
CALL: dbal_mysql->sql_query()

FILE: course/res_cloture.php
LINE: 82
CALL: Rapport_qualif()

Contactez l’administrateur du forum ou le webmaster: mid@retromodelisme.com