[mythtv-users] database completely dead?

Mark Knecht markknecht at gmail.com
Wed Feb 15 03:56:06 UTC 2006


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

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 0017710202','12499','2006-02-15T12:30:00','00:30:00',0,1,0,0,1,'TV-G',0,0,'2006-
02-15T13:00:00');
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.dd_schedule' doesn't exist

   Are there any instructions around on how to fix this automatically?
If we decided that none of the old recordings matter much then how
would I go about getting things running again?

Thanks,
Mark


More information about the mythtv-users mailing list