Problem with RM8 adding a random name for unknown fathers

[TomH]

@TomH

There is a fix for the problem database using sqlite.

It’s one that others have encountered. I hypothesised the probable cause and demonstrated how to correct it last December. See the thread starting at

Unknown spouses - who wants them?

That got me thinking and reminded me that RM’s Delete Phantoms does not clean out orphaned records from all tables in the database. Given RM8’s propensity to freeze, crash, or throw an error, it’s possible that a process such as adding a person might not have finished properly. At minimum, 1 record needs to be added to each of the NameTable and the PersonTable. The latter’s PersonID must match the former’s OwnerID. If the NameTable record got added first, the OwnerID might be 0 initially awaiti…