[mythtv-users] Duplicate programs due to schedule changes

[Mattias Holmlund]

Hi,

I found the following in my program table today:

mysql> select chanid, starttime, endtime, title from program where
title="Mediemagasinet" order by starttime;
+--------+---------------------+---------------------+----------------+
| chanid | starttime           | endtime             | title          |
+--------+---------------------+---------------------+----------------+
|   1005 | 2005-03-02 16:00:00 | 2005-03-02 16:30:00 | Mediemagasinet |
|   1005 | 2005-03-02 16:05:00 | 2005-03-02 16:35:00 | Mediemagasinet |
|   1005 | 2005-03-03 20:30:00 | 2005-03-03 21:00:00 | Mediemagasinet |
|   1005 | 2005-03-05 14:00:00 | 2005-03-05 14:30:00 | Mediemagasinet |
|   1005 | 2005-03-09 16:05:00 | 2005-03-09 16:35:00 | Mediemagasinet |
|   1005 | 2005-03-10 20:30:00 | 2005-03-10 21:00:00 | Mediemagasinet |
+--------+---------------------+---------------------+----------------+
6 rows in set (0.01 sec) 

As you can see, there are two entries for Mediemagasinet on March 2nd,
one from 16:00 to 16:30 and one from 16:05 to 16:35. Mediemagasinet
was originally scheduled for 16:00, but they changed it a few days ago
to run at 16:05 instead. What I think has happened is that the first
time mythfilldatabase fetched data for March 2nd it added the
16:00-entry. Then when it fetched new data for March 2nd it added the
program at 16:05 without realising that it had to remve the
16:00-entry.

Shouldn't myth delete old entries when it runs mytfilldatabase to
update the programs table?

I'm running Myth 0.17 (Debian packages) and tv_grab_se_swedb if that
makes any difference.

Regards,

Mattias Holmlund