Re: [mythtv-users] Re: Fixing my "no data" problem in EPG
On Jul 23, 2005, at 7:50 PM, [EMAIL PROTECTED] wrote: The obvious solution is to tell mythfilldatabase to limit itself to 10 or 11 days of listings so that there is always data available for the short-schedule channels on the first attempt. Other solutions would be to find a way to adjust the threshold percentage at which a day's schedule is considered complete, or to find a way to make a certain range of future dates mandatory updates (so that the percentage of filled time slots is not considered beyond day 10, for example, meaning that days 2, 11, 12, 13 and 14 are all downloaded every night). Those probably require hacking the sources. This is what I have had to recently do. mythfilldatabase was checking that there where at least 4 times as many programs starting after 6pm for a given source as there are channels. This is in programs/mythfilldatabase/filldata.cpp . After changing the code to require only twice as many programs starting after 10pm as there are channels, my problem was fixed. (My data was only missing for cable channels after 10pm). If you search for "d 18" in that file, that is the sql line that gets the number of programs starting after 6pm (18:00), and about twelve lines down is a line that ends in "chancnt * 4", that decides if there are enough programs for that source. I ran the query manually against filled schedules, and broken schedules, to come up with the timespan and multiplier that fixed my issue. I can't remember if someone already mentioned this, but the reason you always have two good days of data is that mythfilldatabase always refreshes the data for tomorrow, even if it is full, in case there had been scheduling changes. -Michael ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Re: Fixing my "no data" problem in EPG
On Sat, Jul 23, 2005 at 02:19:49PM -0700, Brad wrote: > Data is already present for Fri Aug 5 2005, skipping > Adjusting program database end times... > 0 replacements made. Some of us Canadians have noticed that many of our listings only have 11 days worth of data while the rest have 14. (Specifically, the local and international listings are 14-day, while the national networks delivered from Toronto are 11-day.) When mythfilldatabase runs, it seems to set the "I have data" flag for each date globally rather than on a channel-by-channel basis. If there are enough holes in the schedule then it will retry downloading that day's listings every night. Once a certain percentage of the time slots have data in them myth stops trying to find more data (assuming the holes are "off air" or "infomercial" time, I guess). If you have a bunch of 11-day channels and only a few 14-day channels then this works out OK, as Myth tries to get days 12 through 14 every night. If you have mostly 14-day channels and only a few 11-day channels then those days may be marked as complete, in which case you don't get any data for the 11-day channels until the forced "TBD" update the night before the air date. The obvious solution is to tell mythfilldatabase to limit itself to 10 or 11 days of listings so that there is always data available for the short-schedule channels on the first attempt. Other solutions would be to find a way to adjust the threshold percentage at which a day's schedule is considered complete, or to find a way to make a certain range of future dates mandatory updates (so that the percentage of filled time slots is not considered beyond day 10, for example, meaning that days 2, 11, 12, 13 and 14 are all downloaded every night). Those probably require hacking the sources. ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
[mythtv-users] Re: Fixing my "no data" problem in EPG
Thanks for the response, Patrick. I'm using the mythfilldatabase scheduler built into MythFrontend (Settings>General) - as per the documentation. If I execute mythfilldatabase from terminal, this is the output:---Your subscription expires on 07/28/2005 10:36:50 PMGrab complete. Actual data from Sun Jul 24 07:00:00 2005 to Mon Jul 25 07:00:00 2005 (UTC) Clearing data for source...Clearing from Sun Jul 24 00:00:00 2005 to Mon Jul 25 00:00:00 2005 (localtime)Data for source cleared...Main temp tables populated. Updating myth channels...Updating icons for sourceid: 1Channels updated.. Updating programs...Data is already present for Sat Jul 23 2005, skippingData is already present for Mon Jul 25 2005, skippingData is already present for Tue Jul 26 2005, skippingData is already present for Wed Jul 27 2005, skippingData is already present for Thu Jul 28 2005, skippingData is already present for Fri Jul 29 2005, skippingData is already present for Sat Jul 30 2005, skippingData is already present for Sun Jul 31 2005, skippingData is already present for Mon Aug 1 2005, skippingData is already present for Tue Aug 2 2005, skippingData is already present for Wed Aug 3 2005, skippingData is already present for Thu Aug 4 2005, skippingData is already present for Fri Aug 5 2005, skippingAdjusting program database end times...0 replacements made.2005-07-23 13:54:44 mythfilldatabase: Listings Download Finished---So, it appears that it is working correctly just that it *thinks* it has data for all the channels (which it does not) and skips them. Not sure why it always has all the data for the next 2 days - as it appears to be skipping those as well.Anymore ideas would be appreciated.I'm a noobie, but have you setup mythfilldatabase in cron? If so, maybe the cron job isn't working correctly. Try running mythfilldatabase from the command line and see if it populates the database. On my connection, it takes FOREVER to download the channel guide data. That it works after resetting the database suggests that the database and mtyh setup is good, just the database isn't getting populated. > My EPG (TV Guide) shows "no data" for a large number of channels when > viewing further that 2 days into the future. So far, I've been > correcting this by doing the following: > > - run "mythtvsetup" > - erase program data when prompted (DO NOT erase capture card settings) > - create Zap2It profile > - assign to input > - exit > - run "mythfilldatabase" > > I will then have EPG data for all channels for 12-14 days. But day by > day, this dwindles down until there is only 2 days of data for most > channels. Any idea how to fix this? > > I am running MythTV 16.1, FC1, using Datadirect. > > Thanks for any insights anyone has. ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
