TYPO3 Core

How exactly do you retrieve the pages.media relations in your frontend?

Maybe the desciption is not clear enough. Besides the frontend, it is not possible to hide the pages.media on a fresh install in the backend. 1 file works, if you add a second one, you can not hide that file with the backend.

These may be two issues actually, I'm not sure yet.

I can reproduce this in v13 somehow. Only when having one invisible item, and then inserting from the popup, and then trying to hide the last item it doesn't work. Even if I enable the first one again, I cannot disable the second.

Only if I switch the order of first and second item and then save, it all becomes togle-able again.

I haven't tried to reproduce the frontend now. This needs further inspecting.

I've set this to "FormEngine" for now, in the hopes that "just" formEngine serializes wrong data into sys_file_reference and this affects both backend and frontend.

You can reproduce it in two ways. Hide on media in the backend (most time not possible) or edit the database to reproduce.

Search UID of multiple media resources with same PID:

SELECT `uid`,`pid` FROM `sys_file_reference` WHERE `deleted` = 0 AND `fieldname`= "media";

in my case:

+-----+-----+
| uid | pid |
+-----+-----+
|  27 |   1 |
|  42 |   1 |
|  43 |   1 |
|  70 |   1 |
|  71 |   1 |
|  72 |   1 |
|  18 |   5 |
| 305 |   5 |
|  88 |   5 |
| 306 |   5 |
|  44 |   7 |
|  87 |   7 |
|  90 |  14 |
|  61 |  14 |
| 124 |  34 |
| 125 |  34 |
| 149 |  34 |
| 150 |  34 |
| 161 |  38 |
| 148 |  38 |
+-----+-----+

Hide one media on one of these pages:

UPDATE `sys_file_reference` SET `hidden` = '1' WHERE `sys_file_reference`.`uid` = 18;

and "BAMM"

No file reference (sys_file_reference) was found for given UID: "18" 

My "workaround" for updates to 13 LTS is something like

UPDATE `sys_file_reference` SET `deleted` = '1' WHERE `hidden` = 1 AND `fieldname`= "media";

and the editors hate me

Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/88594

Ok, so I took a deep plunge into this the whole evening.

Turns out the cause of this is, that due to the typoscript config:

data = LEVELMEDIA: -1, slide

the RootlineUtility's resolving of records kicks into effect. This one DOES NOT QUERY LIVE INFORMATION of sys_file_reference!

Instead, due to performance reasons this was refactored in v13 with https://review.typo3.org/c/Packages/TYPO3.CMS/+/83729 - according to the changelog entry in https://docs.typo3.org/c/typo3/cms-core/main/en-us/Changelog/13.2/Important-103748-ReferenceIndexRebuildRequired.html it is now vital that the refindex is in synch. You probably upgraded or performed tasks to hide file references on the DB level, without updating the reference index first.

So the solution must be to keep the sys_refindex in shape, so that the queries succeed. Rebuilding the refindex should fix this case for you. If you do outside manipulation of sys_file_reference, be sure to adjust the refindex as well.

Due to this I will close this issue here. The remaining issue of not being able to properly hide/enable the file references (https://forge.typo3.org/issues/96135) has a seperate patch pending (https://review.typo3.org/c/Packages/TYPO3.CMS/+/88305) which we will hopefully address properly.

I hope this helps!