Nothing returns for either of these queries. What's odd is that the housekeeping thread queries recorded for recordings to expire/delete. If you're saying it has nothing to do with guide information that I have to wonder. The message hasn't come up since. I'll do some more checking.
Thanks, Mark. -----Original Message----- From: Chris Pinkham [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 18, 2006 8:32 PM To: mythtv-dev@mythtv.org Subject: Re: [mythtv] Autoexpiring programs with no program information > 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 _______________________________________________ mythtv-dev mailing list mythtv-dev@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev EMAIL DISCLAIMER Please Note: The information contained in this message may be privileged and confidential, protected from disclosure, and/or intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying or other dissemination of this communication is strictly prohibited. If you received this communication in error, please immediately reply to the sender, delete the message and destroy all copies of it. Thank You _______________________________________________ mythtv-dev mailing list mythtv-dev@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
