search

MISP / x_old_misp_docker

MISP Docker (XME edition)
283 stars 167 forks source link

incompatible with sql_mode=only_full_group_by #117

Open cudeso opened 3 years ago

cudeso commented 3 years ago

I received the below error with the latest (new install) Docker image (2.4.143) when accessing the diagnostics page.

Error: [PDOException] SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'information_schema.tables.DATA_LENGTH' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by Request URL: /servers/serverSettings/diagnostics

This was resolved by accessing the database container, connecting to mysql and issuing the command

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Leaving this here for reference.