Error "SELECT list is not in GROUP BY" clicking on Log

[Manaus]

When clicking on the log menu item I get this error:

Symphony Fatal Database Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sym_symphony3.sym_search_index_logs.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

An error occurred while attempting to execute the following query

SELECT SQL_CACHE id, keywords, keywords_manipulated, date, sections, results, MAX(page) as `depth`, session_id FROM `sym_search_index_logs` GROUP BY keywords, session_id ORDER BY date desc LIMIT 0, 20

I'm using Symphony 2.7.10 on php 7.1.13, mysql 5.7.26
The plugin seems like working, but still I get this error in the admin side.

[animaux]

Hmm, I never came across that one. Would be interesting to see what is needed to replicate the error. I can’t be of much help with SQL-errors, though. :(

[wdebusschere]

@Manaus @animaux
This happens when you have only_full_group_by SQL mode on (This is the new default).
If you want compatibility for old queries, you can turn off the only_full_group_by SQL mode.