[mythtv-users] mythfilldatabase failure

[Nick Morrott]

On 18/11/2008, Dan Mount <bubber-mythtv at bubber.com> 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

See http://bugs.mysql.com/bug.php?id=18551

-- 
Nick Morrott

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

"An investment in knowledge always pays the best interest." - Benjamin Franklin