[mythtv] Channel/DB Buglet?

[Andrew C. Ohnstad]

--0-1745713950-1038271161=:92586
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

--- Isaac Richards <ijr@po.cwru.edu> wrote:
 
> Weird -- I don't see anything jumping out at me in
> the code that could cause 
> this.  Could you stick a 'cout << thequery << endl'
> in libs/libmythtv/tv.cpp, 
> line 1757 (against current CVS) -- that's in
> TV::CheckChannel(), right after 
> it sets up the database query.  I'd like to see the
> output of you changing to 
> a channel manually with the number keys, and then
> the output of you changing 
> to that channel with the program guide.  Just lookin
> to see what's different 
> between the two.

Your wish is my command.

See the attached.  Where ever there is a ### those are
my comments, not stuff actually put out on the console
(duh).

>From first inspection it looks like it's scanning for
us-cable channels on the first go around and not
channels in the 200+ range where all my DirecTV stuff
is.

I'll leave the fixing of it to the experts. :)

---A


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus – Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--0-1745713950-1038271161=:92586
Content-Type: text/plain; name="mythdebug.txt"
Content-Description: mythdebug.txt
Content-Disposition: inline; filename="mythdebug.txt"

Probed: /dev/video - Television
Probed: /dev/video - Composite1
Probed: /dev/video - S-Video
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "3" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
Changing from None to WatchingLiveTV

### This is before selecting ANYTHING.
### Now I choose Live TV

Using XV port 59
Delaying to next trigger: 337269
Delaying to next trigger: 279019
Delaying to next trigger: 231954

### So far, so good.  Now I hit up arrow

SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "1" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "2" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "3" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "4" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "5" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "6" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "7" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "8" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "9" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "10" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "11" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "12" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "13" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "14" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "15" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "16" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "17" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "18" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "19" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "20" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "21" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "22" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "23" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "24" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "25" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "26" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "27" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "28" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "29" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "30" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "31" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "32" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "33" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "34" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "35" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "36" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "37" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "38" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "39" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "40" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "41" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "42" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "43" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "44" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "45" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "46" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "47" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "48" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "49" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "50" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "51" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "52" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "53" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "54" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "55" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "56" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "57" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "58" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "59" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "60" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "61" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "62" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "63" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "64" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "65" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "66" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "67" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "68" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "69" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "70" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "71" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "72" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "73" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "74" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "75" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "76" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "77" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "78" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "79" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "80" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "81" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "82" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "83" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "84" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "85" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "86" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "87" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "88" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "89" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "90" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "91" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "92" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "93" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "94" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "95" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "96" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "97" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "98" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "99" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "100" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "101" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "102" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "103" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "104" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "105" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "106" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "107" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "108" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "109" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "110" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "111" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "112" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "113" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "114" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "115" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "116" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "117" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "118" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "119" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "120" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "121" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "122" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "123" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "124" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "125" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "T7" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "T8" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "T9" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "T10" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "T11" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "T12" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "T13" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "T14" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "1" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
Error, couldn't find any available channels.
Your database is most likely set up incorrectly.

### Oops, note it seems to be looking for broadcast/cable channels (1 thru 125) which really don't exist in my database.  My first channel is 202.

Delaying to next trigger: 323010
Delaying to next trigger: 234758
Delaying to next trigger: 214106

### Now I'll hit 'm' and 'm' on the first channel on my epg.

SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "202" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "202" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
sh: line 1 202: command not found
Delaying to next trigger: 326841
Delaying to next trigger: 285053
Delaying to next trigger: 228252

### I meant to say something about the 'sh:' complaint before, but never got around to it.  I don't know why but every time I change channels it spits the channel number out as the command not found.
### Anyways, up arrow and...

SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "203" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
SELECT channel.finetune FROM channel,capturecard,cardinput WHERE channel.channum = "203" AND channel.sourceid = cardinput.sourceid AND cardinput.inputname = "Composite1" AND cardinput.cardid = capturecard.cardid AND capturecard.videodevice = "/dev/video";
sh: line 1 203: command not found

### The channel number is always reflected as a command not found.  I do NOT have the 'external command' option set in settings.txt.
--0-1745713950-1038271161=:92586--