MM Core 2.1.10 Internal Server Error

**magicsepp** · 30.08.2020, 12:28

seit ich MM Core auf 2.1.10 upgedatet habe (CTO 4.4.51, CM 1.2 7) erhalte ich im BE folgende Fehlermeldung:

Code:

An exception occurred while executing 'SELECT sauna, COUNT(sauna) as mm_count FROM mm_sauna WHERE id IN (?, ?) GROUP BY sauna ORDER BY FIELD(id, ?, ?) ASC' with params ["160", "29", "160", "29"]: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'cto44.mm_sauna.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by