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

[kreativekorp/barcode

Generate barcodes from a single PHP file.

2839.9k](/packages/kreativekorp-barcode)[nosto/module-nostotagging

Increase your conversion rate and average order value by delivering your customers personalized product recommendations throughout their shopping journey.

27659.1k4](/packages/nosto-module-nostotagging)

PHPackages © 2026

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