[mythtv-users] Can't open file: 'program.MYI'. (errno: 145)

maillist at citadelsystems.net maillist at citadelsystems.net
Sun Jun 27 07:53:54 EDT 2004


Anyone have an idea on this error? My kids unplugged the computer while
I was out on business.

I did check to see that the file was there. 


Starting up as the master server.
2004-06-27 07:50:30 mythbackend: MythBackend started as master server
2004-06-27 07:50:30 Deleting
/mnt/store/1026_20040608180000_20040608190000.nuv.tmp
2004-06-27 07:50:30 mythbackend version: 0.15.20040528-1 www.mythtv.org
2004-06-27 07:50:30 Enabled verbose msgs : important general
2004-06-27 07:50:30 Transcoding from
/mnt/store/1026_20040608180000_20040608190000.nuv to
/mnt/store/1026_20040608180000_20040608190000.nuv.tmp
2004-06-27 07:50:32 Found changes in the todo list.
DB Error (AddNewRecords):
Query was:
SELECT DISTINCT channel.chanid, channel.sourceid, program.starttime,
program.endtime, program.title, program.subtitle, program.description,
channel.channum, channel.callsign, channel.name, oldrecorded.endtime IS
NOT NULL AS oldrecduplicate, program.category, record.recpriority +
channel.recpriority + cardinput.preference, record.dupin,
recorded.endtime IS NOT NULL AND recorded.endtime < NOW() AS
recduplicate, record.type, record.recordid, 0, program.starttime -
INTERVAL record.startoffset minute AS recstartts, program.endtime +
INTERVAL record.endoffset minute AS recendts, program.previouslyshown,
record.recgroup, record.dupmethod, channel.commfree, capturecard.cardid,
cardinput.cardinputid, UPPER(cardinput.shareable) = 'Y' AS shareable,
program.seriesid, program.programid FROM record, program  INNER JOIN
channel ON (channel.chanid = program.chanid)  INNER JOIN cardinput ON
(channel.sourceid = cardinput.sourceid)  INNER JOIN capturecard ON
(capturecard.cardid = cardinput.cardid)  LEFT JOIN oldrecorded ON  
(     record.dupmethod > 1 AND     program.title =
oldrecorded.title      AND      (       (program.programid <> '' AND
program.programid NOT LIKE 'SH%0000'        AND program.programid =
oldrecorded.programid)       OR       (        (program.programid = ''
OR oldrecorded.programid = '')        AND        (((record.dupmethod &
0x02) = 0) OR (program.subtitle <> ''           AND program.subtitle =
oldrecorded.subtitle))        AND        (((record.dupmethod & 0x04) =
0) OR (program.description <> ''           AND program.description =
oldrecorded.description))       )      )   )  LEFT JOIN recorded ON  
(     record.dupmethod > 1 AND     program.title = recorded.title     
AND      (       (program.programid <> '' AND program.programid NOT LIKE
'SH%0000'        AND program.programid = recorded.programid)      
OR       (        (program.programid = '' OR recorded.programid =
'')        AND        (((record.dupmethod & 0x02) = 0) OR
(program.subtitle <> ''           AND program.subtitle =
recorded.subtitle))        AND        (((record.dupmethod & 0x04) = 0)
OR (program.description <> ''           AND program.description =
recorded.description))       )      )   ) WHERE record.search = 0 AND
program.title = record.title AND ((record.type = 4 OR record.type = 6) 
OR  ((record.station = channel.callsign)   AND   ((record.type = 3)   
OR   ((TIME_TO_SEC(record.starttime) =
TIME_TO_SEC(program.starttime))     AND     ((record.type = 2)     
OR     ((DAYOFWEEK(record.startdate) =
DAYOFWEEK(program.starttime)       AND       ((record.type = 5)       
OR       ((TO_DAYS(record.startdate) =
TO_DAYS(program.starttime))         AND        
(TIME_TO_SEC(record.endtime) = TIME_TO_SEC(program.endtime))        
AND         (TO_DAYS(record.enddate) = TO_DAYS(program.endtime))        
)       )      )     )    )   )  ) ))
Driver error was [2/1016]:
QMYSQL3: Unable to execute query
Database error was:
Can't open file: 'program.MYI'. (errno: 145)

KM
maillist at citadelsystems.net



More information about the mythtv-users mailing list