[mythtv-users] mythfilldatabase problems

Carl Fongheiser carlfongheiser at gmail.com
Mon Apr 17 19:34:59 UTC 2006


On 4/17/06, Mark Knecht <markknecht at gmail.com> wrote:
>
> Hi,
>    As of this morning mythfilldatabse is having trouble. It starts off
> OK talking to Zap2It Labs, but then quickly dies with 100's of
> messages like the one I've pasted here.
>
> DB Error (Inserting into dd_schedule):
> Query was:
> INSERT INTO dd_schedule
>
> (programid,stationid,scheduletime,duration,repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtime)
>
> VALUES('SH3099430000','14752','2006-04-18T15:00:00','01:00:00',0,0,0,0,0,NULL,0,0,'2006-04-18T16:00:00');
> Driver error was [2/1146]:
> QMYSQL3: Unable to execute query
> Database error was:
> Table 'mythconverg.dd_schedule' doesn't exist
>
>    Any ideas on what to do to fix this?


It looks like maybe your database has something wrong with it;  dd_schedule
is a table that is dynamically created and removed when mythfilldatabase
runs.  Try running "mysqlcheck -u mythtv -p -B mythconverg".

Carl Fongheiser
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060417/29772986/attachment.htm 


More information about the mythtv-users mailing list