[mythtv-users] Which table?

Michael Sullivan michael at espersunited.com
Sun Sep 21 17:46:05 UTC 2008


On Sun, 2008-09-21 at 18:36 +0100, Robert wrote:
> Owen Townend wrote:
> > 2008/9/22 Michael Sullivan <michael at espersunited.com>:
> >> On Mon, 2008-09-22 at 02:50 +1000, Owen Townend wrote:
> >>> 2008/9/22 Michael Sullivan <michael at espersunited.com>:
> >>> >From working on the script I see that my logic is flawed; all programs
> >>>> appear in the program table; only those that are manually marked not to
> >>>> record are in the record table.  So where are the programs set to record
> >>>> listed?
> >>> Looking through phpmyadmin it seems like you're looing at it the wrong
> >>> way around.
> >>> The record table should be showing your recording schedules, it is for
> >>> me, but you're not looking at the right fields.
> >>>
> >>> Startdate looks to line up with when I originally set up each
> >>> recording schedule, rather than the startdate for an upcoming
> >>> recording.  None of those dates are in the future for me.  Instead,
> >>> there is the next_record field which show the info you're after.  The
> >>> date is zeroed if no showing is found to be recorded or otherwise
> >>> gives the date and time of the next recording.
> >>>
> >>> Try something more like this:
> >>> SELECT title, next_record FROM `record` WHERE next_record LIKE '2008-09-22%'
> >>>
> >>> cheers,
> >>> Owen.
> >> mysql> SELECT title, next_record FROM `record` WHERE next_record LIKE
> >> '2008-09-22%'
> >>    -> ;
> >> Empty set (0.00 sec)
> >>
> >> I was curious as to what the output format would be like, so I pulled
> >> all next_records.  It wasn't that hepful:
> >>
> >> mysql> select next_record from record;
> >> +---------------------+
> >> | next_record         |
> >> +---------------------+
> >> | 0000-00-00 00:00:00 |
> >> | 0000-00-00 00:00:00 |
> > [snip]
> > 
> > Odd, for me these line up exactly with my upcoming recordings.  Each
> > entry matches to a schedule, each schedule shows a last_record and
> > next_record which lines up with the previous and next recordings (or
> > zero).
> > 
> > mysql> select next_record from `record`;
> > next_record
> > 0000-00-00 00:00:00
> > 2008-09-22 22:25:00
> > 0000-00-00 00:00:00
> > 2008-09-22 18:55:00
> > 0000-00-00 00:00:00
> > 2008-09-25 20:25:00
> > 2008-09-25 21:25:00
> > 2008-09-24 23:00:00
> > 2008-09-23 21:25:00
> > 0000-00-00 00:00:00
> > 0000-00-00 00:00:00
> > 2008-09-24 20:25:00
> > 0000-00-00 00:00:00
> > 0000-00-00 00:00:00
> > 
> > Can anyone else confirm?
> 
> I can.
> 
> SELECT title, next_record
> FROM record
> WHERE next_record > now()
> ORDER BY `record`.`next_record` ASC
> 
> Top Gear  			2008-09-21 19:00:00
> Tess of the D'Urbervilles 	2008-09-21 21:00:00
> Back to You 			2008-09-21 23:25:00
> How Not To Live Your Life 	2008-09-22 00:45:00
> Scrubs 				2008-09-22 12:45:00
> Hollyoaks 			2008-09-22 18:30:00
> ...
> 
> I guess the scheduler must fill in this column - maybe Michael needs to 
> force a scheduling run or something?  I seem to recall an option you can 
> pass into mythbackend to do something like this??
> 
> Robert.

My previous reply to this thread hasn't come back yet.  I checked man
mythbackend for this option, but there is no man page for mythbackend...



More information about the mythtv-users mailing list