[mythtv] HDHomeRun QAM scan bug (overwriting channels)
Florian
florian.winterstein at gmail.com
Sat Sep 29 06:22:06 UTC 2007
---------- Forwarded message ----------
From: Florian <florian.winterstein at gmail.com>
Date: Sep 27, 2007 2:10 PM
Subject: HDHomeRun QAM scan bug (overwriting channels)
To: mythtv-dev at mythtv.org
Hello experts,
I need some help from the experts.
The problem is the mythtv-setup channel scan on the HDHomeRun does not
add all the available channels.
The "hdhomerun_config 1011C08C scan 0 tuner0.txt" scan finds a lost of
programs like this
...
SCANNING: 585000000 (us-cable:84, us-irc:84)
LOCK: qam256 (ss=90 snq=100 seq=100)
PROGRAM: 1: 1008.0 (no data)
PROGRAM: 2: 1008.0 (no data)
PROGRAM: 11: 1008.0
PROGRAM: 31: 0.0 (encrypted)
...
SCANNING: 621000000 (us-cable:90, us-irc:90)
LOCK: qam256 (ss=90 snq=100 seq=100)
PROGRAM: 1: 1008.0
...
The problem for mythtv seems to be the 1008.0 since it creates a
strange entry into the channels table:
mysql> select chanid,channum,freqid,callsign,tvformat,mplexid,serviceid,atsc_major_chan,atsc_minor_chan
from channel where sourceid = 3;
+--------+---------+--------+--------------+----------+---------+-----------+-----------------+-----------------+
| chanid | channum | freqid | callsign | tvformat | mplexid |
serviceid | atsc_major_chan | atsc_minor_chan |
+--------+---------+--------+--------------+----------+---------+-----------+-----------------+-----------------+
...
| 13080 | 1008.0 | 115 | | | 66 |
52 | 1008 | 0 |
... (please see the full table at the end of this mail)
A look at the mythtv-setup log messages shows me that mythtv finds all
the channels displayed by the hdhomerun program but it overwrites the
very same database row:
> cat setup.log | grep UPDATE
...
2007-09-26 20:05:13.060 MSqlQuery: UPDATE channel SET mplexid
= 8, serviceid = 11, atsc_major_chan = 1008,
atsc_minor_chan = 0, callsign = '', name = '',
channum = '1008.0', freqid = 84,
tvformat = NULL, sourceid = 3 WHERE chanid=13080
2007-09-26 20:05:13.072 MSqlQuery: UPDATE channel SET mplexid
= 8, serviceid = 1, atsc_major_chan = 1008,
atsc_minor_chan = 0, callsign = '', name = '',
channum = '1008.0', freqid = 84,
tvformat = NULL, sourceid = 3 WHERE chanid=13080
2007-09-26 20:05:13.082 MSqlQuery: UPDATE channel SET mplexid
= 8, serviceid = 2, atsc_major_chan = 1008,
atsc_minor_chan = 0, callsign = '', name = '',
channum = '1008.0', freqid = 84,
tvformat = NULL, sourceid = 3 WHERE chanid=13080
...
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
The "minimum updates" or "rename to match" tables don't make a difference here.
I am happy to send you the full log files.
Do you know what is going on here and how to fix it?
Please help me :-)
Thanks,
-Florian
Here is the full DB table
mysql> select chanid,channum,freqid,callsign,tvformat,mplexid,serviceid,atsc_major_chan,atsc_minor_chan
from channel where sourceid = 3;
+--------+---------+--------+--------------+----------+---------+-----------+-----------------+-----------------+
| chanid | channum | freqid | callsign | tvformat | mplexid |
serviceid | atsc_major_chan | atsc_minor_chan |
+--------+---------+--------+--------------+----------+---------+-----------+-----------------+-----------------+
| 3999 | 99#9 | 99 | UNKNOWN99#9 | Default | 53 |
3 | 0 | 0 |
| 3997 | 99#7 | 99 | UNKNOWN99#7 | Default | 53 |
27 | 0 | 0 |
| 3830 | 83#0 | 83 | UNKNOWN83#0 | Default | 39 |
2 | 0 | 0 |
| 3831 | 83#1 | 83 | UNKNOWN83#1 | Default | 39 |
3 | 0 | 0 |
| 13080 | 1008.0 | 115 | | | 66 |
52 | 1008 | 0 |
| 3871 | 87#1 | 87 | UNKNOWN87#1 | Default | 43 |
128 | 0 | 0 |
| 3872 | 87#2 | 87 | UNKNOWN87#2 | Default | 43 |
129 | 0 | 0 |
| 3873 | 87#3 | 87 | UNKNOWN87#3 | Default | 43 |
130 | 0 | 0 |
| 3874 | 87#4 | 87 | UNKNOWN87#4 | Default | 43 |
131 | 0 | 0 |
| 3875 | 87#5 | 87 | UNKNOWN87#5 | Default | 43 |
132 | 0 | 0 |
| 3876 | 87#6 | 87 | UNKNOWN87#6 | Default | 43 |
133 | 0 | 0 |
| 3877 | 87#7 | 87 | UNKNOWN87#7 | Default | 43 |
134 | 0 | 0 |
| 3878 | 87#8 | 87 | UNKNOWN87#8 | Default | 43 |
135 | 0 | 0 |
| 3879 | 87#9 | 87 | UNKNOWN87#9 | Default | 43 |
136 | 0 | 0 |
| 3880 | 87#10 | 87 | UNKNOWN87#10 | Default | 43 |
137 | 0 | 0 |
| 3881 | 87#11 | 87 | UNKNOWN87#11 | Default | 43 |
138 | 0 | 0 |
| 3882 | 87#12 | 87 | UNKNOWN87#12 | Default | 43 |
142 | 0 | 0 |
| 3883 | 87#13 | 87 | UNKNOWN87#13 | Default | 43 |
143 | 0 | 0 |
| 3884 | 87#14 | 87 | UNKNOWN87#14 | Default | 43 |
144 | 0 | 0 |
| 3991 | 99#1 | 99 | UNKNOWN99#1 | Default | 53 |
17 | 0 | 0 |
| 3992 | 99#2 | 99 | UNKNOWN99#2 | Default | 53 |
25 | 0 | 0 |
| 3993 | 99#3 | 99 | UNKNOWN99#3 | Default | 53 |
21 | 0 | 0 |
| 4000 | 99#10 | 99 | UNKNOWN99#10 | Default | 53 |
11 | 0 | 0 |
| 4001 | 99#11 | 99 | UNKNOWN99#11 | Default | 53 |
1 | 0 | 0 |
| 4055 | 105#5 | 105 | UNKNOWN105#5 | Default | 56 |
19 | 0 | 0 |
| 4056 | 105#6 | 105 | UNKNOWN105#6 | Default | 56 |
20 | 0 | 0 |
| 4059 | 105#9 | 105 | UNKNOWN105#9 | Default | 56 |
22 | 0 | 0 |
| 4124 | 112#4 | 112 | UNKNOWN112#4 | Default | 63 |
63 | 0 | 0 |
+--------+---------+--------+--------------+----------+---------+-----------+-----------------+-----------------+
28 rows in set (0.00 sec)
More information about the mythtv-dev
mailing list