[mythtv-users] after database rebuild, cannot change channels

Greg Woods greg at gregandeva.net
Sun Sep 25 20:12:41 UTC 2005


>From the "database gone south" thread, we advance boldly into the
future :-)

I ended up having to completely redo the database. I never could figure
out what was wrong with it. I dumped the current contents, then got into
mysql and did the "drop database mythconverg;
source /usr/share/doc/mythtv-0.18.1/database/mc.sql" to recreate empty
tables (pretty much what is described in the MySQL chapter of Jarod's
guide). Then I went through mythtv-setup on the master backend (MBE),
manually restoring the capture card, video sources, and input settings.
Then of course I was missing the information to connect the files
in /video to what recorded programs they were, so I reloaded (from a
database dump taken before this) the "oldrecorded", "recorded",
"recordedprogram", and "videometadata" tables.  After doing all this,
everything appears to be good (almost) on the MBE. I can watch TV (other
than not being able to change channels), I can view the saved
recordings, I can schedule recordings (apparently), mythweb works, the
guide works. 

The problem is now I cannot change channels in mythfrontend. I *can*
change channels with ptune.ui.pl script, and the OSD shows no data, so
I'm pretty sure this is still some sort of database problem. I've just
run to the end of the rope here, I cannot get my database back and I
don't know what else to try. I have rerun mythfilldatabase and restarted
mythbackend several times with no effect. The backend produces the
following error when I try to change channels:

2005-09-25 13:59:37.866 Channel(/dev/video0): CheckChannel failed.
Please verify channel "6" in the "setup" Channel Editor.

I have searched the archives for this error message, but none of those
threads appear to describe my problem.

Is there any way to just recreate the database from scratch? Is it
documented how to do this anywhere other than the brief description in
Jarod's guide (which I already tried?) I seem to be out of options and
my system is fairly useless until I can fix this problem.

--Greg




More information about the mythtv-users mailing list