[mythtv-users] Find Once Per Week Records Multiple Times

[Derek Battams]

Quoting Derek Battams <derek at battams.ca>:

> Quoting Derek Battams <derek at battams.ca>:
>
>> Quoting Bruce Markey <bjm at lvcm.com>:
>>
>>> Derek Battams wrote:
>>>> Quoting Bruce Markey <bjm at lvcm.com>:
>>>>> The interval begins from the time of the showing that was selected
>>>>> when the rule was created. If you created the rule on a Wed. showing,
>>>>> for example, a Monday or Tuesday recording would be the end of the
>>>>> week and Wednesday would start a new interval. Go to the options
>>>>> page for a showing you will see the find time in the subtitle:
>>>>>
>>>>> Best Week Ever
>>>>> (Fri, 11:00pm or later)
>>>>>    Airdate: Fri Jul 15 ...
>>>>
>>>> On the details screen it shows "Mon, 00:00 or later", which seems 
>>>> correct.  I
>>>
>>> Huh? How did you come to that conclusion? Unless you chose a late
>>> Sunday night showing at the stroke of midnight, that's hozed. It
>>> should have been Mon, 09:00 pm or later.
>>>
>>>> The find id is 732501 (7/9/2005).  Not sure if this is correct?
>>>
>>> July 9th would be a Saturday. It is not correct.
>>>
>>> Remove the rule you have now, look up the 9pm Mon showing and
>>> create a new rule. After creating it, go back and you should
>>> see "Mon, 09:00 pm or later" and the findids for this week should
>>> be 7/11/2005 and 7/18/2005 for next week.
>>>
>>> If it's "00:00" again, it may be the result of the find time and
>>> date not getting saved or your database schema didn't get updated
>>> properly or something. If it's still "00:00" then send the
>>> output for:
>>>
>>> $ mysql -u mythtv -pmythtv mythconverg
>>> mysql> select * from record where title='Your Show Title'\G
>>>
>>> --  bjm
>>
>> Ok, did as you said and this time it seems like everything is correct.  I
>> deleted the current rule and went to next Monday's airing and setup 
>> a 'find one
>> weekly' rule.  This time it shows "Mon, 21:00 or later", which is 
>> correct.  The
>> find id also shows 7/18/2005.  I chose 'none' for the duplicate check method
>> and the scheduler chose to skip the Monday airing in favour of the Tuesday
>> airing (due to conflicts for next Monday) and it also skipped the Wednesday
>> airing, as expected.
>>
>> It's probably worth noting that the only difference between the way 
>> I set it up
>> this time and last time is that this time I setup the schedule rule via
>> mythfrontend (the EPG), whereas the first time I did it via MythWeb.  Might
>> there be a bug with the way MythWeb schedules these types of recordings?
>>
>>  - Derek
>
> Ok... I thought this issue was solved, but now something weird happened.  The
> schedule is right, but it's still recording multiple showings.
>
> On the details screen it shows "Mon, 21:00 or later" with a findid of 
> Jul 18. It then proceeded to record the 9pm showing tonight.  Then it 
> started to record
> the midnight showing a half hour ago, but until it started recording 
> it had the
> 12am showing marked as "will record earlier showing".  The Wed, 3:30am airing
> is also marked as "will record earlier showing".  In case it helps, 
> here's the
> row from the record table for the program.
>
> mysql> select * from record where title='WWE RAW';
> +----------+------+--------+-----------+------------+----------+------------+---------+----------+-------------+------------------+---------+-------------+------------+-------------+-----------+-------------+-----------+----------+-----------+-------+---------+----------+--------------+--------+---------------+--------------+--------------+--------------+--------------+--------------+---------+----------+--------+----------+----------+
> | recordid | type | chanid | starttime | startdate  | endtime  | enddate    |
> title   | subtitle | description | category         | profile | recpriority |
> autoexpire | maxepisodes | maxnewest | startoffset | endoffset | recgroup |
> dupmethod | dupin | station | seriesid | programid    | search | 
> autotranscode
> | autocommflag | autouserjob1 | autouserjob2 | autouserjob3 | autouserjob4 |
> findday | findtime | findid | inactive | parentid |
> +----------+------+--------+-----------+------------+----------+------------+---------+----------+-------------+------------------+---------+-------------+------------+-------------+-----------+-------------+-----------+----------+-----------+-------+---------+----------+--------------+--------+---------------+--------------+--------------+--------------+--------------+--------------+---------+----------+--------+----------+----------+
> |       44 |   10 |   1407 | 21:00:00  | 2005-07-18 | 23:00:00 | 2005-07-18 |
> WWE RAW |          |             | Sports non-event | Default |       
>     0 |        1 |           0 |         0 |           0 |         8 
> | Default  |       1 |    15 | TSN     | SH056512 | EP0565120620 |    
>   0 |             0 |          1 |            0 |            0 |      
>       0 |            0 |       2 |
> 21:00:00 |      0 |        0 |        0 |
>
> I'll keep an eye out to see if it proceeds to record the Wed, 3:30am 
> airing even
> though the scheduler says it won't.  I'm running KnoppMyth R5A15 
> (MythTV 0.18). The 9pm airing was recorded on tuner 2 (the higher 
> priority tuner), chanid 2030.
> But both chanid 2030 and 1407 are the same channel (TSN).  Tuner 1 is my
> digital box and tuner two is analog.  Not that it should make a 
> difference, but
> perhaps it's the cause of this bug?  Does FindWeekly ignore the 9pm recording
> since it was moved to tuner 2?  I suspect it's not suppose to since 
> it did mark
> the 12am and Wed airings as "will record earlier" even though it did, 
> for some
> reason, start recording the midnight showing.
>
> Help appreciated,
>
> Derek

