Edit page displaying repeating relationships

[dleadbetter]

The /api/relationships endpoint looks to be returning the same relationship multiple times. Note: These records are not duplicated in the database.

In the screenshot below, only 2 relationships records exist in the database.

[dleadbetter]

@NickLaiacona - This appears to be happening because one of the related event records has duplicate end_date fuzzy date records. The fuzzy dates are stored as records in a separate table, but should only have one end_date record per event. When we query the related events for this document, we're joining the start/end fuzzy dates and the duplicates are causing the rows to be repeated.

As far as I can tell, this is the only record affected by this and I'm not sure how it happened. All of the end_date records were created on 11/10/24 at 20:07:51 (not sure if that date has any significance?). I've tried to reproduce the duplicate creation by modifying event records, merging event records, importing event records, but have not been successful.

I can certainly go into the database and remove the duplicates, but without any more information, I'm not sure I can determine what caused this.

[NickLaiacona]

Hmm, that date doesn't ring a bell, happy to get together and look at the data to determine next steps.