[mythtv-users] database completely dead?

[Kristian Kalweit]

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 
higher...

Kristian.