Issue Bug Closed

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

Dmitry no-lastname-given 06/05/18, 15:52 updated 05/07/19, 12:17

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.

Reviews 2