[mythtv-users] Only seing channel from one source?

[Jan Johansson]

>mysql> SELECT sourceid,channum,name,callsign,xmltvid FROM channel
>ORDER BY callsign;
>
>You will get a listing that will immediately show channels with
>matching CALLSIGNS next to each other, with or withouth their XMLTVID.

I now have as below (which seem right).

But, encoder 1 still does not get used. And I do seem to have channel
data for the various sources (Look at end of post for example)


mysql> SELECT chanid,sourceid,channum,name,callsign,xmltvid FROM channel
ORDER BY callsign;
+--------+----------+---------+---------------------------+-------------
---------+-----------------------------------+
| chanid | sourceid | channum | name                      | callsign
| xmltvid                           |
+--------+----------+---------+---------------------------+-------------
---------+-----------------------------------+
|     97 |        6 | 97      | Aftonbladet TV7           | Aftonbladet
TV7      | tv7.aftonbladet.se                |
|     24 |        3 | 24      | Animal Planet             | Animal
Planet        | nordic.animalplanet.discovery.com |
|     18 |        3 | 18      | Discovery Channel         | Discovery
Channel    | nordic.discovery.com              |
|     19 |        3 | 19      | Discovery Civilisation    | Discovery
Civilisati | nordic.civilisation.discovery.com |
|     21 |        3 | 21      | Discovery Travel & Living | Discovery
Travel & L | nordic.travel.discovery.com       |
|     35 |        3 | 35      | Disney Channel            | Disney
Channel       | disneychannel.se                  |
|   3001 |        3 | 20      | Discovery Science         | DISSC
| nordic.science.discovery.com      |
|   1001 |        1 | 9       | Kanal 5                   | Kanal 5
| kanal5.se                         |
|      9 |        3 | 9       | Kanal 5                   | Kanal 5
| kanal5.se                         |
|     14 |        3 | 14      | MTV Nordic                | MTV Nordic
| nordic.mtve.com                   |
|     34 |        3 | 34      | Nickelodeon               | Nickelodeon
| nickelodeon.se                    |
|     99 |        6 | 99      | SVT Extra                 | SVT Extra
| extra.svt.se                      |
|   1002 |        1 | 1       | SVT1                      | SVT1
| svt1.svt.se                       |
|   6000 |        6 | 1       | SVT1                      | SVT1
| svt1.svt.se                       |
|      1 |        3 | 1       | SVT1                      | SVT1
| svt1.svt.se                       |
|   6001 |        6 | 2       | SVT2                      | SVT2
| svt2.svt.se                       |
|      2 |        3 | 2       | SVT2                      | SVT2
| svt2.svt.se                       |
|   1003 |        1 | 2       | SVT2                      | SVT2
| svt2.svt.se                       |
|     30 |        3 | 30      | SVT24                     | SVT24
| svt24.svt.se                      |
|     98 |        6 | 98      | SVT24                     | SVT24
| svt24.svt.se                      |
|   1004 |        1 | 3       | TV3                       | TV3
| tv3.viasat.se                     |
|      3 |        3 | 3       | TV3                       | TV3
| tv3.viasat.se                     |
|   1005 |        1 | 4       | TV4                       | TV4
| tv4.se                            |
|   6002 |        6 | 4       | TV4                       | TV4
| tv4.se                            |
|      4 |        3 | 4       | TV4                       | TV4
| tv4.se                            |
|      7 |        3 | 7       | TV4 Fakta                 | TV4 Fakta
| fakta.tv4.se                      |
|      8 |        3 | 8       | TV4 Film                  | TV4 Film
| film.tv4.se                       |
|   3002 |        1 | 6       | TV4 Plus                  | TV4 Plus
| plus.tv4.se                       |
|      6 |        3 | 6       | TV4 Plus                  | TV4 Plus
| plus.tv4.se                       |
|      5 |        3 | 5       | TV400                     | TV400
| tv400.tv4.se                      |
|     10 |        3 | 10      | TV6                       | TV6
| tv6.viasat.se                     |
|   6003 |        6 | 10      | TV6                       | TV6
| tv6.viasat.se                     |
|   1006 |        1 | 10      | TV6                       | TV6
| tv6.viasat.se                     |
|     12 |        3 | 12      | VH1                       | VH1
| vh1.com                           |
|     11 |        3 | 11      | Viasat Nature/Crime       | Viasat
Nature/Crime  | nature.viasat.se                  |
+--------+----------+---------+---------------------------+-------------
---------+-----------------------------------+
35 rows in set (0.00 sec)

mysql>


mysql> select count(*) from program where chanid=1006;
+----------+
| count(*) |
+----------+
|      316 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from program where chanid=6003;
+----------+
| count(*) |
+----------+
|      286 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from program where chanid=10;
+----------+
| count(*) |
+----------+
|      316 |
+----------+
1 row in set (0.01 sec)

mysql>

-- 
Meddelandet har kontrollerats mot virus samt skadligt 
innehåll av MailScanner och förmodas vara säkert.