Documents

Error en la base de datos:



---

Archivo: /en/documentos.html, mét. GET)
Error (cod. 1055): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'qwd050.cg_fam_documentos.nombre_es' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query:
SELECT
GROUP_CONCAT(cg_documentos.id) AS ids,
cg_fam_documentos.nombre_es AS fam_nombre_es, cg_fam_documentos.nombre_en AS fam_nombre_en, cg_fam_documentos.link AS fam_link,
cg_cat_documentos.nombre_es AS cat_nombre_es, cg_cat_documentos.nombre_en AS cat_nombre_en, cg_cat_documentos.link AS cat_link,
cg_subcat_documentos.nombre_es AS subcat_nombre_es, cg_subcat_documentos.nombre_en AS subcat_nombre_en, cg_subcat_documentos.link AS subcat_link
FROM cg_documentos
LEFT JOIN cg_fam_documentos ON cg_documentos.cg_fam_galeria_id = cg_fam_documentos.id
LEFT JOIN cg_cat_documentos ON cg_documentos.cg_cat_galeria_id = cg_cat_documentos.id
LEFT JOIN cg_subcat_documentos ON cg_documentos.cg_subcat_galeria_id = cg_subcat_documentos.id

WHERE cg_documentos.activo = 1 AND cg_fam_documentos.activo = 1 AND cg_cat_documentos.activo = 1 AND cg_subcat_documentos.activo = 1

GROUP BY cg_subcat_documentos.link, cg_cat_documentos.link, cg_fam_documentos.link

ORDER BY cg_fam_documentos.orden ASC, cg_cat_documentos.orden ASC, cg_subcat_documentos.orden ASC