[mythtv-users] Help! Can't change channels after upgrade

[Nick Morrott]

On 11/06/2008, peter at vanderwal.us <peter at vanderwal.us> wrote:
> >>> The 'freqid' field is what the tuning script is being passed by the
>  >> backend to change channel on the STB. The 'channum' field is what you
>  >> would enter in mythfrontend on the remote to change channel. The
>  >> 'chanid' field needs to be unique for each channel you have
>  >> configured.
>  >>
>  >
>  > Hmm, that might be the problem.  I'm at work right now, but I'm pretty
>  > sure the Freqid is blank.
>  >
>
>
> Nope, I was wrong, the freqid is the same as channel number, it's
>  videofilters that's blank.
>
>  FWIW I've run "optimize tables" from both mythweb and from Mythtv
>  (Mythdora tools), it doesn't help.  Ditto for "repair tables"
>  I think I'm going to have to bite the bullet and copy off all of my data
>  (800+ GB, yuk) and do a fresh install.

That's a bit drastic! If you want, export the channels table from your
database, using:

# mysqldump mythconverg channel

and mail it to me. I can't promise anything, but if I see anything
odd, I'll let you know.

-- 
Nick Morrott

MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin