[mythtv-users] Which table?
Michael Sullivan
michael at espersunited.com
Sun Sep 21 18:00:15 UTC 2008
On Sun, 2008-09-21 at 18:52 +0100, Robert wrote:
> Michael Sullivan wrote:
> > 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...
>
> robert at quad ~ $ mythbackend --help
> Valid options are:
> -h or --help List valid command line parameters
> -l or --logfile filename Writes STDERR and STDOUT messages to filename
> -p or --pidfile filename Write PID of mythbackend to filename
> -d or --daemon Runs mythbackend as a daemon
> -v or --verbose debug-level Use '-v help' for level info
> --printexpire List of auto-expire programs
> --printsched Upcoming scheduled programs
> --testsched Test run scheduler (ignore existing schedule)
> --resched Force the scheduler to update
> --nosched Do not perform any scheduling
> --noupnp Do not enable the UPNP server
> --nojobqueue Do not start the JobQueue
> --nohousekeeper Do not start the Housekeeper
> --noautoexpire Do not start the AutoExpire thread
> --clearcache Clear the settings cache on all myth servers
> --version Version information
> --generate-preview Generate a preview image
> --upnprebuild Force an update of UPNP media
> --infile Input file for preview generation
> --outfile Optional output file for preview generation
> --chanid Channel ID for preview generation
> --starttime Recording start time for preview generation
>
> Maybe try --printsched to see what it thinks is coming up and then maybe
> --resched to see if it updates that table.
>
> The only other thing I can think of is that whatever version of mythtv
> you are running doesn't use that column!
>
> Robert.
michael at camille OldStuff $ sudo mythbackend --printsched
2008-09-21 12:54:54.442 Using runtime prefix = /usr
2008-09-21 12:54:54.529 New DB connection, total: 1
2008-09-21 12:54:54.535 Connected to database 'mythconverg' at host:
localhost
2008-09-21 12:54:54.539 Current Schema Version: 1160
2008-09-21 12:54:54.587 New DB DataDirect connection
2008-09-21 12:54:54.588 Connected to database 'mythconverg' at host:
localhost
2008-09-21 12:54:54.695 Connecting to backend server: 192.168.1.2:6543
(try 1 of 5)
2008-09-21 12:54:54.697 Using protocol version 31
Retrieving Schedule from Master backend.
--- print list start ---
Title - Subtitle Chan ChID Day Start End C I T N
Pri
Stepmom 48 1047 21 13:00-15:30 0 0 O X
99/0
The Suite Life of Zack & Cody - "Cr 53 1052 21 13:00-13:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Ro 53 1052 21 13:30-14:00 0 0 C P
99/0
The Suite Life of Zack & Cody - "Ro 53 1052 21 16:00-16:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Fo 53 1052 21 16:30-17:00 0 0 C P
99/0
The Suite Life of Zack & Cody - "A 53 1052 21 18:00-18:30 0 0 C P
99/0
Family Guy - "Blue Harvest, Parts 1 9 1008 21 20:00-21:00 0 0 A P
99/0
Family Guy - "Lethal Weapons" 54 1053 21 21:00-21:30 0 0 A P
99/0
The Suite Life of Zack & Cody - "Mr 53 1052 21 21:40-22:05 0 0 C R
99/0
Family Guy - "Prick Up Your Ears" 54 1053 21 22:00-22:30 0 0 A P
99/0
The Suite Life of Zack & Cody - "A 53 1052 21 22:05-22:30 0 0 C P
99/0
Family Guy - "Lethal Weapons" 54 1053 22 00:30-01:00 0 0 A P
99/0
Family Guy - "Prick Up Your Ears" 54 1053 22 01:30-02:00 0 0 A P
99/0
Dave the Barbarian - "The Maddening 53 1052 22 03:00-03:30 0 0 C P
99/0
The Poseidon Adventure 37 1036 22 03:30-06:00 0 0 O X
99/0
A Haunting - "The Calling" 35 1034 22 12:00-13:00 0 0 A P
99/0
The Suite Life of Zack & Cody - "Bo 53 1052 22 12:40-13:05 0 0 C P
99/0
A Haunting - "Ghost Hunter" 35 1034 22 13:00-14:00 0 0 A P
99/0
The Suite Life of Zack & Cody - "Co 53 1052 22 13:05-13:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Gr 53 1052 22 13:30-14:00 0 0 C P
99/0
The Suite Life of Zack & Cody - "Le 53 1052 22 17:00-17:30 0 0 C R
99/0
The Suite Life of Zack & Cody - "Ti 53 1052 22 17:30-18:00 0 0 C P
99/0
The Suite Life of Zack & Cody - "Mr 53 1052 22 18:00-18:30 0 0 C R
99/0
Family Guy - "Hell Comes to Quahog" 4 1003 22 19:00-19:30 0 0 A P
99/0
Terminator: The Sarah Connor Chroni 9 1008 22 19:00-20:00 1 1 C 1
99/0
The Last Samurai 37 1036 22 19:00-22:15 0 0 O X
99/0
Family Guy - "Lethal Weapons" 4 1003 22 19:30-20:00 0 0 A P
99/0
Family Guy - "Blue Harvest, Parts 1 4 1003 22 20:00-21:00 0 0 A P
99/0
Paranormal State - "Haunted Ranch" 34 1033 22 21:00-21:30 0 0 O X
99/0
Paranormal State - "The Ladder" 34 1033 22 21:30-22:00 0 0 O X
99/0
Life With Derek - "Show-Off-Tune" 53 1052 22 21:30-22:00 0 0 C P
99/0
Family Guy - "Brian the Bachelor" 9 1008 22 22:00-22:30 0 0 A P
99/0
Paranormal State - "The Name" 34 1033 22 22:00-22:30 0 0 O X
99/0
The Suite Life of Zack & Cody - "Mr 53 1052 22 22:00-22:30 0 0 C R
99/0
Family Guy - "Brian: Portrait of a 54 1053 22 22:00-22:30 0 0 A P
99/0
Family Guy - "Dammit Janet" 9 1008 22 22:30-23:00 0 0 A P
99/0
Paranormal State - "The Devil in Sy 34 1033 22 22:30-23:00 0 0 O X
99/0
Family Guy - "Peter, Peter, Caviar 54 1053 22 22:30-23:00 0 0 A P
99/0
Psych - "Ghosts" 28 1027 22 23:07-00:07 0 0 A P
99/0
Paranormal State - "Haunted Ranch" 34 1033 23 01:00-01:30 0 0 O X
99/0
Paranormal State - "The Ladder" 34 1033 23 01:30-02:00 0 0 O X
99/0
Family Guy - "Brian: Portrait of a 54 1053 23 01:30-02:00 0 0 A P
99/0
Paranormal State - "The Name" 34 1033 23 02:00-02:30 0 0 O X
99/0
Family Guy - "Peter, Peter, Caviar 54 1053 23 02:00-02:30 0 0 A P
99/0
Paranormal State - "The Devil in Sy 34 1033 23 02:30-03:00 0 0 O X
99/0
A Haunting - "Spirits of the Dead" 35 1034 23 12:00-13:00 0 0 A P
99/0
The Suite Life of Zack & Cody - "Ho 53 1052 23 12:30-13:00 0 0 C P
99/0
A Haunting - "Stalked by Evil" 35 1034 23 13:00-14:00 0 0 A P
99/0
The Suite Life of Zack & Cody - "Ma 53 1052 23 13:00-13:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Th 53 1052 23 13:30-14:00 0 0 C P
99/0
Life With Derek - "Derek Denies Den 53 1052 23 14:00-14:30 1 1 C 1
99/0
Life With Derek - "Don't Take a Tip 53 1052 23 14:30-15:00 0 0 C P
99/0
The Suite Life of Zack & Cody - "Do 53 1052 23 18:00-18:30 0 0 C R
99/0
Family Guy - "And the Wiener Is ... 4 1003 23 19:00-19:30 0 0 A P
99/0
Eureka - "Here Come the Suns" 51 1050 23 19:00-20:00 0 0 A R
100/0
Family Guy - "Road to Europe" 4 1003 23 19:30-20:00 0 0 A P
99/0
Family Guy - "Fore Father" 4 1003 23 20:00-20:30 0 0 A P
99/0
Ancient Discoveries - "Siege of Tro 50 1049 23 20:00-21:00 0 0 C P
99/0
Eureka - "From Fear to Eternity" 51 1050 23 20:00-21:00 1 1 A 1
100/0
Family Guy - "Bill and Peter's Bogu 4 1003 23 20:30-21:00 0 0 A P
99/0
Life With Derek - "Derek Denies Den 53 1052 23 21:30-22:00 0 0 C E
99/0
Family Guy - "8 Simple Rules for Bu 9 1008 23 22:00-22:30 0 0 A P
99/0
The Suite Life of Zack & Cody - "Do 53 1052 23 22:00-22:30 0 0 C R
99/0
Family Guy - "Running Mates" 54 1053 23 22:00-22:30 0 0 A P
99/0
Family Guy - "He's Too Sexy for His 9 1008 23 22:30-23:00 0 0 A P
99/0
Family Guy - "There's Something Abo 54 1053 23 22:30-23:00 0 0 A P
99/0
Eureka - "From Fear to Eternity" 51 1050 23 23:00-00:00 0 0 A E
100/0
Ancient Discoveries - "Siege of Tro 50 1049 24 00:00-01:00 0 0 C P
99/0
Family Guy - "Running Mates" 54 1053 24 01:30-02:00 0 0 A P
99/0
Family Guy - "There's Something Abo 54 1053 24 02:00-02:30 0 0 A P
99/0
A Haunting - "Where Evil Lurks" 35 1034 24 12:00-13:00 0 0 A P
99/0
The Suite Life of Zack & Cody - "Fo 53 1052 24 12:35-13:00 0 0 C P
99/0
A Haunting - "Legend Trippers" 35 1034 24 13:00-14:00 0 0 A P
99/0
The Suite Life of Zack & Cody - "Th 53 1052 24 13:00-13:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Ho 53 1052 24 13:30-14:00 0 0 C P
99/0
The Last Samurai 37 1036 24 15:45-19:00 0 0 O X
99/0
The Suite Life of Zack & Cody - "To 53 1052 24 16:00-16:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Th 53 1052 24 16:30-17:00 0 0 C P
99/0
The Suite Life of Zack & Cody - "Li 53 1052 24 18:00-18:30 0 0 C P
99/0
The Karate Kid 37 1036 24 19:00-21:30 0 0 O X
99/0
MonsterQuest - "China's Wildman" 50 1049 24 19:00-20:00 0 0 O X
99/0
MonsterQuest - "Giant Bear Attack" 50 1049 24 20:00-21:00 0 0 O X
99/0
Life With Derek - "The Bully Brothe 53 1052 24 21:30-22:00 0 0 C P
99/0
Family Guy - "Breaking Out Is Hard 9 1008 24 22:00-22:30 0 0 A P
99/0
The Suite Life of Zack & Cody - "Li 53 1052 24 22:00-22:30 0 0 C P
99/0
Family Guy - "Holy Crap" 54 1053 24 22:00-22:30 0 0 A P
99/0
Family Guy - "Mr. Griffin Goes to W 9 1008 24 22:30-23:00 0 0 A P
99/0
Family Guy - "If I'm Dyin' I'm Lyin 54 1053 24 22:30-23:00 0 0 A P
99/0
MonsterQuest - "China's Wildman" 50 1049 24 23:00-00:00 0 0 O X
99/0
The Karate Kid 37 1036 25 00:00-02:30 0 0 O X
99/0
MonsterQuest - "Giant Bear Attack" 50 1049 25 00:00-01:00 0 0 O X
99/0
In Plain Sight - "High Priced Sprea 28 1027 25 00:03-01:05 0 0 C P
99/0
Family Guy - "Holy Crap" 54 1053 25 01:30-02:00 0 0 A P
99/0
Family Guy - "If I'm Dyin' I'm Lyin 54 1053 25 02:00-02:30 0 0 A P
99/0
The Karate Kid 37 1036 25 09:00-11:30 0 0 O X
99/0
A Haunting - "Spellbound" 35 1034 25 12:00-13:00 0 0 A P
99/0
The Suite Life of Zack & Cody - "Po 53 1052 25 12:40-13:05 0 0 C P
99/0
A Haunting - "Echoes of the Past" 35 1034 25 13:00-14:00 0 0 A P
99/0
The Suite Life of Zack & Cody - "A 53 1052 25 13:05-13:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Ba 53 1052 25 13:30-14:00 0 0 C P
99/0
The Suite Life of Zack & Cody - "Te 53 1052 25 18:00-18:30 0 0 C P
99/0
Life With Derek - "Slacker Mom" 53 1052 25 21:30-22:00 0 0 C P
99/0
Family Guy - "Model Misbehavior" 9 1008 25 22:00-22:30 0 0 A P
99/0
The Suite Life of Zack & Cody - "Te 53 1052 25 22:00-22:30 0 0 C P
99/0
Family Guy - "Love Thy Trophy" 54 1053 25 22:00-22:30 0 0 A P
99/0
Family Guy - "Road to Rhode Island" 9 1008 25 22:30-23:00 0 0 A P
99/0
Family Guy - "Death Is a Bitch" 54 1053 25 22:30-23:00 0 0 A P
99/0
Matchstick Men 37 1036 25 23:00-01:30 0 0 O X
99/0
The 6th Day 38 1037 25 23:00-01:00 0 0 O X
98/0
Family Guy - "Love Thy Trophy" 54 1053 26 01:30-02:00 0 0 A P
99/0
Family Guy - "Death Is a Bitch" 54 1053 26 02:00-02:30 0 0 A P
99/0
The Poseidon Adventure 37 1036 26 05:00-07:30 0 0 O X
99/0
Matchstick Men 37 1036 26 11:00-13:30 0 0 O X
99/0
A Haunting in Georgia 35 1034 26 12:00-13:00 0 0 A P
99/0
A Haunting in Georgia 35 1034 26 13:00-14:00 0 0 A P
99/0
The Suite Life of Zack & Cody - "Su 53 1052 26 13:00-13:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Sl 53 1052 26 13:30-14:00 0 0 C P
99/0
The Suite Life of Zack & Cody - "Of 53 1052 26 14:00-14:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Ar 53 1052 26 14:30-15:00 0 0 C P
99/0
The Suite Life of Zack & Cody - "A 53 1052 26 15:00-15:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Ti 53 1052 26 15:30-16:00 0 0 C P
99/0
The Suite Life of Zack & Cody - "Fo 53 1052 26 16:00-16:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Ro 53 1052 26 16:30-17:00 0 0 C P
99/0
The Suite Life of Zack & Cody - "Be 53 1052 26 17:00-17:30 0 0 C R
99/0
The Suite Life of Zack & Cody - "Do 53 1052 26 17:30-18:00 0 0 C R
99/0
The Suite Life of Zack & Cody - "Le 53 1052 26 18:00-18:30 0 0 C R
99/0
The Suite Life of Zack & Cody - "Mr 53 1052 26 18:30-19:00 0 0 C R
99/0
Family Guy - "Screwed the Pooch" 4 1003 26 19:00-19:30 0 0 A P
99/0
The Suite Life on Deck - "The Suite 53 1052 26 19:00-19:30 1 1 C 1
99/0
Family Guy - "Perfect Castaway" 4 1003 26 19:30-20:00 0 0 A P
99/0
The Suite Life of Zack & Cody - "Fi 53 1052 26 22:00-22:30 0 0 C P
99/0
Family Guy - "E. Peterbus Unum" 9 1008 26 22:30-23:00 0 0 A P
99/0
Exorcist II: The Heretic 37 1036 27 03:00-05:30 0 0 O X
99/0
Hook 4 1003 27 05:45-08:45 1 1 F 1
98/0
Bringing Up Baby 29 1028 27 07:00-09:00 0 0 O X
99/0
Psych - "Murder? ... Anyone? ... An 28 1027 27 08:00-09:00 0 0 A P
99/0
The Suite Life of Zack & Cody - "Bo 8 1007 27 10:30-11:00 0 0 A P
99/0
The Suite Life of Zack & Cody - "Bo 12 1011 27 11:30-12:00 0 0 A P
99/0
MonsterQuest - "Ghosts" 50 1049 27 13:00-14:00 0 0 A P
99/0
MonsterQuest - "Giant Killer Snakes 50 1049 27 14:00-15:00 0 0 A P
99/0
MonsterQuest - "China's Wildman" 50 1049 27 15:00-16:00 0 0 O X
99/0
The Suite Life on Deck - "Parrot Is 53 1052 27 19:00-19:30 1 1 C 1
99/0
The Suite Life of Zack & Cody - "Ar 53 1052 27 21:30-22:00 0 0 C P
99/0
The Suite Life of Zack & Cody - "Or 53 1052 27 22:00-22:30 0 0 C P
99/0
Family Guy - "Bill and Peter's Bogu 9 1008 28 00:30-01:00 0 0 A P
99/0
Family Guy - "A Hero Sits Next Door 9 1008 28 01:00-01:30 0 0 A P
99/0
Hook 4 1003 28 01:20-04:20 0 0 O X
99/0
The Master of Disguise 45 1044 28 08:00-10:00 0 0 O X
99/0
Kill Bill: Vol. 1 38 1037 28 09:00-11:15 1 1 F 1
98/0
Kill Bill: Vol. 2 38 1037 28 11:15-14:00 0 0 O X
99/0
The Suite Life on Deck - "The Suite 53 1052 28 19:00-19:30 0 0 C E
99/0
The Suite Life on Deck - "Parrot Is 53 1052 28 19:30-20:00 0 0 C E
99/0
Family Guy - "Love Blactually" 9 1008 28 20:00-20:30 1 1 A 1
99/0
Family Guy - "One if by Clam, Two i 54 1053 28 21:00-21:30 0 0 A P
99/0
The Suite Life of Zack & Cody - "Su 53 1052 28 21:40-22:05 0 0 C P
99/0
Family Guy - "Chick Cancer" 54 1053 28 22:00-22:30 0 0 A P
99/0
The Suite Life of Zack & Cody - "Si 53 1052 28 22:05-22:30 0 0 C P
99/0
Kill Bill: Vol. 1 38 1037 29 00:00-02:15 0 0 F E
98/0
Family Guy - "One if by Clam, Two i 54 1053 29 00:30-01:00 0 0 A P
99/0
Family Guy - "Chick Cancer" 54 1053 29 01:30-02:00 0 0 A P
99/0
Kill Bill: Vol. 2 38 1037 29 02:15-05:00 0 0 O X
99/0
Dave the Barbarian - "Band; Web" 53 1052 29 03:00-03:30 0 0 C P
99/0
A Haunting 35 1034 29 12:00-13:00 0 0 O X
99/0
The Suite Life of Zack & Cody - "Co 53 1052 29 12:40-13:05 0 0 C P
99/0
A Haunting 35 1034 29 13:00-14:00 0 0 O X
99/0
The Suite Life of Zack & Cody - "It 53 1052 29 13:05-13:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Co 53 1052 29 13:30-14:00 0 0 C P
99/0
The Suite Life of Zack & Cody - "Of 53 1052 29 17:00-17:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Gr 53 1052 29 17:30-18:00 0 0 C P
99/0
The Suite Life of Zack & Cody - "Wh 53 1052 29 18:00-18:30 0 0 C P
99/0
Family Guy - "Jungle Love" 4 1003 29 19:00-19:30 0 0 A P
99/0
Terminator: The Sarah Connor Chroni 9 1008 29 19:00-20:00 1 1 C 1
99/0
Family Guy - "To Love and Die in Di 4 1003 29 19:30-20:00 0 0 A P
99/0
Family Guy - "Stewie Kills Lois" 4 1003 29 20:00-20:30 0 0 A P
99/0
First Blood 25 1024 29 20:00-22:00 0 0 O X
99/0
Family Guy - "Lois Kills Stewie" 4 1003 29 20:30-21:00 0 0 A P
99/0
Paranormal State - "First Contact" 34 1033 29 21:00-21:30 0 0 O X
99/0
Paranormal State - "Hide and Seek" 34 1033 29 21:30-22:00 0 0 O X
99/0
Life With Derek - "Home Movies" 53 1052 29 21:30-22:00 0 0 C P
99/0
Family Guy - "Perfect Castaway" 9 1008 29 22:00-22:30 0 0 A P
99/0
Paranormal State - "The Glove" 34 1033 29 22:00-22:30 0 0 O X
99/0
The Suite Life of Zack & Cody - "Wh 53 1052 29 22:00-22:30 0 0 C P
99/0
Family Guy - "The King Is Dead" 54 1053 29 22:00-22:30 0 0 A P
99/0
Family Guy - "The Story on Page 1" 9 1008 29 22:30-23:00 0 0 A P
99/0
Paranormal State - "The Fire" 34 1033 29 22:30-23:00 0 0 O X
99/0
Family Guy - "Brian in Love" 54 1053 29 22:30-23:00 0 0 A P
99/0
Paranormal State - "First Contact" 34 1033 30 01:00-01:30 0 0 O X
99/0
An American Werewolf in Paris 4 1003 30 01:30-03:30 0 0 O X
99/0
Paranormal State - "Hide and Seek" 34 1033 30 01:30-02:00 0 0 O X
99/0
Family Guy - "The King Is Dead" 54 1053 30 01:30-02:00 0 0 A P
99/0
Paranormal State - "The Glove" 34 1033 30 02:00-02:30 0 0 O X
99/0
Family Guy - "Brian in Love" 54 1053 30 02:00-02:30 0 0 A P
99/0
Paranormal State - "The Fire" 34 1033 30 02:30-03:00 0 0 O X
99/0
A Haunting 35 1034 30 12:00-13:00 0 0 O X
99/0
A Haunting 35 1034 30 13:00-14:00 0 0 O X
99/0
The Suite Life of Zack & Cody - "Ru 53 1052 30 13:00-13:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Bi 53 1052 30 13:30-14:00 0 0 C P
99/0
Life With Derek - "Just Friends" 53 1052 30 14:00-14:30 0 0 C R
99/0
Life With Derek - "Derek Denies Den 53 1052 30 14:30-15:00 0 0 C E
99/0
The Suite Life of Zack & Cody - "Mr 53 1052 30 18:00-18:30 0 0 C R
99/0
Family Guy - "PTV" 4 1003 30 19:00-19:30 0 0 A P
99/0
Family Guy - "Whistle While Your Wi 4 1003 30 19:30-20:00 0 0 A P
99/0
Family Guy - "Brian Goes Back to Co 4 1003 30 20:00-20:30 0 0 A P
99/0
Ancient Discoveries - "Ships" 50 1049 30 20:00-21:00 0 0 C P
99/0
Family Guy - "The Courtship of Stew 4 1003 30 20:30-21:00 0 0 A P
99/0
Life With Derek - "Just Friends" 53 1052 30 21:30-22:00 0 0 C R
99/0
Family Guy - "Jungle Love" 9 1008 30 22:00-22:30 0 0 A P
99/0
The Suite Life of Zack & Cody - "Mr 53 1052 30 22:00-22:30 0 0 C R
99/0
Family Guy - "I Am Peter, Hear Me R 54 1053 30 22:00-22:30 0 0 A P
99/0
Family Guy - "Wasted Talent" 9 1008 30 22:30-23:00 0 0 A P
99/0
Family Guy - "A Very Special Family 54 1053 30 22:30-23:00 0 0 A P
99/0
Psych - "Murder? ... Anyone? ... An 28 1027 01 00:00-01:00 0 0 A P
99/0
Ancient Discoveries - "Ships" 50 1049 01 00:00-01:00 0 0 C P
99/0
Family Guy - "I Am Peter, Hear Me R 54 1053 01 01:30-02:00 0 0 A P
99/0
Family Guy - "A Very Special Family 54 1053 01 02:00-02:30 0 0 A P
99/0
A Haunting 35 1034 01 12:00-13:00 0 0 O X
99/0
The Suite Life of Zack & Cody - "Pi 53 1052 01 12:35-13:00 0 0 C P
99/0
A Haunting 35 1034 01 13:00-14:00 0 0 O X
99/0
The Suite Life of Zack & Cody - "Da 53 1052 01 13:00-13:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Ki 53 1052 01 13:30-14:00 0 0 C P
99/0
The Suite Life of Zack & Cody - "Cr 53 1052 01 16:00-16:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Ro 53 1052 01 16:30-17:00 0 0 C P
99/0
The Suite Life of Zack & Cody - "Ba 53 1052 01 18:00-18:30 0 0 C P
99/0
Commando 37 1036 01 19:00-21:00 0 0 O X
99/0
MonsterQuest - "Lake Monsters of th 50 1049 01 19:00-20:00 0 0 O X
99/0
MonsterQuest - "Super Rats" 50 1049 01 20:00-21:00 0 0 O X
99/0
Life With Derek - "Fright Night" 53 1052 01 21:30-22:00 0 0 C P
99/0
Family Guy - "PTV" 9 1008 01 22:00-22:30 0 0 A P
99/0
The Suite Life of Zack & Cody - "Ba 53 1052 01 22:00-22:30 0 0 C P
99/0
Family Guy - "Let's Go to the Hop" 54 1053 01 22:00-22:30 0 0 A P
99/0
Family Guy - "The Thin White Line" 9 1008 01 22:30-23:00 0 0 A P
99/0
Family Guy - "Emission Impossible" 54 1053 01 22:30-23:00 0 0 A P
99/0
MonsterQuest - "Lake Monsters of th 50 1049 01 23:00-00:00 0 0 O X
99/0
In Plain Sight 28 1027 02 00:00-01:00 0 0 O X
99/0
Commando 37 1036 02 00:00-02:00 0 0 O X
99/0
MonsterQuest - "Super Rats" 50 1049 02 00:00-01:00 0 0 O X
99/0
Family Guy - "Let's Go to the Hop" 54 1053 02 01:30-02:00 0 0 A P
99/0
Family Guy - "Emission Impossible" 54 1053 02 02:00-02:30 0 0 A P
99/0
Romancing the Stone 37 1036 02 09:00-11:30 0 0 O X
99/0
A Haunting 35 1034 02 12:00-13:00 0 0 O X
99/0
The Suite Life of Zack & Cody - "Bo 53 1052 02 12:35-13:00 0 0 C P
99/0
A Haunting 35 1034 02 13:00-14:00 0 0 O X
99/0
The Suite Life of Zack & Cody - "Co 53 1052 02 13:00-13:30 0 0 C P
99/0
The Suite Life of Zack & Cody - "Fr 53 1052 02 13:30-14:00 0 0 C P
99/0
Commando 37 1036 02 14:00-16:00 0 0 O X
99/0
The Suite Life of Zack & Cody - "Li 53 1052 02 18:00-18:30 0 0 C P
99/0
Dodgeball: A True Underdog Story 45 1044 02 19:00-21:00 0 0 O X
99/0
Family Guy - "Brian Goes Back to Co 9 1008 02 22:00-22:30 0 0 A P
99/0
The Suite Life of Zack & Cody - "Li 53 1052 02 22:00-22:30 0 0 C P
99/0
Family Guy - "DaBoom" 54 1053 02 22:00-22:30 0 0 A P
99/0
Family Guy - "Brian Does Hollywood" 9 1008 02 22:30-23:00 0 0 A P
99/0
Family Guy - "A Picture Is Worth 1, 54 1053 02 22:30-23:00 0 0 A P
99/0
The Thing 51 1050 02 23:00-01:00 0 0 O X
99/0
--- print list end ---
michael at camille OldStuff $ mysql mythconverg -u michael -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 99
Server version: 5.0.60-log Gentoo Linux mysql-5.0.60-r1
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SELECT title, next_record
-> FROM record
-> WHERE next_record > now()
-> ORDER BY `record`.`next_record` ASC;
Empty set (0.21 sec)
mysql> quit
Bye
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?
More information about the mythtv-users
mailing list