Error in mySQL 5.7 strict mode

[animaux]

When in strict mode I get the following on my article index page in the backend:

Symphony Fatal Database Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'hanktest.s.sortorder' which is not in SELECT list; this is incompatible with DISTINCT

An error occurred while attempting to execute the following query

SELECT SQL_CACHE DISTINCT (s.id), f.id as `field_id` FROM `sym_sections` AS `s` LEFT JOIN `sym_fields` AS `f` ON `s`.id = `f`.parent_section WHERE `f`.id IN ('8') ORDER BY s.sortorder ASC

Backtrace

[/…/symphony/lib/toolkit/class.mysql.php:554]
MySQL->error();
[/…/symphony/lib/toolkit/class.mysql.php:770]
MySQL->query();
[/…/extensions/association_field/fields/field.association.php:108]
MySQL->fetch();
[/…/extensions/association_field/fields/field.association.php:176]
FieldAssociation->findOptions();
[/…/symphony/content/content.publish.php:734]
FieldAssociation->getToggleStates();
[/…/symphony/content/content.publish.php:356]
contentPublish->viewIndex();
[/…/symphony/content/content.publish.php:361]
contentPublish->switchboard();
[/…/symphony/lib/toolkit/class.administrationpage.php:496]
contentPublish->view();
[/…/symphony/content/content.publish.php:327]
AdministrationPage->build();
[/…/symphony/lib/core/class.administration.php:205]
contentPublish->build();
[/…/symphony/lib/core/class.administration.php:483]
Administration->buildPage();
[/…/symphony/lib/boot/func.utilities.php:253]
Administration->display();
[/…/symphony/lib/boot/func.utilities.php:235]
symphony_launcher();
[/…/index.php:19]
symphony();

Database Query Log

[0.0002] SET character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8';
[0.0001] SET CHARACTER SET 'utf8';
[0.0001] SET time_zone = '+01:00';
[0.0031] SELECT SQL_CACHE t1.name, t2.page, t2.delegate, t2.callback FROM sym_extensions as t1 INNER JOIN sym_extensions_delegates as t2 ON t1.id = t2.extension_id WHERE t1.status = 'enabled' ORDER BY t2.delegate, t1.name;
[0.0006] SELECT SQL_CACHE name FROM sym_extensions WHERE status = 'enabled';
[0.0005] SELECT SQL_CACHE session_data FROM sym_sessions WHERE session = '70ttddfc0s3upbl10v35hr3sus' LIMIT 1;
[0.0006] SELECT SQL_CACHE a. FROM sym_authors AS a WHERE username = 'goldwiege' ORDER BY a.id ASC LIMIT 1;
[0.0004] UPDATE sym_authors SET last_seen = '2019-03-27 09:16:34' WHERE id = 1;
[0.0004] SELECT SQL_CACHE FROM sym_extensions;
[0.0021] SELECT SQL_CACHE id FROM sym_sections WHERE handle = 'artikel' LIMIT 1;
[0.0008] SELECT SQL_CACHE FROM sym_sections_association AS sa, sym_sections AS s WHERE sa.child_section_id = 5 AND s.id = sa.parent_section_id ORDER BY s.sortorder ASC;
[0.0004] SELECT SQL_CACHE FROM sym_sections_association AS sa, sym_sections AS s WHERE sa.parent_section_id = 5 AND s.id = sa.child_section_id ORDER BY s.sortorder ASC;
[0.0006] SELECT SQL_CACHE s. FROM sym_sections AS s ORDER BY s.sortorder asc;
[0.0003] SELECT SQL_CACHE id FROM sym_sections WHERE handle = 'artikel' LIMIT 1;
[0.0003] SELECT SQL_CACHE id FROM sym_sections WHERE handle = 'artikel' LIMIT 1;
[0.0007] SELECT SQL_CACHE t1. FROM sym_fields AS t1 WHERE 1 AND t1.id IN(16);
[0.0006] SELECT SQL_CACHE FROM sym_fields_order_entries WHERE field_id IN (16);
[0.0006] SELECT SQL_CACHE d.pages, d.id FROM sym_documentation AS d ORDER BY d.pages ASC;
[0.0004] SELECT SQL_CACHE d.title, d.content_formatted FROM sym_documentation AS d WHERE d.id = '1' LIMIT 1;
[0.0003] SELECT SQL_CACHE id FROM sym_sections WHERE handle = 'artikel' LIMIT 1;
[0.0004] SELECT SQL_CACHE COUNT() FROM sym_entries WHERE section_id = '5';
[0.0006] SELECT SQL_CACHE e.id, e.section_id, e.author_id, e.modification_author_id, e.creation_date AS creation_date, e.modification_date AS modification_date , ed.value FROM sym_entries AS e LEFT OUTER JOIN sym_entries_data_16 AS ed ON (e.id = ed.entry_id) WHERE 1 AND e.section_id = 5 ORDER BY ed.value asc LI

[animaux]

@nitriques @jonmifsud
this is still an issue with some sites for me. Only workaround is disabling strict mode in mySQL 5.7.x. Any ideas how to fix this?