Ticket #11509: incorrect channel.txt

File incorrect channel.txt, 2.5 KB (added by ccoager@…, 13 years ago)

incorrect channel

Line 
1And 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.
2
3mysql> select * from channel where channum=576;
4Empty set (0.00 sec)
5
6mysql> select * from channel where channum=595;
7+--------+---------+--------+----------+----------+----------------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+
8| 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 |
9+--------+---------+--------+----------+----------+----------------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+
10| 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 |
11| 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 |
12+--------+---------+--------+----------+----------+----------------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+
132 rows in set (0.00 sec)
14