[mythtv-users] Which table?
Robert
RobertCL at iname.com
Sun Sep 21 18:07:59 UTC 2008
Michael Sullivan wrote:
> 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?
Calculating dependencies... done!
[ebuild R ] media-tv/mythtv-0.21_p17722 USE="aac alsa dvb dvd fftw
lirc mmx opengl perl python x264 xvid (-altivec) -autostart -debug
-directv -ieee1394 -jack -lcd -xvmc" VIDEO_CARDS="nvidia" 0 kB [1]
Maybe thats it? You really need someone with 0.20 to try running the
query and see what results they get for it to be a fair test..
Robert.
More information about the mythtv-users
mailing list