[mythtv-users] Deleting metadata from MySQL

Kevin Kuphal kuphal at dls.net
Tue Apr 26 04:58:08 UTC 2005


Mark Knecht wrote:

>Hi,
>   I started by looking here:
>
>http://www.mythtv.org/docs/mythtv-HOWTO.html
>
>but did not find even a clue to this question. When I was first
>setting up MythTV over the weekend I was recording the wrong input on
>the PVR-250. I got some very large files. Not understanding much about
>the program I just went ahead and deleted the files. Now I find that
>the MySQL database still contains references to these programs. When I
>try to delete the program the database will not remove it because it
>cannot find the file.
>
>How does one clean up after a problem like this? I imagine that if you
>had a hard drive failure and lost a bunch of recordings that the
>problem would be similar.
>
>In the log I'm seeing a line like this:
>
>2005-04-25 21:44:27.718 ERROR when trying to delete file:
>/TVstorage/1009_20050423120800_20050423121600.nuv. File doesn't exist.
> Database metadata will not be removed.
>  
>
 From a shell, execute:

"touch /TVstorage/1009_20050423120800_20050423121600.nuv"

which will create a zero byte file.  Then delete from the GUI.

Kevin


More information about the mythtv-users mailing list