<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<meta name="Generator" content="Zarafa WebAccess v7.1.9-44333">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>RE: [mythtv-users] Non-existant Videos in MythVideo Database</title>
<style type="text/css">
body
{
font-family: Arial, Verdana, Sans-Serif ! important;
font-size: 12px;
padding: 5px 5px 5px 5px;
margin: 0px;
border-style: none;
background-color: #ffffff;
}
p, ul, li
{
margin-top: 0px;
margin-bottom: 0px;
}
</style>
</head>
<body>
<blockquote style="border-left: 2px solid #325FBA; padding-left: 5px;margin-left:5px;">-----Original message-----<br /><strong>From:</strong> Mark Perkins <perkins1724@hotmail.com><br /><strong>Sent:</strong> Sat 21-02-2015 13:23<br /><strong>Subject:</strong> Re: [mythtv-users] Non-existant Videos in MythVideo Database<br /><strong>To:</strong> Discussion about MythTV <mythtv-users@mythtv.org>; <br /><br /><br />> On 21 Feb 2015, at 9:41 pm, "John Pilkington" <J.Pilk@tesco.net> wrote:<br />> <br />>> On 21/02/15 10:44, Dave Pearson (Lists) wrote:<br />>> -----Original message-----<br />>> *From:* Mike Perkins <mikep@randomtraveller.org.uk><br />> <br />>> As I recall the way to get the video scan to work is to move the<br />>> Video Storage<br />>> Directory to a temporary empty directory and scan. This should reset<br />>> the<br />>> database info. Now move the directory back and rescan and it should<br />>> pick up<br />>> everything.<br />>> <br />>> --<br />>> <br />>> Mike Perkins<br />> <br />>> Hi Mike,<br />>> <br />>> It's a good suggestion, which I've just tried - renamed<br />>> /media/myth/video to /media/myth/video_old and created an empty<br />>> /media/myth/video, then ran a scan from the frontend on this new, empty,<br />>> folder and every video was removed except the troublesome, non-existant<br />>> videos, that DEFINITELY are not in the empty video folder.<br />>> <br />>> It's really quit odd.<br />>> <br />>> Regards,<br />>> <br />>> Dave.<br />> <br />> 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?<br />> <br />> John<br />> <br />> <br />> _______________________________________________<br />> <br /><br />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;<br />_______________________________________________<br />mythtv-users mailing list<br />mythtv-users@mythtv.org<br />http://lists.mythtv.org/mailman/listinfo/mythtv-users<br />http://wiki.mythtv.org/Mailing_List_etiquette<br />MythTV Forums: https://forum.mythtv.org<br /></blockquote><p>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.</p><p> </p><p>Thanks to you and John for your help.</p><p> </p><p>Now on to the next issue that I've created for myself :-(</p><p> </p><p>Regards,</p><p>Dave.<br /> </p>
<img src="http://mandrillapp.com/track/open.php?u=15101611&id=5ed5ad4b580b4b65839f25652d4018d1" height="1" width="1"></body>
</html>