TYPO3 Core

often a relation between records created by hand is missing as the creation of the record which should be the child is done in the normal creation way instead of the only(!) way to insert the relation.

two cases which occur and can't be fixed without recreation or DB 'messing' (like phpadmin):

1. translations: if you don't use the function to translate a record and create just a new record in another language than default it can't be connected to the default-language record. sometimes you loose the relation if you (accidentaly) change the language of a clean translated record
2. IRRE: no chance to insert a record into an IRRE parent if you want to join existing records into a (new) parent record