[mythtv-users] Non-existant Videos in MythVideo Database

[Michael T. Dean]

On 02/21/2015 11:22 AM, Dave Pearson (Lists) wrote:
>
>     I think John's first guess is probably spot on! The video files
>     will be assigned to an old no-longer-exists host name and myth
>     will not clear out the info when the host is not present. Dave
>     will most likely need to fake the old host (as per the links) and
>     then scan to clear the ghost entries. May need to peek inside the
>     database to see what the old host was called, someone will
>     hopefully provide the correct MySQL statement but I'm thinking
>     something along the lines of select distinct host from
>     mythconverg.videometadata;
>
> Spot on Mike, I took a look in mythconverg.videometadata and there 
> were the spurious files, deleted them from the table and did a rescan 
> in MythFrontend and all is as it should be.
>

Actually, if you just deleted rows from videometadata, you left in other 
metadata about those videos, which is why you should have (should still, 
really) followed the instructions from John's original post that pertain 
to retiring an old backend.

Mike