Al Puzzuoli wrote:
Unfortunately, it may be a day or two before I can ask someone to look
at Mythfrontend. If I could have checked it would have done it first
thing. Is there any other way to verify the integrity of the data, or
to just rebuild the database altogether that doesn't involve using
mythfrontend?
How about:
mysql -u mythtv -pmythtv mythconverg \
-e 'SELECT COUNT(*) FROM program WHERE starttime > CURRENT_TIMESTAMP()'
If this gives you any value other than 0, you have data, so it gives us
a place to start.
Mike
----- Original Message ----- From: "Michael T. Dean"
<[EMAIL PROTECTED]>
To: "Discussion about mythtv" <[email protected]>
Sent: Monday, October 31, 2005 10:07 AM
Subject: Re: [mythtv-users] No data in mythweb program listings?
Al Puzzuoli wrote:
I'm suddenly having an issue with mythweb where in all channels are
showing "NO DATA". According to the backend status, I should have
guide data until 2005-11-14 03:12 (14 days).
Do you have listing in mythfrontend? Direct evidence trumps indirect.
I've run mythfilldatabase several times and am getting the same
results. My first thought was database corruption, but I ran
mysqlcheck and didn't turn up any errors in mythconverg.
First figure out if there's /any/ data at all.
Mike
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
