Bug #85159: Trying to edit record with image that has localised metadata fails with exception - TYPO3 Core - TYPO3 Forge

Actions

Copy link

Bug #85159

closed

Trying to edit record with image that has localised metadata fails with exception

Added by Dmitry no-lastname-given over 6 years ago. Updated over 5 years ago.

Status:

Closed

Priority:

Should have

Assignee:

Mathias Brodala

Category:

Localization

Target version:

Start date:

2018-06-05

Due date:

% Done:

100%

Estimated time:

TYPO3 Version:

PHP Version:

Tags:

exception_handling

Complexity:

Is Regression:

Sprint Focus:

Description

If you try to edit CTE "Text & Images" that has relation to image, that has localised metadata - it fails with exception -

Uncaught TYPO3 Exception
An exception occurred while executing 'SELECT `uid`, `sys_language_uid` FROM `sys_file_metadata` WHERE (`uid` IN (?, ?)) AND (`sys_language_uid` IN (?, ?)) GROUP BY `sys_language_uid`' with params ["41", "3", "0", 0]: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'website.sys_file_metadata.uid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by.

Trace attached.

Files

trace.txt (11.9 KB) trace.txt

Dmitry no-lastname-given, 2018-06-05 15:51

Actions

Copy link

Updated by Dmitry no-lastname-given over 6 years ago

TYPO3 Version 8.7.15
Webserver nginx/1.12.2
PHP Version 7.0.25
Database (Default) MySQL 5.7.20
Application Context Development
Composer mode Enabled
Operating System Linux 3.10.0-514.26.2.el7.x86_64

Actions

Copy link

Updated by Michael Stucki over 6 years ago

Project changed from 9 to TYPO3 Core
TYPO3 Version set to 8

Wrong project.

Actions

Copy link

Updated by Riccardo De Contardi over 6 years ago

Category set to Localization

Actions

Copy link

Updated by Georg Ringer over 6 years ago

also in master
app/web/typo3/sysext/backend/Classes/Form/FormDataProvider/TcaInputPlaceholders.php:241

$queryBuilder->select('uid', $languageField)
...
->groupBy($languageField)

Actions

Copy link

Updated by Sybille Peters over 6 years ago

Tags set to exception_handling

Actions

Copy link

Updated by Gianluigi Martino about 6 years ago

Have somebody a solution for this problem?
I have the same message..

Actions

Copy link

Updated by Mathias Brodala about 6 years ago

Gianluigi Martino wrote:

Have somebody a solution for this problem?

The solution would be to add uid to the list of GROUP BY fields.

I have the same message..

Same here, I just stumbled upon this and will try to push a fix within the next days.

Actions

Copy link

Updated by Mathias Brodala about 6 years ago

Status changed from New to In Progress
Assignee set to Mathias Brodala

Actions

Copy link

Updated by Gerrit Code Review about 6 years ago

Status changed from In Progress to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/58813

Actions

Copy link

#10

Updated by Gerrit Code Review about 6 years ago

Patch set 1 for branch TYPO3_8-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/58826

Actions

Copy link

#11