[mythtv] Ticket #2041: LiveTV tuning broken for IVTV tuner between [10390] and [10402]

Robin Gilks g8ecj at gilks.org
Fri Jul 14 09:20:59 UTC 2006


> #2041: LiveTV tuning broken for IVTV tuner between [10390] and [10402]
> -----------------------------+----------------------------------------------
>  Reporter:  g8ecj at gilks.org  |        Owner:  ijr
>      Type:  defect           |       Status:  closed
>  Priority:  minor            |    Milestone:  0.20
> Component:  mythtv           |      Version:  head
>  Severity:  low              |   Resolution:  worksforme
> -----------------------------+----------------------------------------------
> Comment (by danielk):
>
>  (In [10465]) Refs #1966. Refs #2041. Fix channel flipping when not in
>  browse mode.
>
>  The channel flipping code depended on GetNextChannel() looking up the
>  current channel when no channel was provided. The new implementation of
>  GetNextChannel() was not checking for this condition so it always
> fellback
>  to changing channels with respect to the first channel in the lineup.

I'm still broken here on [10488] with not being able to even select a
channel now, never mind change it! The (continuous) error from the backend
is as follows as does the start of the channel table.


2006-07-14 21:07:38.293 MSqlQuery: UNLOCK TABLES
2006-07-14 21:07:38.309 MSqlQuery: LOCK TABLES recorded WRITE
2006-07-14 21:07:38.325 MSqlQuery: SELECT recordid     FROM recorded    
WHERE chanid    = NULL AND           starttime = '2006-07-14T21:07:48'
2006-07-14 21:07:38.342 MSqlQuery: INSERT INTO recorded    (chanid,   
starttime,   endtime,         title,                subtitle, 
description, hostname,        category,             recgroup,  autoexpire,
 recordid,        seriesid,             programid, stars,      
previouslyshown, originalairdate,      findid,    transcoder,  playgroup, 
     recpriority,          basename,  progstart,   progend,        
profile,              duplicate) VALUES  (NULL,   '2006-07-14T21:07:48',  
  '2006-07-14T22:07:36',           '',               '', '',      
'media',       '',            'Default', 1,    0,       '',           
'',0,      0,         '1900-01-01',         0,   0, 'Default',      0,    
    '_20060714210748.mpg', '2006-07-14T21:07:36',  '2006-07-14T22:07:36', 
      'Default',             0)
2006-07-14 21:07:38.360 DB Error (insert_program -- insert):
Query was:
INSERT INTO recorded    (chanid,    starttime,   endtime,         title,  
             subtitle,  description, hostname,        category,           
 recgroup,  autoexpire,  recordid,        seriesid,             programid,
stars,       previouslyshown, originalairdate,      findid,    transcoder,
 playgroup,       recpriority,          basename,  progstart,   progend,  
      profile,              duplicate) VALUES  (NULL,  
'2006-07-14T21:07:48',     '2006-07-14T22:07:36',           '',           
   '', '',       'media',       '',            'Default', 1,    0,      
'',            '',0,      0,         '1900-01-01',         0,   0,
'Default',      0,         '_20060714210748.mpg', '2006-07-14T21:07:36', 
'2006-07-14T22:07:36',        'Default',             0)
Driver error was [2/1048]:
QMYSQL3: Unable to execute query
Database error was:
Column 'chanid' cannot be null

2006-07-14 21:07:38.377 MSqlQuery: UNLOCK TABLES
2006-07-14 21:07:38.393 MSqlQuery: LOCK TABLES recorded WRITE
2006-07-14 21:07:38.409 MSqlQuery: SELECT recordid     FROM recorded    
WHERE chanid    = NULL AND           starttime = '2006-07-14T21:07:49'
2006-07-14 21:07:38.426 MSqlQuery: INSERT INTO recorded    (chanid,   
starttime,   endtime,         title,                subtitle, 
description, hostname,        category,             recgroup,  autoexpire,
 recordid,        seriesid,             programid, stars,      
previouslyshown, originalairdate,      findid,    transcoder,  playgroup, 
     recpriority,          basename,  progstart,   progend,        
profile,              duplicate) VALUES  (NULL,   '2006-07-14T21:07:49',  
  '2006-07-14T22:07:36',           '',               '', '',      
'media',       '',            'Default', 1,    0,       '',           
'',0,      0,         '1900-01-01',         0,   0, 'Default',      0,    
    '_20060714210749.mpg', '2006-07-14T21:07:36',  '2006-07-14T22:07:36', 
      'Default',             0)
2006-07-14 21:07:38.444 DB Error (insert_program -- insert):
Query was:
INSERT INTO recorded    (chanid,    starttime,   endtime,         title,  
             subtitle,  description, hostname,        category,           
 recgroup,  autoexpire,  recordid,        seriesid,             programid,
stars,       previouslyshown, originalairdate,      findid,    transcoder,
 playgroup,       recpriority,          basename,  progstart,   progend,  
      profile,              duplicate) VALUES  (NULL,  
'2006-07-14T21:07:49',     '2006-07-14T22:07:36',           '',           
   '', '',       'media',       '',            'Default', 1,    0,      
'',            '',0,      0,         '1900-01-01',         0,   0,
'Default',      0,         '_20060714210749.mpg', '2006-07-14T21:07:36', 
'2006-07-14T22:07:36',        'Default',             0)
Driver error was [2/1048]:
QMYSQL3: Unable to execute query
Database error was:
Column 'chanid' cannot be null


chanid	channum	freqid	sourceid	callsign	name	icon	finetune	videofilters	xmltvid	recpriority	contrast	brightness	colour	hue	tvformat	commfree	visible	outputfilters	useonairguide	mplexid	serviceid	atscsrcid	tmoffset	atsc_major_chan	atsc_minor_chan
1052	991	3	1	TV One_T	TV
One	/home/g8ecj/.mythtv/channels/tv1_newzealand.jpg	150		TV1.mr.geek.nz	-5	32768	32768	32768	32768	Default	0	1		0	1	0	0	0	0	0
1053	992	8	1	TV 2_T	TV
2	/home/g8ecj/.mythtv/channels/tv2_newzealand.jpg	0		TV2.mr.geek.nz	-5	32768	32768	32768	32768	Default	0	1		0	1	0	0	0	0	0
1054	993	6	1	TV 3_T	TV
3	/home/g8ecj/.mythtv/channels/tv3_newzealand.jpg	0		TV3.mr.geek.nz	-5	32768	32768	32768	32768	Default	0	1		0	1	0	0	0	0	0

-- 
Robin Gilks




More information about the mythtv-dev mailing list