[mythtv-users] More missing listings

Bruce Markey bjm at lvcm.com
Thu Aug 26 00:23:02 EDT 2004


Kyle Kelly wrote:
> A couple of months ago I made a post along the lines of listings after 
> 9pm were not being added with datadirect.  The solution discussed was 
--^^^
> changing the maxday variable to 11 in the filldata.cpp file.  About a 
> week ago I updated to the latest cvs which uses maxday=14 and now I'm 
> experiencing the same problem again.  I was about to edit filldata.cpp 
> again and fix it again, but decided to search the archives first.  I 
> came up with this:
> 
> http://www.gossamer-threads.com/lists/mythtv/commits/72532
> 
> If this was working it would be great, but unfortunately its not.  I'm 
> wondering if its just me having this problem, because if others were I 
> would have assumed it would have been greatly discussed on the mailing 
> list since its so annoying for your listings to slow disappear each day.

Right. Most people aren't having this because normally TMS data
ends a 'day' at 5pm on the last day so it is checking to see if
the data is nearly empty after 6pm. However, you may have an
execptional situation if you are getting data after 6pm but it
is empty only after 9pm.

Just change the "18" on line 2583 to "21" or apply the attached
patch.

BTW it does always grab the full day for "tomorrow" so it will
have the full data before the day comes to record. However, it is
annoying to have missing evenings for future days and the scheduler
may not know about other showing of an episode that it could choose
from.

--  bjm
-------------- next part --------------
Index: programs/mythfilldatabase/filldata.cpp
===================================================================
RCS file: /var/lib/mythcvs/mythtv/programs/mythfilldatabase/filldata.cpp,v
retrieving revision 1.131
diff -u -r1.131 filldata.cpp
--- programs/mythfilldatabase/filldata.cpp	19 Aug 2004 02:02:26 -0000	1.131
+++ programs/mythfilldatabase/filldata.cpp	26 Aug 2004 04:10:51 -0000
@@ -2580,7 +2580,7 @@
                 querystr.sprintf("SELECT COUNT(*) as 'hits' "
                                  "FROM channel LEFT JOIN program USING (chanid) "
                                  "WHERE sourceid = %d AND starttime >= "
-                                 "DATE_ADD(CURRENT_DATE(), INTERVAL '%d 18' "
+                                 "DATE_ADD(CURRENT_DATE(), INTERVAL '%d 21' "
                                  "DAY_HOUR) AND "
                                  "starttime < DATE_ADD(CURRENT_DATE(), "
                                  "INTERVAL 1+%d DAY) "


More information about the mythtv-users mailing list