[mythtv-users] No data in mythweb program listings?

[Michael T. Dean]

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" 
> <mtdean at thirdcontact.com>
> To: "Discussion about mythtv" <mythtv-users at mythtv.org>
> 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
>