[mythtv-users] us-cable users who specified finetune values, please help...

[Michael T. Dean]

Daniel is currently working on fixing the frequency tables defined by 
MythTV to make it easier for users to configure their channels by 
ensuring the frequencies are correct "out of the box."  In doing this, 
we need additional information to determine whether a theoretically 
possible situation is forcing some users to specify finetune values to 
receive some of their channels.  Note that this only applies to users 
who are using the us-cable frequency table (and not us-bcast or 
us-cable-hrc or us-cable-irc) for any of their video sources.

If you have specified finetune values (you may have done so through 
either the mythtv-setup channel editor or through MythWeb's channel 
settings page), please run the following two queries and post the output 
back to the list (or send it directly to me--with "myth" somewhere in 
the subject--if you prefer).

SELECT channel.channum, channel.freqid, channel.finetune, 
videosource.freqtable FROM channel LEFT JOIN videosource ON 
channel.sourceid = videosource.sourceid WHERE channel.finetune != 0 AND 
(videosource.freqtable = 'us-cable' OR videosource.freqtable = 
'default') ORDER by videosource.freqtable, LPAD(channel.freqid,4,'0');

and

SELECT * FROM settings WHERE value = 'FreqTable';

You can capture output to a file using:

tee mythtv-finetune

before running the queries and

notee

after.  As shown, the log will be written to the directory from which 
you started the mysql client.  You may instead specify a directory, as 
desired.

Thanks,
Mike