<br><br><div class="gmail_quote">On Fri, Sep 4, 2009 at 12:48 PM, Paul Wilson <span dir="ltr"><<a href="mailto:paul@wilsononline.id.au">paul@wilsononline.id.au</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div></div><div class="h5"><br><br><div class="gmail_quote">On Fri, Sep 4, 2009 at 7:22 AM, Paul - subscriptions <span dir="ltr"><<a href="mailto:mylists@wilsononline.id.au" target="_blank">mylists@wilsononline.id.au</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div></div><div><br><br><div class="gmail_quote">On Thu, Sep 3, 2009 at 10:06 PM, Paul - subscriptions <span dir="ltr"><<a href="mailto:mylists@wilsononline.id.au" target="_blank">mylists@wilsononline.id.au</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
note I've now checked the "oldrecorded" table and subtitle does NOT exist, so this must be a bug right?<br>what else can I check<div><div></div><div><br><br><br><br><div class="gmail_quote">On Thu, Sep 3, 2009 at 10:02 PM, Paul - subscriptions <span dir="ltr"><<a href="mailto:mylists@wilsononline.id.au" target="_blank">mylists@wilsononline.id.au</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">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.<br>
ie is this a bug or have I missed something.<div><div></div><div><br><br><br><br><div class="gmail_quote">
On Thu, Sep 3, 2009 at 9:33 PM, Paul - subscriptions <span dir="ltr"><<a href="mailto:mylists@wilsononline.id.au" target="_blank">mylists@wilsononline.id.au</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Is there a quick way to like all the episodes of a particular show?<br><br>ie what database table is this stored in ? and do these ever expire or get purged?<br><br>thanks<br><font color="#888888">Paul<br>
</font></blockquote></div><br>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br></div></div>I've found a row in the "program" table but none in the recorded table..<br><br>--- print list start ---<br>Title - Subtitle Ch Station Day Start End S C I T N Pri<br>
City Homicide - "The Confessio 6 PRIME C 07 20:30-21:35 1 0 0 d P 0/0<br><br><br>mysql> SELECT starttime,title, subtitle, programid,syndicatedepisodenumber,programid FROM program WHERE title LIKE "City Homicide%" and subtitle = "The Confession";<br>
+---------------------+---------------+----------------+-------------+-------------------------+-------------+<br>| starttime | title | subtitle | programid | syndicatedepisodenumber | programid |<br>
+---------------------+---------------+----------------+-------------+-------------------------+-------------+<br>| 2009-09-07 20:30:00 | City Homicide | The Confession | EP341898163 | E6S3 | EP341898163 |<br>
+---------------------+---------------+----------------+-------------+-------------------------+-------------+<br><br>
</blockquote></div><br></div></div>I see two shows (different subtitles) which have the same "Programid" is that normal<br><br>====<br><br><font face="courier new,monospace">mysql> SELECT starttime, title, subtitle, programid FROM program WHERE title =<br>
-> 'City Homicide';<br>+---------------------+---------------+----------------+-------------+<br>| starttime | title | subtitle | programid |<br>+---------------------+---------------+----------------+-------------+<br>
| 2009-08-31 20:30:00 | City Homicide | Thai Take Away | |<br>| 2009-08-31 20:30:00 | City Homicide | Thai Take Away | EP341898153 |<br>| 2009-08-31 20:30:00 | City Homicide | Thai Take Away | |<div class="im">
<br>
| 2009-09-07 20:30:00 | City Homicide | The Confession | EP341898163 |<br></div>| 2009-08-31 20:30:00 | City Homicide | Thai Take Away | |<br>+---------------------+---------------+----------------+-------------+<br>
5 rows in set (0.01 sec)<br><br>mysql> SELECT starttime, title, subtitle, programid FROM oldrecorded WHERE<br> -> title = 'City Homicide';<br>+---------------------+---------------+---------------------------------+----------------+<br>
| starttime | title | subtitle | programid |<br>+---------------------+---------------+---------------------------------+----------------+<br>| 2007-08-27 20:30:00 | City Homicide | | |<br>
| 2007-09-10 14:00:00 | City Homicide | | |<br>| 2007-09-03 20:30:00 | City Homicide | | |<br>| 2007-09-09 00:05:00 | City Homicide | | |<br>
| 2007-09-10 20:30:00 | City Homicide | | |<br>| 2007-09-17 20:30:00 | City Homicide | | |<br>| 2007-09-24 20:30:00 | City Homicide | | |<br>
| 2007-10-01 20:30:00 | City Homicide | | |<br>| 2007-10-08 20:30:00 | City Homicide | | |<br>| 2007-10-15 20:30:00 | City Homicide | | |<br>
| 2007-10-29 20:30:00 | City Homicide | | |<br>| 2007-11-12 20:30:00 | City Homicide | | |<br>| 2007-11-05 20:30:00 | City Homicide | | |<br>
| 2007-11-19 20:30:00 | City Homicide | | |<br>| 2008-06-30 20:30:00 | City Homicide | Thicker than Water | EP341898112 |<br>| 2008-07-07 20:30:00 | City Homicide | Somersaulting Dogs | EP341898122 |<br>
| 2008-07-21 20:30:00 | City Homicide | Taniwha | EP341898142 |<br>| 2008-07-14 20:30:00 | City Homicide | In House | EP341898132 |<br>| 2008-08-04 20:30:00 | City Homicide | | |<br>
| 2008-07-28 20:30:00 | City Homicide | Guilty As Charged | EP341898152 |<br>| 2008-08-25 20:30:00 | City Homicide | Reward | EP341898162 |<br>| 2008-09-08 20:30:00 | City Homicide | Life After Death | EP341898182 |<br>
| 2008-09-01 20:30:00 | City Homicide | Golden | EP341898172 |<br>| 2008-10-20 20:30:00 | City Homicide | Jane Doe | EP003418981142 |<br>| 2008-09-29 20:30:00 | City Homicide | Oh Lucky Man | EP003418981112 |<br>
| 2008-09-15 20:30:00 | City Homicide | Never To Be Released | EP341898192 |<br>| 2008-09-22 20:30:00 | City Homicide | | |<br>| 2008-10-27 20:30:00 | City Homicide | Serious Men | EP003418981111 |<br>
| 2008-10-06 20:30:00 | City Homicide | Spoils of War | EP003418981122 |<br>| 2008-11-10 20:30:00 | City Homicide | The Ripe Fruits in the Garden | EP341898151 |<br>| 2008-10-13 20:30:00 | City Homicide | Jury Duty | EP003418981132 |<br>
| 2009-02-08 20:30:00 | City Homicide | Junkie | EP341898113 |<br>| 2009-02-22 20:30:00 | City Homicide | The Forgotten | EP341898133 |<br>| 2009-02-15 20:30:00 | City Homicide | Stolen Sweets | EP341898123 |<br>
| 2009-03-01 20:30:00 | City Homicide | A Green Light | EP341898143 |<br>| 2009-03-08 20:30:00 | City Homicide | House of Horrors | EP341898153 |<br><br>| 2009-03-15 20:30:00 | City Homicide | The Cutting Edge | EP341898163 |<br>
<br>| 2009-03-22 20:30:00 | City Homicide | Rage | EP341898173 |<br>| 2009-03-29 20:30:00 | City Homicide | Life & Death | EP341898183 |<br>| 2009-08-10 20:30:00 | City Homicide | The Money Shot / Meet and Greet | |<br>
| 2009-08-31 20:30:00 | City Homicide | Thai Take Away | EP341898153 |<br>| 2009-08-24 20:30:00 | City Homicide | The First Stone | EP341898143 |<br>+---------------------+---------------+---------------------------------+----------------+<br>
<br>===<br></font><br></blockquote><div><font><font face="courier new,monospace">Programid=EP341898163</font></font> <br>where does this value come from ?<br></div></div>see above... <br>