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

[Mark Perkins]

> On 21 Feb 2015, at 9:41 pm, "John Pilkington" <J.Pilk at tesco.net> wrote:
> 
>> On 21/02/15 10:44, Dave Pearson (Lists) wrote:
>>    -----Original message-----
>>    *From:*    Mike Perkins <mikep at randomtraveller.org.uk>
> 
>>    As I recall the way to get the video scan to work is to move the
>>    Video Storage
>>    Directory to a temporary empty directory and scan. This should reset
>>    the
>>    database info. Now move the directory back and rescan and it should
>>    pick up
>>    everything.
>> 
>>    --
>> 
>>    Mike Perkins
> 
>> Hi Mike,
>> 
>> It's a good suggestion, which I've just tried - renamed
>> /media/myth/video to /media/myth/video_old and created an empty
>> /media/myth/video, then ran a scan from the frontend on this new, empty,
>> folder and every video was removed except the troublesome, non-existant
>> videos, that DEFINITELY are not in the empty video folder.
>> 
>> It's really quit odd.
>> 
>> Regards,
>> 
>> Dave.
> 
> I believe the video directories can be defined either within mythtvsetup (for storage groups) or within the frontend setup screens.  Is there confusion here?  Might Mythweb be implicated too?
> 
> John
> 
> 
> _______________________________________________
> 

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;