PHPackages                             lerni/silverstripe3-mysql57-fluent - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Utility & Helpers](/categories/utility)
4. /
5. lerni/silverstripe3-mysql57-fluent

AbandonedArchivedSilverstripe-patch[Utility & Helpers](/categories/utility)

lerni/silverstripe3-mysql57-fluent
==================================

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

111.3k

Since Aug 23Pushed 7y ago2 watchersCompare

[ Source](https://github.com/lerni/silverstripe3-mysql57-fluent)[ Packagist](https://packagist.org/packages/lerni/silverstripe3-mysql57-fluent)[ RSS](/packages/lerni-silverstripe3-mysql57-fluent/feed)WikiDiscussions master Synced 1mo ago

READMEChangelogDependenciesVersions (1)Used By (0)

SilverStripe 3.x Composer installable patch to mimic MySQL-Mode ANSI configuration as MySQL <5.7.x
=====================================================================================================

[](#silverstripe-3x-composer-installable-patch-to-mimic-mysql-mode-ansi-configuration-as-mysql-57x)

-

Requirements
------------

[](#requirements)

- SilverStripe >3.6 <4

Installation
------------

[](#installation)

Use [composer](https://getcomposer.org/): `composer require lerni/silverstripe3-mysql57-fluent`

Background
----------

[](#background)

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

framework sets MySQL-Mode on every DB-request to ANSI-Mode

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`

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.

###  Health Score

25

—

LowBetter than 37% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity25

Limited adoption so far

Community4

Small or concentrated contributor base

Maturity40

Maturing project, gaining track record

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

### Community

Maintainers

![](https://www.gravatar.com/avatar/e68b89567976eada21fddc5e776f4adcbe15ad846150cbcde6eb24bc185a8e5f?d=identicon)[lerni](/maintainers/lerni)

### Embed Badge

![Health badge](/badges/lerni-silverstripe3-mysql57-fluent/health.svg)

```
[![Health](https://phpackages.com/badges/lerni-silverstripe3-mysql57-fluent/health.svg)](https://phpackages.com/packages/lerni-silverstripe3-mysql57-fluent)
```

###  Alternatives

[jordanmiguel/laravel-popular

A Laravel package to track popularity of entries(by Models) in a website at a certain time.

659.6k1](/packages/jordanmiguel-laravel-popular)[jaaulde/php-ipv4

PHP classes for working with IPV4 addresses and networks.

1034.6k](/packages/jaaulde-php-ipv4)[ip2location/ip2location-cakephp

Lookup for visitor's IP information, such as country, region, city, coordinates, zip code, time zone, ISP, domain name, connection type, area code, weather, MCC, MNC, mobile brand name, elevation and usage type.

224.6k](/packages/ip2location-ip2location-cakephp)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)