[mythtvnz] Diagnosing recording wrong channel

[Stephen Worthington]

On Wed, 20 Jun 2012 15:05:37 +1200, you wrote:

>I have had a few instances of programmes being recorded from the wrong 
>channel.  The correct time but, obviously, the wrong programme!  I need 
>some help diagnosing the cause.
>
>For example I have CSI programmed to record (using programme finder, one 
>showing of this title a week).
>
>Looking at log files I see it recorded from channel number 1041
>
>worik at mythdu:/var/log/mythtv$ zgrep CSI mythbackend.log*|grep 
>recording|head -n 2
>mythbackend.log.1:2012-06-16 20:30:02.709 Started recording: "CSI: Crime 
>Scene Investigation": channel 1041 on cardid 1, sourceid 1
>mythbackend.log.1:2012-06-16 21:36:00.854 Finished recording CSI: Crime 
>Scene Investigation: channel 1041
>
>The channel number for TV3 is 1003.
>
>Looking at upcoming rules it is clearly marked for TV3.
>
>I do not know what to do now.
>
>BTW:
>worik at mythdu:/var/log/mythtv$ aptitude show mythtv-backend
>Package: mythtv-backend
>State: installed
>Automatically installed: yes
>Version: 2:0.24.0+fixes.20110908.1de0431-0ubuntu1
>
>worik at mythdu:/var/log/mythtv$ uname --all
>Linux mythdu 3.0.0-21-generic #35-Ubuntu SMP Fri May 25 17:58:20 UTC 
>2012 i686 i686 i386 GNU/Linux
>
>Ubuntu 11.10
>
>cheers
>Worik

You might like to try this SQL query to see what the tuning data being
used for channel 3 is:

#!/bin/bash
# Lookup the DVB tuning data for a given channel number.
source /etc/mythtv/mysql.txt
mysql -r -t -u $DBUserName -p$DBPassword -h $DBHostName $DBName << EOF

select
channum,chanid,dtv_multiplex.mplexid,dtv_multiplex.sourceid,transportid,networkid,frequency
from channel,dtv_multiplex where channel.channum=3 and
dtv_multiplex.mplexid=channel.mplexid;
EOF

exit 0


I did it as a full bash script in case you are not familiar with SQL
queries.  The "select" statement is all one line - it will be
displayed wrapped in most newsreader software.  This script presumes
that TV3 is on channum = 3, as 1003 is clearly a chanid value.