[mythtv-users] Missing HD channels and finding them
scram69
scram69 at gmail.com
Wed Apr 23 17:55:45 UTC 2008
On Tue, Apr 22, 2008 at 8:10 PM, Seth Heckard <seth.lists at gmail.com> wrote:
> On Tue, Apr 22, 2008 at 10:35 PM, Bob <mythtv at cox.net> wrote:
> > I occasionally have this problem. There is a forum where I can get the
> > information I need, then I use the following SQL to insert the channel
> > manually:
> >
> > INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`,
> > `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`,
> > `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`,
> > `commfree`, `visible`, `outputfilters`, `useonairguide`, `mplexid`,
> > `serviceid`, `atscsrcid`, `tmoffset`, `atsc_major_chan`,
> > `atsc_minor_chan`) VALUES
> > (2710,'710','76',2,'KSAZ DT','FOX
> > HD','/home/mythtv/.mythtv/channels/fox_affiliate.gif',0,'','21209',0,32768,32768,32768,32768,'',0,1,'',0,19,1,NULL,0,0,0);
> >
> > Study this carefully. You need to set the "chanid" based on the encoder
> > you are using, you'll probably have to poke around in your database to
> > figure this out.
> >
> > The next tricky part is the mplexid. You have to look at the
> > dtv_multiplex table to determine which frequency corresponds to the
> > desired channel number.
>
> Thanks... this should point me in the right direction. I had to do
> something similar 3 years ago with the local NBC affiliate not being
> found in the scan, but myth didn't have the fancy channel scanner back
> then.
>
Last time Comcast did this to me (IIRC they moved the NBC-HD freq), I
found phpMyadmin extraordinarily helpful. I found the new channel
position using my TV as you did, and then checking and resetting the
necessary fields in the channels database was a 2-minute job.
More information about the mythtv-users
mailing list