[mythtv-users] how do I list previously recorded shows?
Paul - subscriptions
mylists at wilsononline.id.au
Fri Sep 4 04:16:51 UTC 2009
On Fri, Sep 4, 2009 at 12:48 PM, Paul Wilson <paul at wilsononline.id.au>wrote:
>
>
> On Fri, Sep 4, 2009 at 7:22 AM, Paul - subscriptions <
> mylists at wilsononline.id.au> wrote:
>
>>
>>
>> On Thu, Sep 3, 2009 at 10:06 PM, Paul - subscriptions <
>> mylists at wilsononline.id.au> wrote:
>>
>>> note I've now checked the "oldrecorded" table and subtitle does NOT
>>> exist, so this must be a bug right?
>>> what else can I check
>>>
>>>
>>>
>>>
>>> On Thu, Sep 3, 2009 at 10:02 PM, Paul - subscriptions <
>>> mylists at wilsononline.id.au> wrote:
>>>
>>>> The reason I'm wanting is I'm trying to figure out why MythTV is not
>>>> recording a new episode as I'm pretty sure its not a duplicate.
>>>> ie is this a bug or have I missed something.
>>>>
>>>>
>>>>
>>>>
>>>> On Thu, Sep 3, 2009 at 9:33 PM, Paul - subscriptions <
>>>> mylists at wilsononline.id.au> wrote:
>>>>
>>>>> Is there a quick way to like all the episodes of a particular show?
>>>>>
>>>>> ie what database table is this stored in ? and do these ever expire or
>>>>> get purged?
>>>>>
>>>>> thanks
>>>>> Paul
>>>>>
>>>>
>>>>
>>>
>> I've found a row in the "program" table but none in the recorded table..
>>
>> --- print list start ---
>> Title - Subtitle Ch Station Day Start End S C I T N
>> Pri
>> City Homicide - "The Confessio 6 PRIME C 07 20:30-21:35 1 0 0 d P
>> 0/0
>>
>>
>> mysql> SELECT starttime,title, subtitle,
>> programid,syndicatedepisodenumber,programid FROM program WHERE title LIKE
>> "City Homicide%" and subtitle = "The Confession";
>>
>> +---------------------+---------------+----------------+-------------+-------------------------+-------------+
>> | starttime | title | subtitle | programid |
>> syndicatedepisodenumber | programid |
>>
>> +---------------------+---------------+----------------+-------------+-------------------------+-------------+
>> | 2009-09-07 20:30:00 | City Homicide | The Confession | EP341898163 |
>> E6S3 | EP341898163 |
>>
>> +---------------------+---------------+----------------+-------------+-------------------------+-------------+
>>
>>
> I see two shows (different subtitles) which have the same "Programid" is
> that normal
>
> ====
>
> mysql> SELECT starttime, title, subtitle, programid FROM program WHERE
> title =
> -> 'City Homicide';
> +---------------------+---------------+----------------+-------------+
> | starttime | title | subtitle | programid |
> +---------------------+---------------+----------------+-------------+
> | 2009-08-31 20:30:00 | City Homicide | Thai Take Away | |
> | 2009-08-31 20:30:00 | City Homicide | Thai Take Away | EP341898153 |
> | 2009-08-31 20:30:00 | City Homicide | Thai Take Away | |
> | 2009-09-07 20:30:00 | City Homicide | The Confession | EP341898163 |
> | 2009-08-31 20:30:00 | City Homicide | Thai Take Away | |
> +---------------------+---------------+----------------+-------------+
> 5 rows in set (0.01 sec)
>
> mysql> SELECT starttime, title, subtitle, programid FROM oldrecorded WHERE
> -> title = 'City Homicide';
>
> +---------------------+---------------+---------------------------------+----------------+
> | starttime | title | subtitle |
> programid |
>
> +---------------------+---------------+---------------------------------+----------------+
> | 2007-08-27 20:30:00 | City Homicide |
> | |
> | 2007-09-10 14:00:00 | City Homicide |
> | |
> | 2007-09-03 20:30:00 | City Homicide |
> | |
> | 2007-09-09 00:05:00 | City Homicide |
> | |
> | 2007-09-10 20:30:00 | City Homicide |
> | |
> | 2007-09-17 20:30:00 | City Homicide |
> | |
> | 2007-09-24 20:30:00 | City Homicide |
> | |
> | 2007-10-01 20:30:00 | City Homicide |
> | |
> | 2007-10-08 20:30:00 | City Homicide |
> | |
> | 2007-10-15 20:30:00 | City Homicide |
> | |
> | 2007-10-29 20:30:00 | City Homicide |
> | |
> | 2007-11-12 20:30:00 | City Homicide |
> | |
> | 2007-11-05 20:30:00 | City Homicide |
> | |
> | 2007-11-19 20:30:00 | City Homicide |
> | |
> | 2008-06-30 20:30:00 | City Homicide | Thicker than Water |
> EP341898112 |
> | 2008-07-07 20:30:00 | City Homicide | Somersaulting Dogs |
> EP341898122 |
> | 2008-07-21 20:30:00 | City Homicide | Taniwha |
> EP341898142 |
> | 2008-07-14 20:30:00 | City Homicide | In House |
> EP341898132 |
> | 2008-08-04 20:30:00 | City Homicide |
> | |
> | 2008-07-28 20:30:00 | City Homicide | Guilty As Charged |
> EP341898152 |
> | 2008-08-25 20:30:00 | City Homicide | Reward |
> EP341898162 |
> | 2008-09-08 20:30:00 | City Homicide | Life After Death |
> EP341898182 |
> | 2008-09-01 20:30:00 | City Homicide | Golden |
> EP341898172 |
> | 2008-10-20 20:30:00 | City Homicide | Jane Doe |
> EP003418981142 |
> | 2008-09-29 20:30:00 | City Homicide | Oh Lucky Man |
> EP003418981112 |
> | 2008-09-15 20:30:00 | City Homicide | Never To Be Released |
> EP341898192 |
> | 2008-09-22 20:30:00 | City Homicide |
> | |
> | 2008-10-27 20:30:00 | City Homicide | Serious Men |
> EP003418981111 |
> | 2008-10-06 20:30:00 | City Homicide | Spoils of War |
> EP003418981122 |
> | 2008-11-10 20:30:00 | City Homicide | The Ripe Fruits in the Garden |
> EP341898151 |
> | 2008-10-13 20:30:00 | City Homicide | Jury Duty |
> EP003418981132 |
> | 2009-02-08 20:30:00 | City Homicide | Junkie |
> EP341898113 |
> | 2009-02-22 20:30:00 | City Homicide | The Forgotten |
> EP341898133 |
> | 2009-02-15 20:30:00 | City Homicide | Stolen Sweets |
> EP341898123 |
> | 2009-03-01 20:30:00 | City Homicide | A Green Light |
> EP341898143 |
> | 2009-03-08 20:30:00 | City Homicide | House of Horrors |
> EP341898153 |
>
> | 2009-03-15 20:30:00 | City Homicide | The Cutting Edge |
> EP341898163 |
>
> | 2009-03-22 20:30:00 | City Homicide | Rage |
> EP341898173 |
> | 2009-03-29 20:30:00 | City Homicide | Life & Death |
> EP341898183 |
> | 2009-08-10 20:30:00 | City Homicide | The Money Shot / Meet and Greet
> | |
> | 2009-08-31 20:30:00 | City Homicide | Thai Take Away |
> EP341898153 |
> | 2009-08-24 20:30:00 | City Homicide | The First Stone |
> EP341898143 |
>
> +---------------------+---------------+---------------------------------+----------------+
>
> ===
>
> Programid=EP341898163
where does this value come from ?
see above...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20090904/280f882b/attachment.htm>
More information about the mythtv-users
mailing list