[mythtv-users] mythfilldatabase failure
Nick Morrott
knowledgejunkie at gmail.com
Wed Nov 19 07:06:44 UTC 2008
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
More information about the mythtv-users
mailing list