Skip to content

Fix missing Group By element with PostgreSQL

2023-05-09 09:14:01 DEBUG   91.172.209.155, 100.64.8.21 -> 100.64.8.27 sql=SELECT d.fk_project, d.fk_element_det FROM llx_element_project_dispatch as d LEFT JOIN llx_commande_fournisseurdet as el ON d.fk_element_det=el.rowid LEFT JOIN llx_commande_fournisseur as o ON d.fk_element = o.rowid WHERE d.elementtype = 'supplier_order' AND o.rowid = 1111 GROUP BY d.fk_project
2023-05-09 09:14:01 ERR     91.172.209.155, 100.64.8.21 -> 100.64.8.27 DoliDBPgsql::query SQL Error message: ERROR:  42803: column "d.fk_element_det" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT d.fk_project, d.fk_element_det FROM llx_element_proje...
                             ^
LOCATION:  check_ungrouped_columns_walker, parse_agg.c:1423 (DB_ERROR_42803)
  • Version actuelle de Dolibarr : 16.0.3
  • Version du module : 1.5.6
  • SGBD : PostgreSQL 15.1