Project

General

Profile

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:
8
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

Also available in: Atom PDF