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
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
