[mythtv-users] HDHomeRun cable TV channel setup problem/frustration

[Billy Macdonald]

On 9/27/07, f-win at gmx.net <f-win at gmx.net> wrote:
> Thanks for the explanation!
>
> The other major issue are the missing channels. E.g. the hdhomerun_config scan finds the follwoing unencrypted channel
>
> SCANNING: 621000000 (us-cable:90, us-irc:90)
> LOCK: qam256 (ss=90 snq=100 seq=100)
> PROGRAM: 1: 1008.0
> PROGRAM: 2: 0.0 (encrypted)
> ....
>
> But the channel does not show up in mythtv after the scan. Maybe somebody understands the mythtv-setup log messages and can tell me why the channel does not get added?
>
> This is just an example but there are a lot more missing:
>



> 2007-09-26 20:05:29.919 MSqlQuery: UPDATE channel SET mplexid         = 14,   serviceid       = 1,     atsc_major_chan = 1008, atsc_minor_chan = 0,     callsign        = '',  name            = '',          channum         = '1008.0',   freqid          = 90,        tvformat        = NULL,  sourceid        = 3   WHERE chanid=13080
> 2007-09-26 20:05:29.923 Updating  1008-0 as 1008.0 on QAM-256 Channel 90 (90)


Hmmm,  I notice that SQL is an UPDATE.  I wonder if it's finding
multiple "1008.0" channels and keeps overwriting the previous with the
most recent version.


Here is what I would try doing.  Run the scan with different options
for the minimal updates and see if that makes a difference.

Next, try running the scan, and then in the db, change the channum,
atsc_major_chan, and atsc_minor_chan for 1008.0 to something else that
doesn't already exist.  Just change it to 1008.1 or something (and the
atsc_minor_chan to 1).  You seem to be OK with messing with the DB,
but if not, maybe this isn't the best idea.  Back it up first.

Rinse & repeat until no new channels are found.  I'd keep it on
minimal updates.  Note: I haven't tried this, just throwing darts.

Good Luck.

Billy

The query below makes me think that it's finding the chanid based on
these values and that's where you're having problems.  The atsc stuff
doesn't actually matter when it comes time to tune the channel for QAM
I don't think.  The worst though is that it doesn't work, which is
where you're at now.

MSqlQuery: SELECT chanid FROM channel,dtv_multiplex WHERE
channel.sourceid          = 3 AND       atsc_major_chan
   = 1008 AND       atsc_minor_chan           = 0 AND
dtv_multiplex.transportid = 34 AND       dtv_multiplex.mplexid     =
14 AND       d
tv_multiplex.sourceid    = channel.sourceid AND
dtv_multiplex.mplexid     = channel.mplexid