[mythtv-users] mythfilldatabase failure

[Michael T. Dean]

On 11/17/2008 08:50 PM, Dan Mount wrote:
> My mythfilldatabase started failing. Here is the error:
>
> ---
> 2008-11-17 19:48:28.737 DB Error (Populating temporary table dd_v_program):
> Query was:
> INSERT INTO dd_v_program      ( chanid,         starttime,       endtime,                title,          subtitle,        description,            airdate,        stars,           previouslyshown,        stereo,         subtitled,       hdtv,                   closecaptioned, partnumber,      parttotal,              seriesid,       originalairdate, showtype,               category_type,  colorcode,       syndicatedepisodenumber,        tvrating,       mpaarating,      programid )      SELECT chanid,         scheduletime,    endtime,                title,          subtitle,        description,            year,           stars,           isrepeat,               stereo,         subtitled,       hdtv,                   closecaptioned, partnumber,      parttotal,              seriesid,       originalairdate, showtype,               category_type,  colorcode,       syndicatedepisodenumber,        tvrating,       mpaarating,      dd_program.programid FROM channel, dd_schedule, dd_program WHERE ((dd_schedule.programid = dd_program.programid)  AND        (channel.xmltvid       = dd_schedule.stationid) AND        (channel.sourceid      = 1))
> Driver error was [2/1366]:
> QMYSQL3: Unable to execute query
> Database error was:
> Incorrect integer value: '' for column 'airdate' at row 1
> ---
>
>
> I belive that I've tracked it back to the data in dd_program. Here is an example insert query:
>
> ---
> 2008-11-17 19:47:40.435 MSqlQuery: INSERT INTO dd_program      ( programid,    title,       subtitle,              description,  showtype,    category_type,         mpaarating,   starrating,  stars,                 runtime,      year,        seriesid,              colorcode,    syndicatedepisodenumber, originalairdate) VALUES      ('EP000000510019',   'A Different World',      'Clair''s Last Stand',             'Clair disapproves of Denise''s vacation plans.', 'Series',   'series',              '',  '', 0,                NULL,     '',       'EP00000051',             '',   '8719',    '1988-03-24')
> ---
>
> If I've tracked it back to the right place, the 'year' value in dd_program is always blank causing the failure when populating dd_v_program. Can anyone tell me if I'm looking in the right place? If so, what's the best course of action for this?
>   

mythbackend --version ???

Mike