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.
Hi Mattias :)
Don't use --no-delete, since it won't delete old programs (just like the description says it shouldn't). I'll rewrite this to only keep old programs for 7 days, and nothing else (see the rest of the thread for details).
/O _______________________________________________ mythtv-dev mailing list mythtv-dev@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
