<div dir="ltr"><br><br><div class="gmail_quote">2008/7/22 Nick Morrott <<a href="mailto:knowledgejunkie@gmail.com">knowledgejunkie@gmail.com</a>>:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
2008/7/22 Roy Stogner <<a href="mailto:roy@stogners.org">roy@stogners.org</a>>:<br>
<div class="Ih2E3d">> Does anyone have any other suggestions? I'd really rather not have to<br>
> uninstall and reinstall mythtv from scratch; even if I wanted to<br>
> re-enable all my recording schedules by hand, I don't know how I could<br>
> do a reinstall without losing the metadata for the shows I've<br>
> currently got recorded and saved.<br>
<br>
</div>Once you have some reassurance that the MythTV database in healthy,<br>
and before trying more drastic measures, follow:<br>
<br>
<a href="http://www.gossamer-threads.com/lists/mythtv/users/264034#264034" target="_blank">http://www.gossamer-threads.com/lists/mythtv/users/264034#264034</a><br>
<br>
--<br>
Nick Morrott<br>
<br></blockquote></div><br>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:<br>
<br>$sudo mysqlcheck -umythtv -p mythconverg | more<br><br>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.<br>
<br>If any of them are corrupt, use the repair parameter to see if the error can be fixed<br><br>$sudo mysqlcheck -r -umythtv -p mythconverg | more<br><br>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.<br>
<br>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...<br>
<br>HTH!<br><br>Mark P.<br></div>