PlaceTable rows with PlaceType=0 and MasterID != 0

Quote from Richard Otter on 2025-08-19, 4:11 pmI was just checking referential integrity in my database and I noticed a significant number of rows (~250 out of 7500 rows) in the PlaceTable that have PlaceType = 0 but MasterID is non zero.
Do the non zero MasterIDs have any significance for PlaceType=0 rows, or are they just the result of previous bugs?
I don't see a pattern.Background- It's my understanding that PlaceType =0 indicates a primary place while PlaceType=2 indicates a place detail with its MasterID pointing to a primary place.
Richard
I was just checking referential integrity in my database and I noticed a significant number of rows (~250 out of 7500 rows) in the PlaceTable that have PlaceType = 0 but MasterID is non zero.
Do the non zero MasterIDs have any significance for PlaceType=0 rows, or are they just the result of previous bugs?
I don't see a pattern.
Background- It's my understanding that PlaceType =0 indicates a primary place while PlaceType=2 indicates a place detail with its MasterID pointing to a primary place.
Richard

Quote from Tom Holden on 2025-08-19, 4:59 pmYour understanding is correct and the MasterID is ignored by RM when PlaceType=0, afaik. In my scripts at Places – Conversion of Place Details to Places, the MasterID is prefixed by * when the PlaceType is updated from 2 to 0 by the convert script so that the revert script can do its job when run.
I'm unaware of what operation in RM might have left Place records with non-zero MasterIDs. Does Place Cleanup have a combine function?
Your understanding is correct and the MasterID is ignored by RM when PlaceType=0, afaik. In my scripts at Places – Conversion of Place Details to Places, the MasterID is prefixed by * when the PlaceType is updated from 2 to 0 by the convert script so that the revert script can do its job when run.
I'm unaware of what operation in RM might have left Place records with non-zero MasterIDs. Does Place Cleanup have a combine function?

Quote from kevync on 2025-08-20, 7:36 pmHmm interesting that is about 10% of rows (913)
I wonder if Spliting etc in RM UI might do that --I have a lot with 1600 Master ID let me do another query
Hmm interesting that is about 10% of rows (913)
I wonder if Spliting etc in RM UI might do that --I have a lot with 1600 Master ID let me do another query
Uploaded files: