[mythtv-users] Which table?

[Michael Sullivan]

On Sun, 2008-09-21 at 20:01 +0100, Robert wrote:
> Michael Sullivan wrote:
> > On Sun, 2008-09-21 at 12:53 -0500, Michael Sullivan wrote:
> >> On Sun, 2008-09-21 at 19:47 +0200, Jan Ceuleers wrote:
> >>> Michael Sullivan wrote:
> >>>> mysql> SELECT title, next_record
> >>>>     -> FROM record
> >>>>     -> WHERE next_record > now()
> >>>>     -> ORDER BY `record`.`next_record` ASC
> >>>>     -> ;
> >>>> Empty set (0.00 sec)
> >>>>
> >>>> I'll look at man mythbackend for a force scheduling option
> >>> I can think of two things that could cause the above:
> >>>
> >>> 1. You're looking at the wrong database (e.g. not on the master backend)
> >>>
> >>> 2. You haven't scheduled any recordings
> >>>
> >>> HTH, Jan
> >> I'm looking at mythconverg on the only machine I have with a TV card and
> >> mythbackend.  Mythbackend is indeed running:
> >>
> >> michael at camille OldStuff $ ps ax | grep mythbackend
> >> 14855 ?        Sl     5:45 mythbackend
> >> 25902 pts/3    R+     0:00 grep --colour=auto mythbackend
> >>
> >>
> >> And I have several recording scheduled:
> >>
> >> >From http://127.0.0.1:6544/xml
> >>
> >>
> >>  
> >>   
> >>  
> >>
> >>   Sarah and Derek are put to the test after Cromartie kidnaps Charley's
> >> wife; John is in a sticky situation of his own when he finds himself
> >> caught between Cameron and Riley.
> >>    
> >>   
> >>   
> >>    
> >>   
> >>   
> >>    
> >>   
> >>   
> >>    
> >>   
> >>   Aided by Tinker Bell (Julia Roberts), a corporate lawyer (Robin
> >> Williams) turns into Peter Pan to rescue his children from Captain Hook
> >> (Dustin Hoffman).
> >>    
> >>   
> >>   
> >>    
> >>   
> >>   Awaking from a coma, an assassin (Uma Thurman) seeks vengeance against
> >> her former boss and his ruthless gang (Lucy Liu, Vivica A. Fox).
> >>    
> >>   
> >>   Brian tries to take it slow when he meets the girl of his dreams, but
> >> when Cleveland sweeps her off her feet, Brian vows to do whatever it
> >> takes to win her back.
> >>    
> >>   
> >>   
> >>    
> >>   
> >>  
> >>
> >>
> >>   
> >>   
> >>   Your subscription expires on 06/20/09 15:37:25
> >>  
> >>
> >>
> >> I guess xml doesn't copy correctly, but the top episode description on
> >> the list has airdate=2008-09-22
> >>
> > 
> > Should I downgrade to 0.20 if I can?  Would that help?  I apologize for
> > not replying directly to the post that said the problem was my version.
> > I keep going between my desktop and my laptop and I just found out that
> > messages I send from the laptop don't go through because of some
> > config /security issue in my mail server.  I'd already deleted the email
> > that said that I needed to find someone with 0.20 installed.  I'm a
> > little confused as to why this would help, as I have 0.21 installed, but
> > at this point I'm not in a significantly-educated position to dispute
> > it...
> 
> Well I'm confused!
> 
> Your other post said:
> 
>  > michael at camille OldStuff $ sudo emerge -pv mythtv
>  > >
>  > > These are the packages that would be merged, in order:
>  > >
>  > > Calculating dependencies... done!
>  > > [ebuild   R   ] media-tv/mythtv-0.20.2_p15634  USE="alsa debug* dvb dvd
>  > > ivtv jack joystick lirc mmx opengl perl vorbis (-altivec) -autostart
>  > > -backendonly -crciprec -dbox2 -directv -dts -freebox -frontendonly
>  > > -hdhomerun -ieee1394 -lcd -xvmc" VIDEO_CARDS="i810 via -nvidia" 0 kB
>  > >
>  > > Total: 1 package (1 reinstall), Size of downloads: 0 kB
>  > >
>  > > What version are you guys using?
> 
> 
> That reads as you are running mythtv 0.20.2 to me.  I'm running 
> "media-tv/mythtv-0.21_p17722" (0.21)
> 
> So _maybe_ and this is just a guess, those fields in that table are not 
> used in 0.20 (your version) and of the two people who have also run the 
> query (me and Owen) at least one of us is running a different version of 
> Myth (me, 0.21) and probably Owen is running 0.21 as well?
> 
> So to work if they query is wrong for 0.20 you really need someone else 
> with the same version as you (0.20) to run that query and see if it 
> returns similar results.
> 
> Robert.
I was wrong.  It is 0.20.2.  For some reason I looked at it and saw
0.21.2.  Not going on much sleep.  My wife worked night shift the last
two nights...