[mythtv-users] HDTV reception via Cable

Steven Adeff adeffs.mythtv at gmail.com
Mon Apr 3 20:52:17 UTC 2006


On 4/3/06, R. G. Newbury <newbury at mandamus.org> wrote:
> Jeffrey R. Born wrote:
> > I don't have anything in the dtv_multiplex table after going through all
> > the setup for a pcHDTV card.  I can't seem to find a place to reimport
> > information from a channels.conf.  Not even sure that would load that
> > table.  I found this because 1 HD playback in myth is not working yet
> > and I went hunting in the lists for missed steps.  It seemed reasonable
> > to follow Geoff's advice and to verify and modify the information in
> > this table to match the channels conf information.
> >
> >
> >
> > Any ideas how to rebuild this information?
>
> This is in the archive already.....
> Open mysql to the mythconverg database
>
> #mysql -u mythtv -pmythtv mythconverg;
>  > describe [tablename] will show you the names of the columns in a table
> Then
>
>  >select * from dtv_multiplex;
>
> I assume your sourceid is "2": that is your chanid's are like 2118.
> IF there are no entries, then:
>
>  >insert into dtv_multiplex (sourceid, frequency, modulation) values
> ("2","525000000","QAM_256);
>
> Repeat for each frequency. I only have 9 rows in this table.
>
> IF there are entries and you want to blow them all away, you can:
>
>  > delete from dtv_multiplex where fec ="AUTO"; (or any other column
> where all the values are the same....Then repeat as above.
>
> To change the channel table, you need something like:
>
>  > update channel set sourceid="2", mplexid="1", serviceid="34" where
> chanid = 2118;
>
> etc....(29 times or whatever the number is!. Take your time and be
> careful in making the entries. I jumped a line the first time although
> that was no apparent for a while...when I could not tune a channel.
> Then I made a printout of channels.conf, checked the mplexid entries
> carefully and worked down line by line entering the channel info.
>
> Still took me about 2 weeks to actually get the callsigns matched up
> properly. I get 6 or 7 CBC feeds and 5 CTV feeds, and most of the time
> they have the same stuff playing, so it was a matter of actually
> watching commercials (ugh!) to figure out where the station was and then
> adjust the callsigns properly!
>
> Geoff

Which is why I created:
http://wiki.mythtv.com/wiki/index.php/Working_QAM_cable_layout

so people don't have to go through the process when other kind souls
already have...

--
Steve


More information about the mythtv-users mailing list