[mythtv-users] Channel issues

[Cory Coager]

I was having this issue on version 0.25 and recently upgraded to 
0.26.0_p2013022 (Gentoo) in hopes of fixing it, but no luck.  I am using 
the HDHR Prime with Verizon FIOS and Schedules Direct.  My issue is I 
have missing channels, duplicate channels and channels with the wrong 
channel numbers.

I tried re-adding the video sources after I upgraded.  Did a 
mythfilldatabase and grabbed all the channels from Schedules Direct.

Schedules Direct shows channel 10 in my line up however this is missing 
from the database.
mysql> select * from channel where channum=10;
Empty set (0.00 sec)

I have duplicate channels:
mysql> select * from channel where channum=6;
+--------+---------+--------+----------+----------+------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+
| chanid | channum | freqid | sourceid | callsign | name | icon | 
finetune | videofilters | xmltvid | recpriority | contrast | brightness 
| colour | hue   | tvformat | visible | outputfilters | useonairguide | 
mplexid | serviceid | tmoffset | atsc_major_chan | atsc_minor_chan | 
last_record         | default_authority | commmethod | iptvid |
+--------+---------+--------+----------+----------+------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+
|   1506 | 6       | 6      |        1 | WRGBDT   | WRGBDT (WRGB-DT) 
|      |     NULL |              | 34968   |           0 |    32768 
|      32768 |  32768 | 32768 | Default  |       1 | |             0 |   
32767 |         0 |        0 |               6 |               0 | 
0000-00-00 00:00:00 | |         -1 |   NULL |
|   1006 | 6       | 6      |        1 | WRGBDT   | WRGBDT (WRGB-DT) 
|      |     NULL |              | 34968   |           0 |    32768 
|      32768 |  32768 | 32768 | Default  |       1 | |             0 |   
32767 |         0 |        0 |               6 |               0 | 
0000-00-00 00:00:00 | |         -1 |   NULL |
+--------+---------+--------+----------+----------+------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+
2 rows in set (0.00 sec)

And I have channels with the wrong channel number.  For instance, FIOS 
lists channel YESHDNY as 576 in their program guide, Schedules Direct 
shows channel 576 but mythtv database shows it as channel 595.  There is 
no channel 595 on FIOS or Schedules Direct.
mysql> select * from channel where channum=576;
Empty set (0.00 sec)

mysql> select * from channel where channum=595;
+--------+---------+--------+----------+----------+----------------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+
| chanid | channum | freqid | sourceid | callsign | 
name                       | icon | finetune | videofilters | xmltvid | 
recpriority | contrast | brightness | colour | hue   | tvformat | 
visible | outputfilters | useonairguide | mplexid | serviceid | tmoffset 
| atsc_major_chan | atsc_minor_chan | last_record         | 
default_authority | commmethod | iptvid |
+--------+---------+--------+----------+----------+----------------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+
|   1576 | 595     | 595    |        1 | YESHDNY  | Yes Network HD (24/7 
feed) |      |     NULL |              | 46275   |           0 |    
32768 |      32768 |  32768 | 32768 | Default  |       1 |               
|             0 |   32767 |         0 |        0 |             595 
|               0 | 0000-00-00 00:00:00 |                   |         -1 
|   NULL |
|   1595 | 595     | 595    |        1 | YESHDNY  | Yes Network HD (24/7 
feed) |      |     NULL |              | 46275   |           0 |    
32768 |      32768 |  32768 | 32768 | Default  |       1 |               
|             0 |   32767 |         0 |        0 |             595 
|               0 | 0000-00-00 00:00:00 |                   |         -1 
|   NULL |
+--------+---------+--------+----------+----------+----------------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+
2 rows in set (0.00 sec)


Why am I having so many problems?  How do I fix this?