[mythtv-users] LiveTV broken, strange errors in log

[Chris Gentle]

Hi.  I recently upgraded my two mythtv boxes to kernel 2.6.16 and
ivtv-0.6.2.  This, of course, meant I had to delete my capture
boards and add them back in because of the v4l changes in the ivtv
driver.  Since I made these changes my slave backend (myth2) will
not play Live TV.  It goes black for a few seconds and then comes
right back to the main menu.  The backend log on myth2 starts
filling up with errors like the ones below.  The actual error is at
the very bottom.  Any ideas?

Thanks!

2006-06-16 09:27:23.957 MSqlQuery: UNLOCK TABLES

2006-06-16 09:27:23.960 MSqlQuery: LOCK TABLES recorded WRITE

2006-06-16 09:27:23.964 MSqlQuery: SELECT recordid     FROM recorded
WHERE chanid    = NULL AND           starttime =
'2006-06-16T09:54:20'

2006-06-16 09:27:23.968 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-06-16T09:54:20',     '2006-06-16T10:26:40',
'',               '', '',       'myth2',       '',
'Default', 1,    0,       '',            '',0,      0,
'1900-01-01',         0,   0, 'Default',      0,
'_20060616095420.mpg', '2006-06-16T09:26:40',
'2006-06-16T10:26:40',        'Default',             0)

2006-06-16 09:27:23.970 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-06-16T09:54:20',     '2006-06-16T10:26:40',           '',
'', '',       'myth2',       '',            'Default', 1,    0,
'',            '',0,      0,         '1900-01-01',         0,   0,
'Default',      0,         '_20060616095420.mpg',
'2006-06-16T09:26:40',  '2006-06-16T10:26:40',        'Default',
0)

Driver error was [2/1048]:
QMYSQL3: Unable to execute query
Database error was:
Column 'chanid' cannot be null

-- 
Chris