- November 14, 2006
- 79
- 2
- 42
- Home Country
- United Kingdom
I don't know if anyone else wants this but I get the problem with duplicate entrys every time I move some files around or when I change a drive letter. I get around this by running the following SQL
It deletes from the Local_Episodes table which only contains information on the local files so all watches info is kept intact. And it only deletes files that are duplicated. So if there are 2 or 3 duplicates of an episode it will delete them all.
Then when you rescan (ether though the config program or just in the background in mp) it will only add the current and correct file info.
As it only deletes the files that are duplicated it shouldn't take long to get the media info again unless you moved all your files in one go or change a drive letter like I did 3000 files... Mind you that didn't take that long maybe 10-20mins in the config program.
Hope this helps.
If you don't know what SQL is or how to use it I surgest you don't try it as you could delete all your media portal data including your watched flags etc...
Regards,
Zas
DELETE FROM Local_episodes
WHERE CompositeID IN (
SELECT DISTINCT LE1.CompositeID
FROM local_episodes as LE1
, local_episodes as LE2
WHERE LE1.CompositeID = LE2.CompositeID
AND LE1.EpisodeFilename <> LE2.EpisodeFilename
ORDER BY LE1.CompositeID
)
It deletes from the Local_Episodes table which only contains information on the local files so all watches info is kept intact. And it only deletes files that are duplicated. So if there are 2 or 3 duplicates of an episode it will delete them all.
Then when you rescan (ether though the config program or just in the background in mp) it will only add the current and correct file info.
As it only deletes the files that are duplicated it shouldn't take long to get the media info again unless you moved all your files in one go or change a drive letter like I did 3000 files... Mind you that didn't take that long maybe 10-20mins in the config program.
Hope this helps.
If you don't know what SQL is or how to use it I surgest you don't try it as you could delete all your media portal data including your watched flags etc...
Regards,
Zas