[mythtv-users] DVB EPG kills Manual Schedule

[Bruce Markey]

Stuart Auchterlonie wrote:
> On Fri, Nov 04, 2005 at 02:06:11PM +0000, Andrew Meredith wrote:
>> Hi Folks,
>>
>> I'm having strange problems, but more of that later.
>>
>> I have/had a manual program in for the full morning weather forecast. It 
>> goes in just fine. It shows up in the "Upcoming" listings and all looks 
>> well. Then come the day, it has vapourised. I put it back in again and 
>> it goes away again.
>>
>> A good look through the logs turns up:
>>
>> 2005-11-04 00:26:36.556 Schedule Change on Channel 8006
>> 2005-11-04 00:26:36.559 Old: 2005-11-07T06:55:00 2005-11-07T07:05:00 ITV 
>> Weather (Manual Record)
>> 2005-11-04 00:26:36.561 New: 2005-11-07 06:00:00 2005-11-07 07:00:00 
>> GMTV NEWSHOUR
> [snip]
>> I wonder if the DVB EPG transcribing code needs a clause to protect the 
>> manual scheduling, similar to that which must already be in the 
>> mythfilldatabase code.
>>
> 
> What it needs is for a manual schedule not to overwrite the
> underlying program information data.

For manual recordings, the scheduler adds entries flagged in the
manualid field so that a manual entry can be identified even when
the there is an entry in the the listings for the same time and
channel.

mysql> describe program;
+-------------------------+------------------+------+-----+---------------------+-------+
| Field                   | Type             | Null | Key | Default | Extra |
+-------------------------+------------------+------+-----+---------------------+-------+
| chanid                  | int(10) unsigned |      | PRI | 0 |       |
...
| manualid                | int(10) unsigned |      | PRI | 0 |       |
+-------------------------+------------------+------+-----+---------------------+-------+
25 rows in set (0.00 sec)

mysql> select title,subtitle from program where manualid > 1;
+------------------------+--------------------------+
| title                  | subtitle                 |
+------------------------+--------------------------+
| TWC (Manual Record)    | Fri Nov 4 08:00:00 2005  |
| TWC (Manual Record)    | Sat Nov 5 08:00:00 2005  |
| TWC (Manual Record)    | Sun Nov 6 08:00:00 2005  |
| TWC (Manual Record)    | Mon Nov 7 08:00:00 2005  |
...

> The EIT stuff is doing what it's supposed to. Gets new event
> data, compares it against the old, there's a conflict so the
> new information is assumed to be better than the old info.
> 
> It's fair to assume that updated information is better than
> what we have?

Yes.

> Can someone comment on why a manually schedule recording
> overwrites the underlying program information in the guide?

The DELETE that clears out the old entries while updating should
have a clause for WHERE... "AND program.manualid = 0 ".

--  bjm