| 1 | I have duplicate channels:
|
|---|
| 2 |
|
|---|
| 3 | mysql> select * from channel where channum=6;
|
|---|
| 4 | +--------+---------+--------+----------+----------+------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+
|
|---|
| 5 | | 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 |
|
|---|
| 6 | +--------+---------+--------+----------+----------+------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+
|
|---|
| 7 | | 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 |
|
|---|
| 8 | | 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 |
|
|---|
| 9 | +--------+---------+--------+----------+----------+------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+
|
|---|
| 10 | 2 rows in set (0.00 sec)
|
|---|
