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