TYPO3 Core

Hello,

If you have an article with related news, and you make a new version in a draft workspace a new relation is made in the tt_news related articles table.

If you then go to the versioning or workspaces module and remove the version from the workspace the relationship in the related table is left there still.

This causes all the different versions to show up in the FE in news SINGLE display because the function that gets the related news doesn't check that the pid of articles is not less than 0. I created a bug report about this.

Is it the job of the workspaces extension to remove these entries? Also the article versions removed from the workspace are still in the tt_news table, shouldn't they be actually delete from the table? Otherwise if you have loads of editors editng news, maybe the changes get rejected or removed form the workspace multiple times and then the tt_news table fills up with article versions that no longer exist in their workspace and don't ever show up any where. Surely they should be removed from the table? It's not as if they can actually be restored (at least as far as I know) once they have been removed from the workspace. They are not maked as deleted or anything. There are in some kind of strange limbo world, they exist still in the table but no one can ever view them.