11.1 Drop media creating multiple entries in multimedia table

I just noticed that, at least on mac, dropping the same media file multiple times is now creating multiple entries in the MultiMediaTable. It’s easy to test… drop media, add caption, drop media a second time to a different event or citation, etc. The caption is no longer pre-filled, indicating that it’s a new table entry.

For me, this change started on March 28, which is when I installed 11.1.1, but it could have been introduced with 11.1.0. On Mar 25 drop media was still working as expected - ie dropping the same media file multiple times only created 1 entry in the table.

Hoping someone can confirm that this is cross platform behavior and then we can request that this change be reverted to the pre-V11 mode of not creating duplicate table entries.

1 Like
I just noticed that, at least on mac, dropping the same media file multiple times is now creating multiple entries in the MultiMediaTable.

I will test this – I have test this since 7.9 (preview) and that was NOT the case.

1 Like

I tested this on W11 and latest version (11.1.1.0) – I also ran database tools after. No Duplicate files (Having MediaID Count >1)

So if it was not RM – its possible your database indexes were off or something to begin in.

My setup is Windows 11 and the Caption does still get pre-filled for each successive drop.

The MultimediaTable maintains only the single original MediaID and only the single Caption column entry exists to reflect any editing changes from original Caption to an updated one.

The MediaLink table does add a new LinkID for each drop, but preserves the same original MediaID for each.

1 Like

Thank you guys for checking this out. Good to hear that the problem seems to be in front of the keyboard [again]. Will test more on my end to see what’s going on.

1 Like

Well, unfortunately, the problem persists on mac. In a new empty db, dropping the same media image in 3 different places causes the media image to be added to the MultiMediaTable 3 times, each time with 1 tag. Have opened a ticket with support.

1 Like

sounds like it related to the caption. But I am confused DragNDrop does not let you do captions at same time (at least on Windows ver)

Aside from your difference in having (3) unique MediaID numbers in the MediaLink table, what also differs (versus mine) is that the OwnerID for all three of your OwnerType are identical, while mine are all different ,having linked to a Person (General) fact, a Person(General) citation and a Primary Name fact (all for the same individual).
Edited: Also the expected Caption variations.

Sorry for the confusion. I have ‘Slide in workflow’ enabled and with that option you are presented with the Edit Media pane when you close the ‘Drop New Media’ window. So its easy to add captions. I only added the caption to make it clear that each drop was a new entry. YAm guessing that you don’t use slide in workflow. (btw, you might like it!)

Your post got me thinking tho, so I tested with ‘Slide in workflow’ disabled and without adding captions… no joy… multiple drops still create multiple table entries.

1 Like

Yeah, that makes sense.. my post was about recreating the problem on a blank db with only 1 person in it.. dropped media to the Person, a birth event, and citation all for that 1 person… so the ownerID would be the same. I have since added to multiple people, with and without captions, etc.

I am struggling to get my head around why it’s behaving differently on windows… I thought for a second maybe the slide-in-workflow feature was the source of different code.. but no

Yeah, but what I’m saying is I have always been doing it for one person ONLY and the OwnerType and OwnerID are always uniquely different, depending on WHERE the Media is attached to within that one person.

Ah Sorry, was a little slow on that.. the MediaLinkTable.Owner ID value varies based on Owner type.. Because I was testing in a new, empty db… There was only 1 entry in the Person, Name, and Citation tables, so OwnerID = 1 for all the media links.

OwnerType OwnerID

0 (Person) PersonTable.PersonID

2 (Event) EventTable.EventID

4 (Citation) CitationTable.CitationID

7 (Name) NameTable.NameID

1 Like

Gotcha, one-person database!

1 Like

I’ve been able to reproduce it on the Mac with 11.1.1.0. Confirming its been reported to development.

2 Likes

that structure (Not only table) with Owner type can be confusing