[mythtv-users] database completely dead?

David Watkins watkinshome at gmail.com
Wed Feb 15 08:36:23 UTC 2006


On 15/02/06, Kristian Kalweit <kalweit at exorpro.de> wrote:
> Mark Knecht schrieb:
> > Hi,
> >    All of a sudden and without warning it appears my Myth database is
> > pretty messed up. We see no programming info in Myth and when I try to
> > run mythfilldatabase from a terminal I get an endless bunch of message
> > scuh as the following:
> >
> > 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('EP 0017710175','12499','2006-02-15T12:00:00','00:30:00',0,1,0,0,1,'TV-G',0,0,'2006-
> > 02-15T12:30:00');
> > Driver error was [2/1146]:
> > QMYSQL3: Unable to execute query
> > Database error was:
> > Table 'mythconverg.dd_schedule' doesn't exist
> >
> >
> dd_schedule is only a temporary table for processing. The real table is
> "schedule". I think there have to be an error message at first, that
> there is something wrong with creating the table dd_schedule. What's you
> MySQL Version? CREATE TEMPORAY TABLE is only supported by MySQL 3.23 and


Out of disk space?

That's one of the reasons that a working machine suddenly stops.

$df


More information about the mythtv-users mailing list