Some tvshows show u twice in libray
#1
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
Reply
#2
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
4x R-Pi4b LibreELEC v10 | Aeon Nox: SiLVO | Flirc cases
Storage Synology DS411 | 4 x WD RED 6TB
Software MariaDB 10.4.19 | Filebot | Ember Media Manager
wiki (wiki) | First time user (wiki) | Debug_Log (wiki) | mysql (wiki) | artwork (wiki)
Reply
#3
I just checked path is exactly the same.
Any idea?
Strange is that it is only some episodes and for different to shows
Reply
#4
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?
4x R-Pi4b LibreELEC v10 | Aeon Nox: SiLVO | Flirc cases
Storage Synology DS411 | 4 x WD RED 6TB
Software MariaDB 10.4.19 | Filebot | Ember Media Manager
wiki (wiki) | First time user (wiki) | Debug_Log (wiki) | mysql (wiki) | artwork (wiki)
Reply
#5
Case is identical.
I do have watchdog on both rpis
Reply
#6
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
4x R-Pi4b LibreELEC v10 | Aeon Nox: SiLVO | Flirc cases
Storage Synology DS411 | 4 x WD RED 6TB
Software MariaDB 10.4.19 | Filebot | Ember Media Manager
wiki (wiki) | First time user (wiki) | Debug_Log (wiki) | mysql (wiki) | artwork (wiki)
Reply
#7
I forgot to mention that there is a (1) after each episode name that is affected
Reply
#8
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.
Reply
#9
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.
I really have no idea what I am talking about. Proceed with caution. I confuse easily. And drink. A lot.
Reply

Logout Mark Read Team Forum Stats Members Help
Some tvshows show u twice in libray0