[mythtv-users] Where did this recording come from?

[jedi]

On Thu, Oct 23, 2008 at 02:56:37PM -0500, jedi wrote:
> On Thu, Oct 23, 2008 at 12:43:06PM -0700, Brad DerManouelian wrote:
> > On Oct 23, 2008, at 12:34 PM, Jeff Simpson wrote:
> > 
> > > Question for all you Myth-experts out there: How do you determine from
> > > a recording how it was scheduled?
> 
>      select b.title,a.title,a.subtitle  (correction)
>      from recorded a,record b 
>      where a.recordid=b.recordid
>      and a.title like '%something%';

or if you deleted it already...


>      select b.title,a.title,a.subtitle  (correction)
>      from oldrecorded a,record b 
>      where a.recordid=b.recordid
>      and a.title like '%something%';


> 
> 
> > >
> > > I just found that my Mythbox recorded a program at 10:30am today that
> > > I've never heard of. Looking at the title and description, I can't see
> > > how any of my recording schedules picked it up. Is there something I
> > > can look at in the database or logs that can tell me how or why it got
> > > scheduled to record? I couldn't see anything obvious in the log files,
> > > the database logs, or on the mythweb interface. I have daily database
> > > backups that I could pour over as well, but I don't know if I'm THAT
> > > curious to expose the poltergeists in my PC that really wanted to
> > > watch "Whacked out Sports" on Spike.
> > 
> > I think you can find what you're looking for in Previously Recorded  
> > Programs.
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users