Odd issue when using Find Missing Media tool

RootsMagic
,
21

I think that was 80% more me than you but no worries.

22

Here is the patch fix to remove Duplicate Media when one had media links and the other does not – I am sharing link to other site – this involves fix using sqlite and deleting so not posting that part here

RM Patch Sqlite Fix

below will find when you have the same computer media item (path/filename)
with two or more MediaIDs

    //find if what duplicates media

    SELECT Count(MediaID), Group_ConCat(MediaID), MediaFile, MediaPath FROM "MultimediaTable"
    Group By MediaFile, MediaPath
    Having Count(MediaID) > 1
    ORDER BY MediaFile, MediaPath

RM seems to be designed to allow this in most recent versions starting with RM8.

Drag N Drop does not create the duplicates – however manually adding files by other methods within the RM UI can cause this to occur and now apparently the MEDIA Fix tool might cause it (even if in isolated scenario)

Kevin