[mythtv-users] LiveTV ERROR after Reinstall

[Nick]

On 31/07/06, Alexander Böhm <babyfly at gmx.net> wrote:
> Hi all,
> i have reinstalled my box today with the latest SVN release.
> After setting up everything as normal without any erros when i try to watch TV the frontend drops me back to the Menu. When i try it a second time after a few seconds the frontend tells me the connection to the backend is lost.
> The backend is running already but looping the following message and dosent respond to anything after that
>
> 2006-07-31 15:55:08.652 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-08-01T02:19:47',     '2006-07-31T16:52:15',           '',               '', '',       'mythbox.localdomain',       '',            'Default', 1,    0,       '',            '',0,      0,         '1900-01-01',         0,   0, 'Default',      0,         '_20060801021947.mpg', '2006-07-31T15:52:15',  '2006-07-31T16:52:15',        'Default',             0)
> Driver error was [2/1048]:
> QMYSQL3: Unable to execute query
> Database error was:
> Column 'chanid' cannot be null
>
> thanks for any help

It's most likely this problem - http://cvs.mythtv.org/trac/ticket/2084

Nick

-- 
MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users