Universitas Project

Castellano English

Mapa web

  • Inicio
  • Presentación
  • Sobre Universitas
      • Error en la base de datos:

      Archivo: /mapa.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_galerias.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_galerias.id) AS ids,
      cg_fam_galerias.nombre_es AS fam_nombre_es, cg_fam_galerias.nombre_en AS fam_nombre_en, cg_fam_galerias.link AS fam_link,
      cg_cat_galerias.nombre_es AS cat_nombre_es, cg_cat_galerias.nombre_en AS cat_nombre_en, cg_cat_galerias.link AS cat_link,
      cg_subcat_galerias.nombre_es AS subcat_nombre_es, cg_subcat_galerias.nombre_en AS subcat_nombre_en, cg_subcat_galerias.link AS subcat_link
      FROM cg_galerias
      LEFT JOIN cg_fam_galerias ON cg_galerias.cg_fam_galeria_id = cg_fam_galerias.id
      LEFT JOIN cg_cat_galerias ON cg_galerias.cg_cat_galeria_id = cg_cat_galerias.id
      LEFT JOIN cg_subcat_galerias ON cg_galerias.cg_subcat_galeria_id = cg_subcat_galerias.id

      WHERE cg_galerias.activo = 1 AND cg_fam_galerias.activo = 1 AND cg_cat_galerias.activo = 1 AND cg_subcat_galerias.activo = 1

      GROUP BY cg_subcat_galerias.link, cg_cat_galerias.link, cg_fam_galerias.link

      ORDER BY cg_fam_galerias.orden ASC, cg_cat_galerias.orden ASC, cg_subcat_galerias.orden ASC