[mythtv-users] SVN and Live-TV

Charles Philip Chan cpchan at sympatico.ca
Tue Aug 1 14:32:03 UTC 2006


On 2006-08-01 09:45:37 -0400 Charles Philip Chan <cpchan at sympatico.ca> 
wrote:

> As you can see, the channum is set to '' during the brightness query. 
> I 
> wonder if this is the problem?

Pressing Watch TV yields something even fishier other than the 
brightness problem:

2006-08-01 10:17:54.664 TVRec(1): Changing from None to WatchingLiveTV
2006-08-01 10:17:54.666 MSqlQuery: SELECT startchan FROM capturecard, 
cardinput WHERE capturecard.cardid capturecard.cardid 1'
2006-08-01 10:17:54.667 TVRec(1): HW Tuner: 1->1
2006-08-01 10:17:54.669 MSqlQuery: SELECT cardinputid,        
inputname,   startchan,        tunechan,    externalcommand,        
sourceid,    childcardid FROM cardinput WHERE cardid 2006-08-01 10:17:54.670 MSqlQuery: SELECT chanid, favid FROM favorites
2006-08-01 10:17:54.677 MSqlQuery: SELECT channum, callsign, chanid,   
      atsc_major_chan, atsc_minor_chan,        name, icon FROM channel 
WHERE sourceid='1'
2006-08-01 10:17:54.723 MSqlQuery: SELECT chanid, favid FROM favorites
2006-08-01 10:17:54.730 MSqlQuery: SELECT channum, callsign, chanid,   
      atsc_major_chan, atsc_minor_chan,        name, icon FROM channel 
WHERE sourceid='1'
2006-08-01 10:17:54.775 MSqlQuery: SELECT chanid, favid FROM favorites
2006-08-01 10:17:54.782 MSqlQuery: SELECT channum, callsign, chanid,   
      atsc_major_chan, atsc_minor_chan,        name, icon FROM channel 
WHERE sourceid='1'
2006-08-01 10:17:54.829 MSqlQuery: SELECT chanid, favid FROM favorites
2006-08-01 10:17:54.837 MSqlQuery: SELECT channum, callsign, chanid,   
      atsc_major_chan, atsc_minor_chan,        name, icon FROM channel 
WHERE sourceid='1'
2006-08-01 10:17:54.885 MSqlQuery: SELECT channel.chanid FROM channel, 
capturecard, cardinput WHERE channel.channum             channel.sourceid     cardinput.inputname  cardinput.cardid        2006-08-01 10:17:54.887 MSqlQuery: SELECT finetune, freqid, tvformat, 
freqtable,        commfree, mplexid,        atsc_major_chan, 
atsc_minor_chan, serviceid FROM channel, videosource WHERE 
videosource.sourceid 2006-08-01 10:17:54.889 MSqlQuery: SELECT channel.brightness FROM 
channel WHERE channum  2006-08-01 10:17:54.890 MSqlQuery: SELECT brightness FROM capturecard, 
cardinput WHERE sourceid         AND       ( ( cardinput.childcardid !cardinput.childcardid  cardinput.childcardid  capturecard.cardid ) )
2006-08-01 10:17:54.891 Channel(/dev/video0): SetInputAndFormat() 
failed
2006-08-01 10:17:54.892 TVRec(1) Error: Failed to set channel to 13.
2006-08-01 10:17:54.910 MSqlQuery: SELECT recordingprofiles.id, 
profilegroups.hostname,        profilegroups.is_default FROM 
recordingprofiles, profilegroups, capturecard WHERE profilegroups.id   
     TV'
2006-08-01 10:17:54.913 MSqlQuery: SELECT cardtype FROM profilegroups, 
recordingprofiles WHERE profilegroups.id     recordingprofiles.profilegroup AND       recordingprofiles.id 2006-08-01 10:17:54.917 MSqlQuery: SELECT name FROM recordingprofiles 
WHERE id 2006-08-01 10:17:54.919 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.921 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.924 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.937 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.952 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.953 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.955 MSqlQuery: SELECT videocodec FROM 
recordingprofiles WHERE id 2006-08-01 10:17:54.957 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.959 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.961 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.962 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.964 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.965 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.967 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.968 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.970 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.971 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.973 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.974 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.976 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.978 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.980 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.982 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.984 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.987 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.988 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.990 MSqlQuery: SELECT audiocodec FROM 
recordingprofiles WHERE id 2006-08-01 10:17:54.992 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.994 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.996 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.997 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:54.999 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:55.000 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:55.004 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:55.005 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:55.008 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:55.010 MSqlQuery: SELECT value FROM codecparams WHERE 
profile 2006-08-01 10:17:55.012 MSqlQuery: SELECT channel.chanid FROM channel 
WHERE channum  2006-08-01 10:17:55.015 MSqlQuery: SELECT data FROM settings WHERE 
value 2006-08-01 10:17:55.018 MSqlQuery: SELECT data FROM settings WHERE 
value 2006-08-01 10:17:55.022 MSqlQuery: SELECT DISTINCT program.chanid, 
program.starttime, program.endtime,     program.title, 
program.subtitle, program.description,     program.category, 
channel.channum, channel.callsign,     channel.name, 
program.previouslyshown, channel.commfree,     channel.outputfilters, 
program.seriesid, program.programid,     program.airdate, 
program.stars, program.originalairdate,     program.category_type, 
oldrecstatus.recordid,     oldrecstatus.rectype, 
oldrecstatus.recstatus,     oldrecstatus.findid FROM program LEFT JOIN 
channel ON program.chanid oldrecstatus ON     program.title channel.callsign oldrecstatus.starttime WHERE program.chanid program.starttime < '2006-08-01T10:17:50'   AND program.endtime > 
'2006-08-01T10:17:50'  GROUP BY program.starttime, channel.channum,   
channel.callsign, program.title  ORDER BY program.starttime, 
atsc_major_chan,atsc_minor_chan,channum,callsign  LIMIT 1000
2006-08-01 10:17:55.025 MSqlQuery: SELECT chanid, channum, callsign, 
name, commfree, outputfilters FROM channel WHERE chanid ;
2006-08-01 10:17:55.027 TVRec(1) Error: GetProgramRingBufferForLiveTV()
			ProgramInfo is invalid.


Look at the log entry for "2006-08-01 10:17:55.022" and "2006-08-01 
10:17:55.025", I wonder where it got the chanid 
Charles

-- 
/* So there I am, in the middle of my `netfilter-is-wonderful'
    talk in Sydney, and someone asks `What happens if you try
    to enlarge a 64k packet here?'.  I think I said something
    eloquent like `fuck'. */
         linux-2.4.3/net/ipv4/netfilter/ip_nat_ftp.c
-------------- next part --------------
RFC3156 defines security multipart formats for MIME with OpenPGP.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 230 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20060801/8fb34be0/attachment.pgp 


More information about the mythtv-users mailing list