Project

General

Profile

Actions

Bug #85159

closed

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

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

Status:
Closed
Priority:
Should have
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 #1

Updated by Dmitry no-lastname-given almost 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 #2

Updated by Michael Stucki almost 6 years ago

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

Wrong project.

Actions #3

Updated by Riccardo De Contardi almost 6 years ago

  • Category set to Localization
Actions #4

Updated by Georg Ringer almost 6 years ago

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

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

Updated by Sybille Peters over 5 years ago

  • Tags set to exception_handling
Actions #6

Updated by Gianluigi Martino over 5 years ago

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

Actions #7

Updated by Mathias Brodala over 5 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 #8

Updated by Mathias Brodala over 5 years ago

  • Status changed from New to In Progress
  • Assignee set to Mathias Brodala
Actions #9

Updated by Gerrit Code Review over 5 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 #10

Updated by Gerrit Code Review over 5 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 #11

Updated by Mathias Brodala over 5 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #12

Updated by Benni Mack almost 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF