[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