Issue Bug Under Review Quiet

#89965Copied textmedia element with sys_file_reference that has its language changed, makes the Datahandler throw up

Christian Eßl 12/16/19, 14:50 updated 10/14/26, 08:21

Description

Steps to reproduce:

- Create a new Site Config with the languages “Default” (0) and “German” (1)
- Create a page *A*
- On page A, create a new textmedia element with a file reference.
- Translate page A and the textmedia element to german

- Now create a page B*
- Translate page *B
to german
- Go to page A and copy the german localization of the textmedia element
- Go to page B and insert the textmedia element.
- Open up the newly copied textmedia element on page B and change the language of the element to “Default”.

Internally, the textmedia tt_content elements sys_language_uid will now correctly. change from 1 to 0. But the file reference that belongs to this element will NOT be updated and still has the sys_language_uid 1.
We now have created a mess in the sys_file_reference table and all kind of weird bugs can now happen.
For instance, if you now go to the page module and try to translate all content element to “German” with the Translate button, the wizard will crash with an error 500 and the exception message:
“Child record was not processed”. The tt_content textmedia element will not be translated, but the original tt_content (sys_language_uid) now has 3 file references instead of 1.

Reviews 2

Fix this issue

Start the commit message of your patch with this. Add what the patch does, and the versions it goes to in "Releases:". The changes above were merged or abandoned: read them before you start. How to create a patch

Commit message
[BUGFIX] Copied textmedia element with sys_file_reference that has its language changed, makes the Datahandler throw up Resolves: #89965 Releases: main

Files 3

History 57

  1. Christian Eßl commented <span data-processor="relativetime" data-value="2019-12-29T13:19:02+00:00" > 12/29/19, 13:19 </span>

    Tested around a bit:

    • Problem is reproducible on TYPO3 9.5.13.
    • Problem is reproducible on TYPO3 10.3
    • When copying a translated tt_content record to another page, the copied record will not be shown in the list module. (As it has a non-available l10n_parent)
    • However it will be shown in the page module and is editable. When you change the sys_language_uid to another one, the sys_language_uid of its inline relations (sys_file_reference in this example) will not be updated.
    I tried around if this happens with other types of records:
    • installed ext:news
    • created a news record on page A, translated the news record to “german”
    • Copied the german translation of the news record.
    • Inserted the copied record on page B

    The copied translation record will not be shown in the list module, as with the tt_content record. However it is still in the db.

    Two questions arise:
    1. Should it even be allowed to copy record translations that have an l10n_parent?
    2. Should the inline relations of a record be translated as well, when its sys_language_uid is changed?
  2. Riccardo De Contardi commented and changed attached Schermata 2020-08-30 alle 11.49.34.png attached Schermata 2020-08-30 alle 11.48.46.png attached Schermata 2020-08-30 alle 11.48.27.png <span data-processor="relativetime" data-value="2020-08-30T11:50:44+00:00" > 08/30/20, 11:50 </span>

    Is the problem still reproducible on 11.0.0-dev? How?

    I tried to follow the following steps:

    1) Multilanguage TYPO3 with 2 languages:

    - Italian (Default)
    - English (ID=1)

    2) Create a page Test89965-A and translate it in english (Test89965-A-ENG)
    3) Create a “text and images” CE in Test89965-A (in Italian); add an image and translate it

    Important!!: I used the “Connected” (translate) mode

    4) Create a page Test89965-B and translate it in english (Test89965-B-ENG)
    5) I go to page Test89965-A and try to copy the english version of the content

    … and this is where I had a stop: I was not able to find a “copy” icon

    - on page module > languages > context menu when clicking on the icon of the translated element
    - on page module > columns > english > context menu when clicking on the icon of the element
    - on list module

    see attached files

    Am I missing something?

  3. Gerrit Code Review pushed patch set 13 for main to change 87595 status New Under Review <span data-processor="relativetime" data-value="2026-10-13T20:00:54+00:00" > 10/13/26, 20:00 </span>