A quick update... I decided to stop the 12am recording in progress (since I
already recorded this at 9pm).  Now the Wed, 3:30am airing is listed as "will
record".  Again, the Mon, 9pm airing was recorded successfully so I'd expect
both the Tue, 12am and Wed, 3:30am airings to be skipped, which is how it was
marked until it just started to record the 12am showing.

The recorded table even shows that the 9pm airing was indeed recorded:

mysql> select * from recorded where title='WWE RAW';
+--------+---------------------+---------------------+---------+----------+-----------------------------------+------------------+---------------------------+----------+---------+---------+------------+-------------+----------+----------+----------+--------------+----------------+------------+-------+-----------------+-----------------+----------+--------+---------------+
| chanid | starttime           | endtime             | title   | subtitle |
description                       | category         | hostname         
        | bookmark | editing | cutlist | autoexpire | commflagged | 
recgroup | recordid
| seriesid | programid    | lastmodified   | filesize   | stars |
previouslyshown | originalairdate | preserve | findid | deletepending |
+--------+---------------------+---------------------+---------+----------+-----------------------------------+------------------+---------------------------+----------+---------+---------+------------+-------------+----------+----------+----------+--------------+----------------+------------+-------+-----------------+-----------------+----------+--------+---------------+
|   2030 | 2005-07-18 21:00:00 | 2005-07-18 23:08:00 | WWE RAW |        
   | Hulk
Hogan returns to answer HBK. | Sports non-event | mythtv-server.battams.lan |
NULL     |       0 | NULL    |          1 |           2 | Default  |    
    44 |
SH056512 | EP0565120620 | 20050718230854 | 4987305552 |     0 |         
       0
| 2005-07-18      |        0 | 732510 |             0 |
+--------+---------------------+---------------------+---------+----------+-----------------------------------+------------------+---------------------------+----------+---------+---------+------------+-------------+----------+----------+----------+--------------+----------------+------------+-------+-----------------+-----------------+----------+--------+---------------+
1 row in set (0.00 sec)

Yet, the Wed, 3:30am airing is now marked as "will record".

Help appreciated,

Derek