[BUGFIX] Fix MySQL specific language query in LocalizationController 98/45098/2
authorMorton Jonuschat <m.jonuschat@mojocode.de>
Wed, 2 Dec 2015 20:20:38 +0000 (21:20 +0100)
committerMarkus Klein <markus.klein@typo3.org>
Wed, 2 Dec 2015 20:37:08 +0000 (21:37 +0100)
Change the SQL statement used to query for available source languages to
be standards compliant by grouping on the queried field instead of the
counterpart in the joined tt_content table.

Resolves: #72017
Releases: master
Change-Id: I6902411f11e82a96513db640bc197e67ecba1e89
Reviewed-on: https://review.typo3.org/45098
Reviewed-by: Mathias Schreiber <mathias.schreiber@wmdb.de>
Tested-by: Mathias Schreiber <mathias.schreiber@wmdb.de>
Reviewed-by: Markus Klein <markus.klein@typo3.org>
Tested-by: Markus Klein <markus.klein@typo3.org>
typo3/sysext/backend/Classes/Controller/Page/LocalizationController.php

index 751440a..d26b132 100644 (file)
@@ -99,7 +99,7 @@ class LocalizationController
                     . ' AND sys_language.uid <> ' . (int)$languageId
                     . $additionalWhere
                     . $excludeQueryPart,
-                'tt_content.sys_language_uid',
+                'sys_language.uid',
                 'sys_language.title'
             );
             while ($row = $databaseConnection->sql_fetch_assoc($res)) {