On 27 Feb 2005 09:13:42 +0000, Andrew M. Bishop <[EMAIL PROTECTED]> wrote: <snip> > The first of the two attached patches (mythfilldatabase.patch1.diff) > fixes this. Without the fix there are thousands of sql insert errors > and the database ends up with overlapping programs.
I have probably been bitten by this behaviour. I found the following in my program table yesterday: 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 remove the 16:00-entry. I'm running Myth 0.17 (Debian packages) and tv_grab_se_swedb if that makes any difference. Regards, Mattias Holmlund
_______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
