« Utilisateur:L.strappazzon » : différence entre les versions
De Le dictionnaire
Aucun résumé des modifications |
Aucun résumé des modifications |
||
| Ligne 1 : | Ligne 1 : | ||
{{#cargo_query:tables=SousEntrees | {{#cargo_query:tables=SousEntrees | ||
|fields=disciplines | |fields=_pageName,disciplines | ||
|order by=disciplines | |order by=disciplines | ||
|group by=disciplines | |group by=disciplines | ||
Version du 15 janvier 2024 à 18:22
Error 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'acadpharm_prod.A_cargo__SousEntrees._pageName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `_pageName`,`A_cargo__SousEntrees__disciplines`.`_value` AS `disciplines` FROM `A_cargo__SousEntrees` LEFT OUTER JOIN `A_cargo__SousEntrees__disciplines` ON ((`A_cargo__SousEntrees`.`_ID`=`A_cargo__SousEntrees__disciplines`.`_rowID`)) GROUP BY `A_cargo__SousEntrees__disciplines`.`_value` ORDER BY `A_cargo__SousEntrees__disciplines`.`_value` LIMIT 100
