[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