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
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
