[mythtvnz] Diagnosing recording wrong channel

[Stephen Worthington]

On Fri, 22 Jun 2012 18:49:26 +1200, you wrote:

>On 21/06/12 19:37, Stephen Worthington wrote:
>> delete from channel where chanid>  1035 and chanid<= 1053 and mplexid
[snip]
>> However, that will still leave you without any of the radio channels -
>> they do not seem to have turned up in your initial tuning scan.  So
>> you will need to add them in.  I could provide a script to do that,
>> but I am still running Mythtv 0.24-fixes, and I am not sure if there
>> were any changes to the channel table for 0.25, which I presume you
>> are using.  So please run this SQL command:
>>
>> describe channel;
>I am running 0.24.  It does look like the upgrade 0.24 -> 0.25 is 
>painful, and unless it fixes this problem there is no reason for it.  
>I'll see if cleaning up that table stops the problem (happened last 
>night channel 3 instead of channel two)

Here is the SQL to add the radio channels:

INSERT INTO `channel` VALUES
(1050,'50','36',1,'RNZ National','Radio NZ
National','/home/stephen/.mythtv/channels/radio_nz_national.jpg',0,'','rnz-national.freeviewnz.tv',0,32768,32768,32768,32768,'Default',1,'',1,6,2000,0,0,0,'2011-11-26
22:27:40','crid://radionznational.co.nz',-1),
(1051,'51','36',1,'RNZ Concert','Radio NZ
Concert','/home/stephen/.mythtv/channels/radio_nz_concert.jpg',0,'','rnz-concert.freeviewnz.tv',0,32768,32768,32768,32768,'Default',1,'',1,6,2001,0,0,0,'0000-00-00
00:00:00','crid://radionzconcert.co.nz',-1),
(1071,'71','36',1,'BaseFM','BaseFM','/home/stephen/.mythtv/channels/basefm.jpg',0,'','base-fm.freeviewnz.tv',0,32768,32768,32768,32768,'Default',1,'',1,6,2002,0,0,0,'0000-00-00
00:00:00','crid://basefm.co.nz',-1),
;

You will need to adjust the "icon" field values (the
"/home/stephen/.mythtv/channels/" bits) to point to wherever you are
storing your channel icon files.  The '36' in the "freqid" (third from
the left) may also not be correct for your transmitter.  It is
actually unused, but probably should match the dtv_multiplex.frequency
value just in case.  So do this query:

select channum,chanid,freqid,name,icon from channel where channum =
10;

That should give you the freqid for Prime, which is on the same
(Kordia) multiplex as the radio channels.  Use that value instead of
'36', and see what the correct icon path is.