Fixing MySQL 5.7 troubles


Many hosters are now updating their machines to use MySQL 5.7. A minor update doesn’t sound that bad, unfortunately one small change in MySQL’s default config can cause major headaches and late night patching parties.

If you want to know more about it WMK wrote a blog post about it. That can be found here:

If you just need a quick fix sunnysideup shared a solution for SS4 here:

Lukas Erni created a composer patch for SilverStripe3 GitHub - lerni/silverstripe3-mysql57-fluent: [PATCH] A patch for SilverStripe to mimic the MySQL-Mode ANSI as with MySQL <5.7.x (remove ONLY_FULL_GROUP_BY) you can add to your composer.json.

Datlist multiple sort not working on live site