Hi all,
We have been trying to migrate one of our Silverstripe websites to a new server running MySQL 5.7. We have already updated our SS version to 3.5.3.
We've been experiencing issues with the sql_mode=only_full_group_by, example of error below:
[User Error] Uncaught SS_DatabaseException: Couldn't run query: SELECT DISTINCT "Download"."ClassName", "Download"."LastEdited", "Download"."Created", "Download"."Title", "Download"."ShowOnInstruments", "Download"."Restricted", "Download"."Index", "Download"."Slug", "Download"."FileID", "Download"."InstrumentID", "Download"."CategoryID", "Download"."ID", CASE WHEN "Download"."ClassName" IS NOT NULL THEN "Download"."ClassName" ELSE 'Download' END AS "RecordClassName" FROM "Download" WHERE ("CategoryID" = ?) GROUP BY FileID ORDER BY "Download"."Index" ASC, "Download"."Title" ASC Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bolton-surgical.Download.ClassName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
GET /downloads/
Line 55 in /srv/users/bolton/apps/bolton-surgical/public/framework/model/connect/DBConnector.php
We have already disabled strict sql mode in MySQL 5.7 on our server, which points to something inside SS overriding this setting.
Has anyone had experience with this issue? I did notice this page on the SS GitHub page: https://github.com/silverstripe/silverstripe-framework/issues/5451 but I don't think it actually shares a solution?
thanks
Matt.