[mythtvnz] Freeview DVB-T Channel Changes

[tortise]

On 2/09/2013 5:33 p.m., Tony Sauri wrote:
> On 02/09/13 16:43, Nick Rout wrote:
>>
>> Cheers. These bloody plus one channels a waste of bandwidth for us myth
>> users aren't they?
>>
>
> In general you are right ( if you have at least 3 tuners) but recently I
> have been specifying a +1 channel where I was more concerned about disk
> usage than replay quality :-)ly the

Can also be useful where realised missed a recording within the hour!

For some reason TV2+1 has TV1+1 data duplicated. I can't find a reason 
for this and the data seems file seems correct. I tried sql correction 
and then scanning as suggested, which was better than previous times but 
still needed patching. Anyone else come across this?

Maybe its related to the naming of TV2+1 which seems inconsistent and 
possibly the problem for me?

mysql> select chanid, channum, freqid, name, callsign, serviceid, 
mplexid, xmltvid from channel;
+--------+---------+--------+----------------------+----------------------+-----------+---------+-------------------------------------+
| chanid | channum | freqid | name                 | callsign 
   | serviceid | mplexid | xmltvid                             |
+--------+---------+--------+----------------------+----------------------+-----------+---------+-------------------------------------+
|   1001 | 1       | 34     | TV ONE               | TV ONE 
   |      1200 |       1 | tv1.freeviewnz.tv                   |
|   1002 | 2       | 34     | TV2                  | TV2 
   |      1201 |       1 | tv2.freeviewnz.tv                   |
|   1006 | 6       | 34     | TV ONE plus 1        | TV ONE plus 1 
   |      1206 |       1 | tv1-plus1.freeviewnz.tv             |
|   1007 | 7       | 34     | TV2+1                | TV2+1 
   |      1207 |       1 | tv2-plus1.freeviewnz.tv             |
|   1003 | 3       | 32     | TV3                  | TV3 
   |      1300 |       2 | tv3.freeviewnz.tv                   |
|   1004 | 4       | 32     | Four                 | Four 
   |      1301 |       2 | four.freeviewnz.tv                  |
|   1008 | 8       | 32     | TV3 PLUS1            | TV3 PLUS1 
   |      1302 |       2 | tv3-plus1.freeviewnz.tv             |
|   1009 | 9       | 32     | C4                   | C4 
   |      1303 |       2 | c4.freeviewnz.tv                    |
|   1005 | 5       | 36     | Maori Television     | Maori Television 
   |      1400 |       3 | maori-tv.freeviewnz.tv              |
|   1022 | 22      | 36     | Parliament           | Parliament 
   |      1401 |       3 | parliament.freeviewnz.tv            |
|   1028 | 28      | 36     | ChineseTV            | ChineseTV 
   |      1403 |       3 | ctv8.freeviewnz.tv                  |
|   1010 | 10      | 36     | PRIME                | PRIME 
   |      1404 |       3 | prime.freeviewnz.tv                 |
|   1033 | 33      | 36     | TV33                 | TV33 
   |      1405 |       3 | tv33.freeviewnz.tv                  |
|   1030 | 30      | 36     | TVCentral            | TVCentral 
   |      1408 |       3 | tvcentral.freeviewnz.tv             |
|   1050 | 50      | 36     | Radio NZ National    | Radio NZ National 
   |      2000 |       3 | rnz-national.freeviewnz.tv          |
|   1051 | 51      | 36     | Radio NZ Concert     | Radio NZ Concert 
   |      2001 |       3 | rnz-concert.freeviewnz.tv           |
|   1071 | 71      | 36     | BaseFM               | BaseFM 
   |      2002 |       3 | base-fm.freeviewnz.tv               |
|   1021 | 21      | 36     | Stratos              | STRATOS 
   |      1406 |       3 | stratos.freeviewnz.tv               |
|   1072 | 11      | 36     | Trackside            | Trackside 
   |      1402 |       3 | trackside.freeviewnz.tv             |
|   2304 | 1304    | 32     | The Shopping Channel | The Shopping 
Channel |      1304 |       2 | shopping-channel.freeviewnz.tv      |
|   2407 | 1407    | 36     | ChoiceTV             | ChoiceTV 
   |      1407 |       3 | choice.freeviewnz.tv                |
|   2413 | 1413    | 36     | TV9                  | TV9 
   |      1413 |       3 | tv9.freeviewnz.tv                   |
|   2414 | 1414    | 36     | Firstlight           | Firstlight 
   |      1414 |       3 | firstlight.freeviewnz.tv            |
|   2415 | 1415    | 36     | Sommet Sports        | Sommet Sports 
   |      1415 |       3 | sommet-sports.freeviewnz.tv         |
|   2419 | 1419    | 36     | TVSN Shopping        | TVSN Shopping 
   |      1419 |       3 | tvsn-shopping-channel.freeviewnz.tv |
+--------+---------+--------+----------------------+----------------------+-----------+---------+-------------------------------------+

{Line feeds in emails are a pain...}