mysql5.7: ttif.value which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

System error.

The following error message was returned:

Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tiki12svn_trackercalendar.ttif.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

The query was:
SELECT tti.*, ttif.`value`, ttf.`type`, `lastModif` as `sortvalue` FROM ( `tiki_tracker_items` tti INNER JOIN `tiki_tracker_item_fields` ttif ON tti.`itemId` = ttif.`itemId` INNER JOIN `tiki_tracker_fields` ttf ON ttf.`fieldId` = ttif.`fieldId`) WHERE tti.`trackerId` = ? and (`status`=? or `status`=?) AND `ttif`.`fieldId` IN( ?,?,?,?,?,? ) GROUP BY tti.`itemId` ORDER BY `sortvalue` desc

Values:

    1
    o
    p
    1
    2
    3
    4
    5
    6

The built query was likely:
SELECT tti.*, ttif.`value`, ttf.`type`, `lastModif` as `sortvalue` FROM ( `tiki_tracker_items` tti INNER JOIN `tiki_tracker_item_fields` ttif ON tti.`itemId` = ttif.`itemId` INNER JOIN `tiki_tracker_fields` ttf ON ttf.`fieldId` = ttif.`fieldId`) WHERE tti.`trackerId` = '1' and (`status`='o' or `status`='p') AND `ttif`.`fieldId` IN( '1','2','3','4','5','6' ) GROUP BY tti.`itemId` ORDER BY `sortvalue` desc

Stacktrace:
* /var/www/html/12.x/tiki-index.php : 0 -> {main}(array ( ))
* /var/www/html/12.x/tiki-index.php : 686 -> __toString(array ( ))
* /var/www/html/12.x/lib/core/Tiki/Render/Lazy.php : 22 -> call_user_func:{/var/www/html/12.x/lib/core/Tiki/Render/Lazy.php:22}(array ( ))
* /var/www/html/12.x/lib/core/Tiki/Render/Lazy.php : 22 -> {closure:/var/www/html/12.x/lib/wiki/renderlib.php:331-341}(array ( ))
* /var/www/html/12.x/lib/wiki/renderlib.php : 334 -> get_parse(array ( ))
* /var/www/html/12.x/lib/wiki/wikilib.php : 488 -> parse_data(array ( ))
* /var/www/html/12.x/lib/tikilib.php : 386 -> parse_data(array ( ))
* /var/www/html/12.x/lib/parser/parserlib.php : 1589 -> parse_first(array ( ))
* /var/www/html/12.x/lib/parser/parserlib.php : 476 -> plugin_execute(array ( ))
* /var/www/html/12.x/lib/parser/parserlib.php : 1018 -> wikiplugin_tabs(array ( ))
* /var/www/html/12.x/lib/wiki-plugins/wikiplugin_tabs.php : 84 -> parse_data(array ( ))
* /var/www/html/12.x/lib/tikilib.php : 386 -> parse_data(array ( ))
* /var/www/html/12.x/lib/parser/parserlib.php : 1589 -> parse_first(array ( ))
* /var/www/html/12.x/lib/parser/parserlib.php : 476 -> plugin_execute(array ( ))
* /var/www/html/12.x/lib/parser/parserlib.php : 1018 -> wikiplugin_trackerlist(array ( ))
* /var/www/html/12.x/lib/wiki-plugins/wikiplugin_trackerlist.php : 1692 -> list_items(array ( ))
* /var/www/html/12.x/lib/trackers/trackerlib.php : 1274 -> fetchAll(array ( ))
* /var/www/html/12.x/lib/core/TikiDb/Bridge.php : 32 -> fetchAll(array ( ))
* /var/www/html/12.x/lib/core/TikiDb/Pdo.php : 109 -> handleQueryError(array ( ))
* /var/www/html/12.x/lib/core/TikiDb.php : 148 -> handle(array ( ))

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