#99516Editors can't delete or disable file references attached to sys_file_metadata
Description
Adding a sys_file_reference via TCA Overrides to the sys_file_metadata table.
Editors (Non-Admin) can add the reference but they can’t disable or remove them.
For example:
“Add a poster image to video files”
\TYPO3\CMS\Core\Utility\ExtensionManagementUtility::addTCAcolumns('sys_file_metadata', [
'poster' => [
'exclude' => 0,
'label' => 'Poster Image',
'config' => \TYPO3\CMS\Core\Utility\ExtensionManagementUtility::getFileFieldTCAConfig('poster', [
'appearance' => [
'createNewRelationLinkTitle' => 'LLL:EXT:frontend/Resources/Private/Language/locallang_ttc.xlf:media.addFileReference',
'collapseAll' => true,
],
'behaviour' => [
'allowLanguageSynchronization' => true
],
'overrideChildTca' => [
'types' => [
'0' => [
'showitem' => '
--palette--;;imageoverlayPalette,
--palette--;;filePalette'
],
\TYPO3\CMS\Core\Resource\File::FILETYPE_IMAGE => [
'showitem' => '
--palette--;;imageoverlayPalette,
--palette--;;filePalette'
],
],
'columns' => [
'link' => false,
'description' => false,
'alternative' => false,
'title' => false,
],
],
'maxitems' => 1,
'minitems' => 0,
],
'jpg,png,svg'
)
],
]);
\TYPO3\CMS\Core\Utility\ExtensionManagementUtility::addToAllTCAtypes($table,
'poster',
\TYPO3\CMS\Core\Resource\File::FILETYPE_VIDEO,
'after:duration');
The sys_file_reference is stored on pid=0 which shouln’t be a problem, since sys_file_reference has
'security' => [
'ignoreWebMountRestriction' => true,
'ignoreRootLevelRestriction' => true,
],
in the ctrl section.
Another example:
https://github.com/thomasrawiel/video-vtt/blob/main/Configuration/TCA/Overrides/sys_file_metadata.php
Related:
https://forge.typo3.org/issues/75332
A decision was announced to merge sys_file and sys_filemetadata but that was 5 years ago
https://forge.typo3.org/issues/81308#change-356775
Please reevaluate this problem.
Reviews 3
Related issues 4
- Bug #75332Saving relations to files in sys_file_metadata does not work for normal users
- Bug #77487File references to file metadata cannot be deleted
- Bug #81308Deleting a referenced file via filelist module, definined in sys_file_metadata
- Bug #105132Allow Editors to edit file reference of file metadata
Files 4
History 819
-
Georg Ringer changed Related to #75332 <span data-processor="relativetime" data-value="2024-07-05T06:33:44+00:00" > 07/05/24, 06:33 </span>
-
Georg Ringer changed Related to #81308 <span data-processor="relativetime" data-value="2024-07-05T06:35:23+00:00" > 07/05/24, 06:35 </span>
-
Gerrit Code Review pushed patch set 1 for main to change 85110 status
NewUnder Review <span data-processor="relativetime" data-value="2024-07-05T07:33:49+00:00" > 07/05/24, 07:33 </span> -
Jens Jacobsen changed Related to #77487 <span data-processor="relativetime" data-value="2024-08-08T14:20:23+00:00" > 08/08/24, 14:20 </span>
-
Jens Jacobsen commented and changed attached Bildschirmfoto 2024-08-08 um 14.24.28.png attached Bildschirmfoto 2024-08-08 um 14.23.14.png TYPO3 Version
1012 PHP Version7.48.3 <span data-processor="relativetime" data-value="2024-08-08T14:22:29+00:00" > 08/08/24, 14:22 </span> -
Gerrit Code Review pushed patch set 2 for main to change 85110 <span data-processor="relativetime" data-value="2024-10-18T13:39:10+00:00" > 10/18/24, 13:39 </span>
-
Ernesto Baschny commented <span data-processor="relativetime" data-value="2025-01-08T15:36:12+00:00" > 01/08/25, 15:36 </span>
Same problem applies to the other “icons” which the admin sees but an editor not: hide/unhide, sort.up, sort.down.
I needed this fix for an older v11 installation, so I created a patch for it for our own projects – https://github.com/baschny/typo3/pull/2
If there is interest, I could update the open review from @just2b (https://review.typo3.org/c/Packages/TYPO3.CMS/+/85110) to add the missing icons to the newer v13+ patch too (before it gets merged).
-
Gerrit Code Review pushed patch set 3 for main to change 85110 <span data-processor="relativetime" data-value="2025-02-12T08:16:38+00:00" > 02/12/25, 08:16 </span>
-
Gerrit Code Review pushed patch set 4 for main to change 85110 <span data-processor="relativetime" data-value="2025-09-12T09:14:42+00:00" > 09/12/25, 09:14 </span>
-
Gerrit Code Review pushed patch set 5 for main to change 85110 <span data-processor="relativetime" data-value="2026-04-22T06:56:05+00:00" > 04/22/26, 06:56 </span>
-
Gerrit Code Review pushed patch set 1 for main to change 94129 <span data-processor="relativetime" data-value="2026-05-21T14:35:56+00:00" > 05/21/26, 14:35 </span>
-
Gerrit Code Review pushed patch set 6 for main to change 85110 <span data-processor="relativetime" data-value="2026-05-21T14:50:49+00:00" > 05/21/26, 14:50 </span>
-
Gerrit Code Review pushed patch set 7 for main to change 85110 <span data-processor="relativetime" data-value="2026-08-03T10:43:56+00:00" > 08/03/26, 10:43 </span>
-
Anton Danilov changed Duplicated by #110814 <span data-processor="relativetime" data-value="2026-09-28T18:26:14+00:00" > 09/28/26, 18:26 </span>
-
Gerrit Code Review pushed patch set 8 for main to change 85110 <span data-processor="relativetime" data-value="2026-11-03T09:55:10+00:00" > 11/03/26, 09:55 </span>
-
Gerrit Code Review pushed patch set 9 for main to change 85110 <span data-processor="relativetime" data-value="2026-11-10T16:14:17+00:00" > 11/10/26, 16:14 </span>
-
Gerrit Code Review pushed patch set 1 for 14.3 to change 97583 <span data-processor="relativetime" data-value="2026-11-12T18:41:36+00:00" > 11/12/26, 18:41 </span>
-
Georg Ringer commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2026-11-12T18:45:11+00:00" > 11/12/26, 18:45 </span>Applied in changeset commit:609cdf61ccc5025d22893779e3952bfa45fd8dfe.
-
Benni Mack changed Related to #105132 <span data-processor="relativetime" data-value="2026-11-15T14:02:07+00:00" > 11/15/26, 14:02 </span>
Update TYPO3 version and PHP Version, bug is still present in 12.4 LTS.