Did some testing tonight and I think my problem may be in the database.
I deleted all my channels and added the first set of channels on the 537 MHz
transport. I restarted the backend and verified that all the channels worked.
I checked the database to see what showed up in the tables.
Code:
mysql> select * from 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 |
+--------+---------+--------+----------+----------+--------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+----------+-----------------+-----------------+
| 1031 | 231 | NULL | 1 | WPTADT | WPTADT (WPTA-DT) | | NULL | | 35236 | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 0 | 1 | | 0 | 1 | 3 | NULL | 0 | 3 | 1 |
| 1041 | 233 | NULL | 1 | WANEDT | WANEDT (WANE-DT) | | NULL | | 35324 | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 0 | 1 | | 0 | 1 | 4 | NULL | 0 | 4 | 1 |
| 1051 | 251 | NULL | 1 | WANEDT2 | WANEDT2 (WANE-DT2) | | NULL | | 42553 | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 0 | 1 | | 0 | 1 | 5 | NULL | 0 | 5 | 1 |
+--------+---------+--------+----------+----------+--------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+----------+-----------------+-----------------+
3 rows in set (0.02 sec)
Then I went back into the mythtv-setup and deleted all the channels and
scanned the 543 MHz transport. Again I restarted the backend and verified
that all the channels worked. Here's the sql table for those channels.
Code:
mysql> select * from 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 |
+--------+---------+--------+----------+----------+--------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+----------+-----------------+-----------------+
| 1031 | 232 | NULL | 1 | WISEDT | WISEDT (WISE-DT) | | NULL | | 34615 | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 0 | 1 | | 0 | 2 | 3 | NULL | 0 | 3 | 1 |
| 1071 | 243 | NULL | 1 | WFWADT4 | WFWADT4 (WFWA-DT4) | | NULL | | 49057 | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 1 | 1 | | 0 | 2 | 7 | NULL | 0 | 7 | 1 |
| 1061 | 242 | NULL | 1 | WFWADT3 | WFWADT3 (WFWA-DT3) | | NULL | | 49053 | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 1 | 1 | | 0 | 2 | 6 | NULL | 0 | 6 | 1 |
| 1011 | 39.2 | NULL | 1 | WFWA-D2 | WFWA-D2 | | NULL | | 43837 | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 1 | 1 | | 0 | 2 | 1 | NULL | 0 | 1 | 1 |
| 1021 | 240 | NULL | 1 | WFWADT | WFWADT (WFWA-DT) | | NULL | | 43720 | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 1 | 1 | | 0 | 2 | 2 | NULL | 0 | 2 | 1 |
+--------+---------+--------+----------+----------+--------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+----------+-----------------+-----------------+
5 rows in set (0.00 sec)
Finally I went back into mythv-setup and re-scanned the 537 MHz
transport. As usual one of the channels gets overwritten. So instead of 8
unique channels I now have 7. Here's the sql table now.
Code:
mysql> select * from 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 |
+--------+---------+--------+----------+----------+--------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+----------+-----------------+-----------------+
| 1031 | 231 | NULL | 1 | WISE-HD | WISE-HD | | NULL | | 35236 | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 0 | 1 | | 0 | 2 | 3 | NULL | 0 | 3 | 1 |
| 1041 | 233 | NULL | 1 | WANEDT | WANEDT (WANE-DT) | | NULL | | 35324 | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 0 | 1 | | 0 | 1 | 4 | NULL | 0 | 4 | 1 |
| 1051 | 251 | NULL | 1 | WANEDT2 | WANEDT2 (WANE-DT2) | | NULL | | 42553 | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 0 | 1 | | 0 | 1 | 5 | NULL | 0 | 5 | 1 |
| 1021 | 240 | NULL | 1 | WFWADT | WFWADT (WFWA-DT) | | NULL | | 43720 | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 0 | 1 | | 0 | 2 | 2 | NULL | 0 | 2 | 1 |
| 1011 | 39.2 | NULL | 1 | WFWADT2 | WFWADT2 (WFWA-DT2) | | NULL | | 43837 | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 0 | 1 | | 0 | 2 | 1 | NULL | 0 | 1 | 1 |
| 1061 | 242 | NULL | 1 | WFWADT3 | WFWADT3 (WFWA-DT3) | | NULL | | 49053 | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 0 | 1 | | 0 | 2 | 6 | NULL | 0 | 6 | 1 |
| 1071 | 243 | NULL | 1 | WFWADT4 | WFWADT4 (WFWA-DT4) | | NULL | | 49057 | 0 | 32768 | 32768 | 32768 | 32768 | ATSC | 0 | 1 | | 0 | 2 | 7 | NULL | 0 | 7 | 1 |
+--------+---------+--------+----------+----------+--------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+----------+-----------------+-----------------+
7 rows in set (0.00 sec)
What I noticed is that the two problem channels have the same
chanid, serviceid, and atsc_major_chan. So if I change those values
between adding the two sets of channels, will this eliminate the
overwriting? I'm not an sql expert, so I don't want to hose my database.
Sorry about the side scrolling.
_________________
Backend R5E50
P4 1.3 - 384MB, 250GB HD, HD5000AV, PVR150 non MCE
Frontend R5E50
EPIA M1000 - 512MB, 40GB HD, Streamzap
KnoppMyth Folding Team Stats