+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Some tvshows show u twice in libray (/showthread.php?tid=270795)
Some tvshows show u twice in libray - jpcolin - 2016-04-22
Hi,
I search the forum but did not find an answer that fits my problem.
I have 2 Rpi2 with OE 6.0.3 with SQL on a synology.
Everything works fine, but for an unknow reason some episodes of some tv shows show up twice in my libray.
Both files can be played.
If i watch one the other one is marked as watched to!
Of course those file are only present 1 time on the hard disk.
any idea, no big deal but i like things to be clean ;-)
Thank you
RE: Some tvshows show u twice in libray - zerocool_ie - 2016-04-23
do you have different source paths set on the Rpi's?
Select each episode in a duplicate pair, go to the information screen and compare the path fields in each
RE: Some tvshows show u twice in libray - jpcolin - 2016-04-23
I just checked path is exactly the same.
Any idea?
Strange is that it is only some episodes and for different to shows
RE: Some tvshows show u twice in libray - zerocool_ie - 2016-04-23
are the cases in the paths identical also?
eg. SERVER vs server vs Server
Do you scan all your media to the library on one Rpi only, or from both?
RE: Some tvshows show u twice in libray - jpcolin - 2016-04-23
Case is identical.
I do have watchdog on both rpis
RE: Some tvshows show u twice in libray - zerocool_ie - 2016-04-24
Code:
select strTitle as 'Show', c12 as 'Season', c13 as 'Episode', strPath as 'Path', a.StrFileName as 'Filename'
from episode_view a
join ( select strFileName
from episode_view
group by strFileName
having count(*) > 1 ) b
on a.strFileName = b.strFileName
order by a.strFileName asc;you could run this SQL query against your library to identify the exact duplicates in the database (by filename).
The only results it returns me is for multi-episode files as it is 2 different episodes sharing the same video file
RE: Some tvshows show u twice in libray - jpcolin - 2016-04-25
I forgot to mention that there is a (1) after each episode name that is affected
RE: Some tvshows show u twice in libray - jpcolin - 2016-04-28
correction, there not Always a (1) in the name.
Nobody has an idea?
FYI, those are DVD rips with make MKV, single episodes, no double files, only 1 nfs share.
double files have excatly the same path.
both files play normaly.
RE: Some tvshows show u twice in libray - Redwingsfansfc - 2016-04-29
Running MySQL? Only on one front end do you need the source. The subsequent front ends rely only on advancedsettings.xml no mapped source.
Clear the sources, clean library. Should be good to go.