[mythtv-users] "You Haven't Scheduled Any Programs"

Mark Parsons mythtv.org at thesanitarium.org.uk
Tue Jul 22 21:33:34 UTC 2008


2008/7/22 Nick Morrott <knowledgejunkie at gmail.com>:

> 2008/7/22 Roy Stogner <roy at stogners.org>:
> > Does anyone have any other suggestions?  I'd really rather not have to
> > uninstall and reinstall mythtv from scratch; even if I wanted to
> > re-enable all my recording schedules by hand, I don't know how I could
> > do a reinstall without losing the metadata for the shows I've
> > currently got recorded and saved.
>
> Once you have some reassurance that the MythTV database in healthy,
> and before trying more drastic measures, follow:
>
> http://www.gossamer-threads.com/lists/mythtv/users/264034#264034
>
> --
> Nick Morrott
>
>
Nick mentions checking that the db is healthy, but nobody has mentioned how;
I experienced a similar problem recently, albeit due to a completely
different set of circumstances - and it turned out that one of my tables was
corrupt; it had 17 rows, but was reporting 0, and therefore MythTV wasn't
showing any recording schedules, and I was unable to schedule anything else.
Apologies if this is teaching you to suck eggs, as it were, but it took me
ages to try and find out how to fix my seemingly identical problem:

$sudo mysqlcheck -umythtv -p mythconverg | more

will prompt for your mythtv password, and will then spool off a list of all
the tables in the mythconverg database, along with a message saying whether
it's OK or not.

If any of them are corrupt, use the repair parameter to see if the error can
be fixed

$sudo mysqlcheck -r -umythtv -p mythconverg | more

Unfortunately I didn't keep a record of the corrupted table - I think that
it was mythconverg.recordmatch - but running this quick command fixed the
problem and all of my previous recording schedules re-appeared, and I was
able to schedule new stuff.

If this doesn't help, then as has been mentioned elsewhere it sounds like it
may be time for a delve into using UDEV to make an unchanging reference link
to your device, and perhaps to remove and re-add your connections and stuff
in mythtv-setup - not much fun in my experience...

HTH!

Mark P.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080722/51a0c215/attachment.htm 


More information about the mythtv-users mailing list