[mythtv-users] mythfilldatabase shows No Data for some channels

Cameron Dale camrdale at gmail.com
Thu Jul 7 18:41:37 EDT 2005


On 7/7/05, chris at cpr.homelinux.net <chris at cpr.homelinux.net> wrote:
> 
> On Thu, Jul 07, 2005 at 09:08:29AM -0700, Cameron Dale wrote:
> > How do other people deal with this? Or is this something specific to my
> > listings area (Vancouver, Canada)?
> 
> I have noticed that different channels have different amounts of data
> available all the time. I use the Vancouver non-digital listings (I'm
> in Burnaby) and have noticed that some channels always go to the end of
> the 14th day and others always end at 17:00 on the 12th day. Those
> channels with short listings (A&E, DISC) were the ones that broke and
> showed "no data" for several days. I used myth-setup to clear the
> listings and then ran /etc/init.d/mythfilldatabase manually, and
> haven't had any problems since. Those channels still run a day and a
> half behind the rest, but they do get fresh data every night.


Hey, a local! I too am in Burnaby. We should have a local MUG meetup. :) In 
fact, I too use an Xbox as a frontend (which I see from another thread that 
you do as well) so I guess that would make it an XMUG. ;)

I am using the same listings as you, except only basic cable (<29). I find 
that the stations 17,18,19,22,25,26 all stop at 17:00 on the 12th day, as 
you mentioned, whereas all other stations have a full 14 days.I have run 
myth-setup a couple of times to clear the listings and then run 
mythfilldatabase manually, and it still happens to me. I don't get fresh 
data every night. I'm using 0.18.1, what version are you running? 

> Perhaps the best way for me is just to write a script to clear the 
> credits,
> > people, program, programgenres, and programrating tables, and then run
> > mythfilldatabase to reload them.
> 
> You could probably just find the location where mythfilldatabase stores
> its end-of-listings pointer and roll that back a few days every night
> before the normal run so that it gets 3 or 4 days worth of listings at
> the far end of the schedule. I would expect it to fill in the holes and
> discard the duplicates....
> 
> 
Unfortunately it looks like there is no pointer, but mythfilldatabase just 
looks at the existing program data to determine what days it needs to 
download data for. For me, the missing data doesn't cause my total data for 
the day to drop below the threshold that mythfilldatabase uses to determine 
which days to download. Perhaps your's does? 

In case someone else has the same problem, here's how I get around it. I 
added this to my mythfilldatabasecron script before it runs 
mythfilldatabase:

echo "DELETE FROM program WHERE starttime >= DATE_ADD(CURRENT_DATE(), 
INTERVAL 11 DAY);" | mysql mythconverg
echo "DELETE FROM programrating WHERE starttime >= DATE_ADD(CURRENT_DATE(), 
INTERVAL 11 DAY);" | mysql mythconverg 
echo "DELETE FROM programgenres WHERE starttime >= DATE_ADD(CURRENT_DATE(), 
INTERVAL 11 DAY);" | mysql mythconverg
echo "DELETE FROM credits WHERE starttime >= DATE_ADD(CURRENT_DATE(), 
INTERVAL 11 DAY);" | mysql mythconverg 

This removes my program data for anything older than 11 days and then when 
mythfilldatabase runs, it re-gets that data.

Thanks again!
Cam
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20050707/2db664b6/attachment.htm


More information about the mythtv-users mailing list