Posts: 13
Joined: Oct 2008
Reputation:
0
Hi,
One of my series show duplicate entries for each episode in Library Mode.
How can I get rid of duplicates?
Thanks for your help.
Cheers,
Cesar/Brazil
Posts: 913
Joined: May 2007
Reputation:
3
I had the same thing recently using nfo files - which surprised me. It only did it with one show (even though I was messing with others).
I ended up turning on "Stack duplicate shows" in the gui and that hid them - although they are still present as doubles in the dB. JM made a comment in another thread about the possibility of a funky multi-path. As I recently upgraded to Beta1 from a version almost a year old (and still used my original dB) I'm sure there could be issues. I plan to rebuild the dB from scratch once the final release is in.
Hope this helps.
ZOTAC IONITX-D-E Intel Atom N330 Dual Core 1.6 GHz NVIDIA ION with LIVE on SSD (now updated to Nvidia Shield Pro (P2897)
Posts: 13
Joined: Oct 2008
Reputation:
0
Thanks for your suggestion. I tried playing with several options and eventually found an option to clean database and that took care of the duplicates.
Best regards
Posts: 26,215
Joined: Oct 2003
Reputation:
187
1. Go through the episodes table and the link tables that link to tvshows, and update those that link to tvshow id 21 to tvshow id 17. eg:
update tvshowlinkepisode set idShow=17 where idShow=21
2. Once done, remove the row from the tvshow table:
delete from tvshowlinkepisode where idShow=21
3. Remove the entry you've blanked out from the path table.
Cheers,
Jonathan
Posts: 5
Joined: Feb 2011
Reputation:
0
2011-05-27, 13:44
I had duplicates from importing exported libraries. I removed them with:
prefs / Video / Clean Library ...
Posts: 1
Joined: Aug 2011
Reputation:
0
Just a note of warning, I had the same duplicate issue and the clean library tool worked great to rid my library of duplicate entries, but I did lose all my watched show information. Less of a problem than the duplicates, though. You can't have everything...