This package is abandoned and no longer maintained. No replacement package was suggested.

A patch for SilverStripe to mimic the MySQL-Mode ANSI as with MySQL <5.7.x

Installs: 9 879

Dependents: 0

Suggesters: 0

Security: 0

Stars: 1

Watchers: 3

Forks: 0


dev-master 2018-08-23 14:34 UTC

This package is auto-updated.

Last update: 2023-04-11 01:24:04 UTC



  • SilverStripe >3.6 <4


Use composer: composer require lerni/silverstripe3-mysql57-fluent


This fix is for SS 3.x only with SS 4 you sould update fluent to 4.1 or use a config as sunnysideup has in his module to fix the same issue on 4.x https://github.com/sunnysideup/silverstripe-mysql-5-7-fix

framework sets MySQL-Mode on every DB-request to ANSI-Mode https://github.com/silverstripe/silverstripe-framework/blob/3/model/connect/MySQLDatabase.php#L45

As per MySQL 5.7 ANSI-Mode includs also ONLY_FULL_GROUP_BY and not only: REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-combo

With the ONLY_FULL_GROUP_BY sorting a DataObject by a fluent translated field throws an error like: [User Error] Uncaught SS_DatabaseException: Couldn't run query: SELECT DISTINCT ... this is incompatible with DISTINCT

This module patches MySQLDatabase.php to prevent the error above.