[mythtv-users] Help: Upcoming recordings list suddenly blank!

[John Greene]

mattjackets wrote:
>/ On Tue, 06 Mar 2007 23:12:34 -0800, "Bruce Markey" <bjm at lvcm.com <http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users>> said:
/>>/ matt wrote:
/>>/ ...
/>>>/ I've been having database table "crashes" lately, mostly in the
/>>>/ 'program' table, but I just repaired the 'recordedseek' table today.
/>>/ $ killall mythbackend
/>>/ $ killall mythfrontend
/>>/ $ mysqlcheck -c -u mythtv -pmythtv mythconverg
/>>/ $ mysql -u mythtv -pmythtv mythconverg
/>>/ mysql> truncate table program;
/>>/ mysql> truncate table programrating;
/>>/ mysql> truncate table programgenre;
/>>/ mysql> truncate table credits;
/>>/ mysql> quit
/>>/ $ mythfilldatabase
/>>/ $ mysqlcheck -c -u mythtv -pmythtv mythconverg
/>>/ $ mysqlcheck -o -u mythtv -pmythtv mythconverg
/>>/ $ mythbackend -v schedule
/>>/
/>>/ --  bjm
/>/ 
/>/ Bruce,
/>/ Thanks for the tips, I'll remember them in the future.  Unfortunately,
/>/ they didn't help directly.  But running the backend at the console
/>/ (instead of /etc/init.d/mythbackend start) allowed me to see that
/>/ /dev/video0 went missing!  Once I got ivtv back up and running, all was
/>/ well.  Thanks again for your tips!
/
I didn't expect that this was the sole solution to your problem.
However, you mentioned that you were concerned about program
table corruption. The intent was to fix corruption of the TV
listings then see what the scheduler was or wasn't doing.

Normally, nothing scheduled is because there are no inputs on
cards associated with a video source that has channels and TV
listings. Lots of things could be wrong. In your case it couldn't
find the card but it could have been any number of things.

<snip />

Hello,

I came accross this thread as I tried to solve the exact same problem that just popped up on my mythbox.  Unfortunately, the DB maintenance 
stuff didn't help, and the video device is correct.  What are some other things I can look at?  I suspect the problem started when I tried to 
create a "custom" schedule using mythweb.

Thanks,

John

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070406/8981f974/attachment.htm