[BUGFIX] Fix translated file relation with sql_mode=ONLY_FULL_GROUP_BY 26/58826/2
authorMathias Brodala <mbrodala@pagemachine.de>
Wed, 31 Oct 2018 16:34:11 +0000 (17:34 +0100)
committerFrank Naegler <frank.naegler@typo3.org>
Fri, 2 Nov 2018 11:34:05 +0000 (12:34 +0100)
The SQL mode ONLY_FULL_GROUP_BY enforces all fields used in "GROUP BY"
to be present in "SELECT".

See https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html#sqlmode_only_full_group_by

Resolves: #85159
Releases: master, 8.7
Change-Id: Iff7895dd9703557ca0b91613516bdb3391b4d4f6
Reviewed-on: https://review.typo3.org/58826
Reviewed-by: Mathias Brodala <mbrodala@pagemachine.de>
Tested-by: Mathias Brodala <mbrodala@pagemachine.de>
Tested-by: TYPO3com <no-reply@typo3.com>
Reviewed-by: Frank Naegler <frank.naegler@typo3.org>
Tested-by: Frank Naegler <frank.naegler@typo3.org>
typo3/sysext/backend/Classes/Form/FormDataProvider/TcaInputPlaceholders.php

index 8a9d0f2..d5d7233 100644 (file)
@@ -243,7 +243,7 @@ class TcaInputPlaceholders implements FormDataProviderInterface
                     $queryBuilder->createNamedParameter([$currentLanguage, 0], Connection::PARAM_INT_ARRAY)
                 )
             )
-            ->groupBy($languageField)
+            ->groupBy($languageField, 'uid')
             ->execute()
             ->fetchAll();