OcurriĆ³ un error inesperado.

An exception occurred while executing 'SELECT OD.opendataID, OD.title as title_opendata, OD.organization, OD.url as url_opendata, OD.email_organization, ODD.datasetsID, ODD.title as title_datasets, ODD.description as description_datasets, ODD.url_download_page, ODD.author, ODD.email_author, ODD.tags, ODD.version, ODR.resourceID, ODR.resource_title, ODR.description as description_resource, ODL.licenseID, ODL.code_license, ODL.license_name, count(ODR.resourceID) as total_resource FROM dsOpenData as OD LEFT JOIN dsOpenDataDataset AS ODD ON OD.opendataID = ODD.opendataID LEFT JOIN dsOpenDataResource AS ODR ON ODD.datasetsID = ODR.datasetsID LEFT JOIN dsOpenDataLicense as ODL ON ODD.licenseID = ODL.licenseID WHERE ODD.opendataID =2 group by ODD.datasetsID ORDER BY ODD.title': SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #14 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dbMCDE.ODR.resourceID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

< Ir al Inicio