Automatically delete orphaned Episodes and Series. (1 Viewer)

HTPCSourcer

Retired Team Member
  • Premium Supporter
  • May 16, 2008
    11,418
    2,335
    Home Country
    Germany Germany
    The only time it would not remove a local reference is if the drive is offline, if its online and the files no longer exist on that drive then the references are removed.
    Can you explain what you mean by "online" vs "local reference"? For me I can confirm that deleting the physical file is not triggering the removal in the database. I continue to see this entries.
     

    ltfearme

    Community Plugin Dev
  • Premium Supporter
  • June 10, 2007
    6,751
    7,196
    Sydney
    Home Country
    Australia Australia
    If you delete a episode from your disk and then run an import (manual or by schedule) you will see that the reference is removed in the logs. In the database there is two tables for episodes (local_episodes and online_episodes), the local_episodes table is what gets cleaned up because that is what stores the file information.

    The log will look like:
    Code:
    2015-07-02 20:52:46.915 [INFO][04]: Episode is marked for removal from database, file: '\\nas\tv\House of Cards (US)\House.of.Cards.(US).S03E10.720p.WEBRip.DD5.1.x264-FGT.mkv', volume label: '\\nas\tv'
    2015-07-02 20:52:46.921 [INFO][04]: Episode is marked for removal from database, file: '\\nas\tv\House of Cards (US)\House.of.Cards.(US).S03E11.720p.WEBRip.DD5.1.x264-FGT.mkv', volume label: '\\nas\tv'
    2015-07-02 20:52:46.927 [INFO][04]: Episode is marked for removal from database, file: '\\nas\tv\House of Cards (US)\House.of.Cards.(US).S03E12.720p.WEBRip.DD5.1.x264-FGT.mkv', volume label: '\\nas\tv'
    2015-07-02 20:52:46.933 [INFO][04]: Episode is marked for removal from database, file: '\\nas\tv\House of Cards (US)\House.of.Cards.(US).S03E13.720p.WEBRip.DD5.1.x264-FGT.mkv', volume label: '\\nas\tv'
     

    HTPCSourcer

    Retired Team Member
  • Premium Supporter
  • May 16, 2008
    11,418
    2,335
    Home Country
    Germany Germany
    Hi,

    Thanks for the explanation. Indeed, works as described (y) - I probably was looking at the database status on my local work PC, where I had not updated, instead of assessing the individual HTPCs' situation.

    @octane : In summarizing one can therefore say that status updates will periodically occur (if defined in the settings under "Scan remote shares every xx minutes".
     

    RoChess

    Extension Developer
  • Premium Supporter
  • March 10, 2006
    4,434
    1,897
    @biship, you can also just run an SQL query manually to prune your database in one single swoop. There are many forum references to this that explain all the queries available. Ideally you do configure each show on the correct status though, because shows that are officially ended are ideally configured as such. I guess automating that would be a nice new feature for MP-TVSeries.
     

    Users who are viewing this thread

    Top Bottom