Error by copying a record with IRRE elements creates duplicated references by the original record
We have found a bug with one of our small product extension. The original problem was, that some user could not copy a product, because it showed an error, but after the error message and an unsuccessful copy, the IRRE records are doubled in the original record.
We made some experiment, and it seems to be a core bug.
How to reproduce it:
1) Create a simply Image CE with one image.
2) Go to the List Modul and copy this content element
3) Select the root page
4) Try to insert it -> it should show an error: "1: Attempt to insert record on page '[root-level]' (0) where this table, tt_content, is not allowed".
So far so good
5) Open the original Image CE and you have 2 reference instead of 1. And the second has pid = 0 in DB.
It seems, if an error occurs, the child records are not removed from the db, but somehow referenced to the original record, which you copied. This probably happens also by different errors, which blocks the copy process of the original record.
This way "how to reproduce it" is only an example, we have seen to happen with other errors also.
We tested this with 2 different extension and content elements on 2 different instances with 6.2.12 and on a third instance with the newest 7.2.
We have no workspaces.