[mythtv] Autoexpiring programs with no program information

[Chris Pinkham]

> 2006-01-18 19:25:48.791 ERROR retrieving program info when trying to delete
> program for chanid 15489 recorded at Wed Jan 18 19:00:26 2006. Recording
> will NOT be deleted.

This is saying that the delete code in mythbackend couldn't load the program
info for the recording from the recorded table.

> Now, I don't have guide information for many of my channels. Are these
> recordings being expired at some point or does mean these recordings will
> never get deleted?

Nothing to do with guide data, it should only look at the recorded table and
optionally the channel table.

What do you get when you run the following SQL?

SELECT recorded.chanid,starttime,endtime,title, 
        subtitle,description,channel.channum, 
        channel.callsign,channel.name,channel.commfree, 
        channel.outputfilters,seriesid,programid,filesize, 
        lastmodified,stars,previouslyshown,originalairdate, 
        hostname,recordid,transcoder,playgroup, 
        recorded.recpriority,progstart,progend,basename,recgroup 
    FROM recorded 
    LEFT JOIN channel ON recorded.chanid = channel.chanid 
    WHERE recorded.chanid = 15489
        AND starttime = 20060118190026;

If that returns nothing, how about this one:

SELECT chanid, starttime, title
    FROM recorded
    WHERE recorded.chanid = 15489
        AND starttime = 20060118190026;

-- 
Chris