[mythtv-users] Cannot delete non-recorded/empty programs on 0.17

[Shaun Jackman]

On 4/21/05, Kevin Kuphal <kuphal at dls.net> wrote:
> You know the workaround.  Either upgrade to 0.18 which fixes this for
> recordings that are missing because of a system failure (filesize in the
> DB = 0), or touch the missing filename from the command-line to create a
> zero length file and then delete it using the GUI
> 
> Kevin

I'm waiting patiently for Debian packages of 0.18 to be released. In
the mean time, here's a couple handy scripts:

Cheers,
Shaun

$ cat mythls
#!/bin/sh
mysql -B -u mythtv --password=mythtv mythconverg -e \
        'select chanid, starttime, endtime from recorded' | \
tr -d ': -' | tr '\t' _ | tail -n +2 |
sed 's^.*^/var/lib/mythtv/&.nuv^'

$ cat mythmissing
#!/bin/sh
for i in `mythls`; do
        test -r $i || echo $i
done