[mythtv-users] Unable to Fully Delete a Recording

[Frank Lynch]

On 10/14/05, Alberto Alonso <sp-23856721 at ggsys.net> wrote:
> Recreate the files, you can do empty files for this. For example:
>
> touch /video/recordings/filename
>
> If you don't know the filename look at your backend logs when you
> use mythweb, it will show the files that it can't open.
>
> Then go ahead and delete them via mythweb.
>
> This should work.
>
> Alberto
>
> On Fri, 2005-10-14 at 14:05 -0400, Jon Kunze wrote:
> > I have 2 recordings on my Myth box that I can't seem to delete.
> >
> > When i try to delete them from the frontend, it sits for a few
> > seconds, and then continues to show the recording in the Recorded
> > Programs listing. I've looked in my /video/recordings directory and
> > the file is not there anymore, so obviously it was able to delete the
> > file, just not the database entry. I've tried deleting them through
> > MythWeb as well, and have had the same result.
> >
> > Is there any easy way to remove these recordings from the database as
> > well, without having to go through manually and delete every
> > occurrence of it through something like phpMyAdmin? I've tried the
> > mysqlcheck and it doesn't find any error with the database.
> >
> > Any help would be appreciated, as every time I select one of these
> > programs in the listings, it locks the frontend up for a few seconds.
> > _______________________________________________
>>
>

I just encountered this same issue. I had quite a number of files
missing, (as I had changed my storage location from /mnt/store to
/mnt/store/video). I decided to use grep and awk to scrape the log
file and automate the touching process. I though I'd share this for
the archives.

grep "File doesn't exist" mythbackend.log | awk '{ print $9 }' | awk
'{ print substr($0,0,50) }'  | xargs touch

You should note that my missing files were under /mnt/store/ , so you
will probably need to increase the value of the 3rd argument passed
into substr (currently set to 50). I'm using substr to remove the
period from the end of the filename - which is how it appears in the
log file.

cheers,
--Frank