2012-11-05, 18:19
I'm having this problem with the October snapshot too. The duplicates enter my library on subsequent scans, but not during the "same" scan. Here's one of the files directly from sqlite to illustrate the problem:
sqlite> select * from episode where c18 = 'nfs://192.168.1.9/home/garret/shares/videos/Anime/One Piece/Season 07/[K-F]_One_Piece_098_[BC713814].avi';
8678|9105|Here Come the Desert Pirates! The Men who Live Free|Nami and Vivi found themselves an easier way to travel in the desert and leave all men behind. While trying to catch up with them, Ace gets lost. Luffy and the rest of the gang find the Desert Pirates, and Vivi meets a figure from her past.||6.000000||2002-01-27|<thumb>http://www.thetvdb.com/banners/episodes/81797/362005.jpg</thumb>||||||7|7||-1|-1|-1|nfs://192.168.1.9/home/garret/shares/videos/Anime/One Piece/Season 07/[K-F]_One_Piece_098_[BC713814].avi|742|||||310
8765|9105|Here Come the Desert Pirates! The Men who Live Free|Nami and Vivi found themselves an easier way to travel in the desert and leave all men behind. While trying to catch up with them, Ace gets lost. Luffy and the rest of the gang find the Desert Pirates, and Vivi meets a figure from her past.||6.000000||2002-01-27|<thumb>http://www.thetvdb.com/banners/episodes/81797/362005.jpg</thumb>||||||7|7||-1|-1|-1|nfs://192.168.1.9/home/garret/shares/videos/Anime/One Piece/Season 07/[K-F]_One_Piece_098_[BC713814].avi|742|||||310
And then the file it's linked to:
9105|742|[K-F]_One_Piece_098_[BC713814].avi|1|2012-10-29 22:39:33|2012-10-25 22:39:35
And the path:
742|nfs://192.168.1.9/home/garret/shares/videos/Anime/One Piece/Season 07/|||||||||
Notice they even link to the same file. What's even more strange is it seems random, sometimes when scanning for new content it only adds actually new content. Other times, it'll duplicate files for an entire folder (such as a TV season) that had no new episodes/hadn't changed in a long time. This last time it added a TON of duplicates from multiple folders and I actually stopped it during scanning since it was duplicating so many.
I'm going to try with the November cycle that I see appears to be available, first with my current database, but afterwards I'll probably remove the database and build it from scratch at this point.
I do use the advanced alternate setting for DateAdded that returns it to the old behavior during content scanning, which I only changed a few weeks ago. The previous post made this occur to me. I have a rather large content library that I update frequently, so I'm not positive about which files entered my library when, but since I updated from stable to snapshots periodically, and eventually realized the DateAdded behavior changed, I went from the "old" scanning behavior to new, and then back to old once I found out it changed and how to change it back. Media added during that time would've had the new behavior "applied" to it. Perhaps this issue is ultimately related to that? Even though the file entries are exactly the same, it seems like it could be related.
This is the thread I'm referring to regarding DateAdded:
http://forum.xbmc.org/showthread.php?tid=127343
sqlite> select * from episode where c18 = 'nfs://192.168.1.9/home/garret/shares/videos/Anime/One Piece/Season 07/[K-F]_One_Piece_098_[BC713814].avi';
8678|9105|Here Come the Desert Pirates! The Men who Live Free|Nami and Vivi found themselves an easier way to travel in the desert and leave all men behind. While trying to catch up with them, Ace gets lost. Luffy and the rest of the gang find the Desert Pirates, and Vivi meets a figure from her past.||6.000000||2002-01-27|<thumb>http://www.thetvdb.com/banners/episodes/81797/362005.jpg</thumb>||||||7|7||-1|-1|-1|nfs://192.168.1.9/home/garret/shares/videos/Anime/One Piece/Season 07/[K-F]_One_Piece_098_[BC713814].avi|742|||||310
8765|9105|Here Come the Desert Pirates! The Men who Live Free|Nami and Vivi found themselves an easier way to travel in the desert and leave all men behind. While trying to catch up with them, Ace gets lost. Luffy and the rest of the gang find the Desert Pirates, and Vivi meets a figure from her past.||6.000000||2002-01-27|<thumb>http://www.thetvdb.com/banners/episodes/81797/362005.jpg</thumb>||||||7|7||-1|-1|-1|nfs://192.168.1.9/home/garret/shares/videos/Anime/One Piece/Season 07/[K-F]_One_Piece_098_[BC713814].avi|742|||||310
And then the file it's linked to:
9105|742|[K-F]_One_Piece_098_[BC713814].avi|1|2012-10-29 22:39:33|2012-10-25 22:39:35
And the path:
742|nfs://192.168.1.9/home/garret/shares/videos/Anime/One Piece/Season 07/|||||||||
Notice they even link to the same file. What's even more strange is it seems random, sometimes when scanning for new content it only adds actually new content. Other times, it'll duplicate files for an entire folder (such as a TV season) that had no new episodes/hadn't changed in a long time. This last time it added a TON of duplicates from multiple folders and I actually stopped it during scanning since it was duplicating so many.
I'm going to try with the November cycle that I see appears to be available, first with my current database, but afterwards I'll probably remove the database and build it from scratch at this point.
I do use the advanced alternate setting for DateAdded that returns it to the old behavior during content scanning, which I only changed a few weeks ago. The previous post made this occur to me. I have a rather large content library that I update frequently, so I'm not positive about which files entered my library when, but since I updated from stable to snapshots periodically, and eventually realized the DateAdded behavior changed, I went from the "old" scanning behavior to new, and then back to old once I found out it changed and how to change it back. Media added during that time would've had the new behavior "applied" to it. Perhaps this issue is ultimately related to that? Even though the file entries are exactly the same, it seems like it could be related.
This is the thread I'm referring to regarding DateAdded:
http://forum.xbmc.org/showthread.php?tid=127343