#93296Wrong handling of file references in Workspace
Description
Description
When using Workspaces (and having two states of a record in the DB) some references are linked to the wrong state.
Result is that I have access to one related reference (sys_category) but not to another reference (sys_file)
Reproduce
1. Create a workspace and switch to it
1. Create a new page
1. in DB there are now two pages, let’s say UID:10 and UID:11, where UID:11 record has UID:10 in t3ver_oid
1. Add a category on this page
1. in DB UID:11 record has 1 category, in sys_category_record_mm the category is also linked to UID:11
1. Add a file into field media in page record
1. in DB UID:11 record has 1 media, but sys_file_reference has no relation to UID:11 but UID:10
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.
History 1
-
Benni Mack commented and changed status
NewRejected <span data-processor="relativetime" data-value="2024-11-22T14:55:40+00:00" > 11/22/24, 14:55 </span>
Sorry, but I must close this issue. The behavior you described is correct:
“MM” tables (sys_category_record_mm) have no workspace information other than the actual IDs (thus, they must point to the actual “non-live” and “non-default-language” IDs). This actually has a lot of drawbacks (like re-sorting etc).
Inline (in this case “media”) you always reference the “live” record, as the inline record knows it is “new”.
TYPO3 v11 got better in this regard, especially when moving or creating new relations, but it would still be better to have ONE way to deal with this.