Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
L lfeditor
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 13
    • Issues 13
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge requests 1
    • Merge requests 1
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Operations
    • Operations
    • Incidents
    • Environments
  • Analytics
    • Analytics
    • CI/CD
    • Repository
    • Value Stream
  • Members
    • Members
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • TYPO3
  • lfeditor
  • Issues
  • #11

Closed
Open
Created Sep 15, 2017 by Fabian Galinski@fgalinski😾Maintainer

Loading sys_language records fails with MySQL 5.7

Ticket on Forge: https://forge.typo3.org/issues/79855

Author: Sebastian Michaelsen

Description:

In \SGalinski\Lfeditor\Service\SysLanguageService::selectFromSysLanguageByUids the following query is created:

SELECT uid, title, flag FROM sys_language GROUP BY flag ASC

It works for me with MySQL 5.6.19 but fails for MySQL 5.7.17:

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'naturata.sys_language.uid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

5.7 seems to have changed behaviour regarding GROUP BY: https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html

Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking