[mythtv-users] NFL recording rules fail only on Sunday night

[Michael T. Dean]

On 10/17/2015 03:40 PM, Jerome Yuzyk wrote:
> On Thursday, October 15, 2015 03:21:26 PM Jerome Yuzyk wrote:
>> On Thursday, October 15, 2015 03:14:25 PM Jerome Yuzyk wrote:
>>> On Thursday, October 15, 2015 09:51:18 PM Nick Morrott wrote:
>>>> On 15 October 2015 at 21:38, Jerome Yuzyk <jerome at supernet.ab.ca> wrote:
>>>>> I have had this rule defined for a few weeks, on the advice of others for whom it works:
>>>>>
>>>>> Title: Football [early]
>>>>> Additional Tables: , program pnext
>>>>> Search Phrase: program.category = 'Sports event' AND program.title LIKE '%FL%Football'
>>>>> AND pnext.title LIKE '%FL%Football' AND program.chanid = pnext.chanid AND
>>>>> program.endtime = pnext.starttime AND program.first > 0
>>>>>
>>>>> And it's worked great. Except now it totally ignores Sunday Night Football, despite it being on 3 different channels. It's not bumped by anything - MythWeb shows it as not marked-up at all with the usual borders, like it's been totally ignored. I do a mythfilldatabase with --dd-grab-all every morning, so I'm working with the freshest SchedulesDirect data.
>>>>>
>>>>> How would I debug this?
>>>> The title match program.title LIKE '%FL%Football' is never going to
>>>> match "Sunday Night Football.
>>>>
>>>> A small change to the match expression is needed to capture both
>>>> titles in the one rule (or alternatively create a separate rule that
>>>> match Sunday Night Football directly).
>>> But the program is, as far as I see in MythWeb, "NFL Football", like all the others.
>> Oh Duh, sorry people. Dark screen colours and bright sunshine don't jive: the program is grabbed a couple lines above. Sorry.
> Except... that's actually not the issue. Instead it's a hole in the 2 recording rules I derived from others' advice, and a 5-minute time shift that some channels have.
>
> Here are my two rules:
>
> Title: Football [early]
> Additional Tables: , program pnext
> Search Phrase:
>
>      program.category = 'Sports event' AND program.title LIKE '%FL%Football'
>      AND pnext.title LIKE '%FL%Football' AND program.chanid = pnext.chanid
>      AND program.endtime = pnext.starttime AND program.first > 0
>
> Title: Football [late]
> Additional Tables: , program pnext
> Search Phrase:
>
>      program.category = 'Sports event' AND program.title LIKE '%FL%Football'
>      AND pnext.title NOT LIKE '%FL%Football' AND program.chanid = pnext.chanid
>      AND program.endtime = pnext.starttime AND program.first > 0
>
> The Early rule will not add 30 extra minutes because the next program is another football game.
>
> The Late rule will add 30 minutes because the next program is NOT another football game.
>
> Here's the MythWeb search results:
>
>      http://www.imageno.com/wv6gzwcnybgrpic.html
>
> Notice the last 3 entries are the same title as the 3 before it, yet aren't marked. But, the last 3 showings are delayed 5 minutes, so the Later showing is chosen and the even-later showings are ignored, even by the Early rule. I did a Title Search in the frontend and the 3 showings unmarked in MythWeb are marked with '-'.
>
> Question is, why aren't these showings marked in any way? Not as "earlier showing chosen", or "ignored".
>
> For now I have to create a "Record only this showing" rule to choose the last in the list (because it's a reliable HD broadcast).
>
> Can anyone see why this would happen?
>


Where's your join?  Did you really only specify, ", program pnext" for 
your additional tables without telling the database how that table's 
data relates to program?  Without a proper join, you'd get strange 
results--meaning I'd expect it to not match a bunch of stuff (and I'm 
actually surprised it's matching some stuff "properly").

Mike