[mythtv-users] sql query error affecting autoexpire deleting (0.22-fixes via avenard)

[Steven Adeff]

anyone know whats going wrong?

2009-11-02 22:05:42.743 Error preparing query: SELECT NULL from record
WHERE type = :FINDONE AND findid <= 0;
2009-11-02 22:05:42.765 Driver error was [2/1017]:
QMYSQL3: Unable to prepare statement
Database error was:
Can't find file: './mythconverg/record.frm' (errno: 13)

2009-11-02 22:05:42.766 DB Error (UpdateMatches):
Query was:
SELECT NULL from record WHERE type = ? AND findid <= 0;
Bindings were:
:FINDONE=6
No error type from QSqlError?  Strange...
2009-11-02 22:05:42.769 Error preparing query: SELECT
recordid,title,maxepisodes,maxnewest FROM record;
2009-11-02 22:05:42.780 Driver error was [2/1017]:
QMYSQL3: Unable to prepare statement
Database error was:
Can't find file: './mythconverg/record.frm' (errno: 13)

2009-11-02 22:05:42.781 DB Error (CheckTooMany):
Query was:
SELECT recordid,title,maxepisodes,maxnewest FROM record;
No error type from QSqlError?  Strange...
2009-11-02 22:05:42.783 Error preparing query: SELECT record.recordid,
record.type, record.chanid, record.starttime, record.startdate,
record.endtime, record.enddate, record.startoffset, record.endoffset,
record.title, record.subtitle, record.description, channel.channum,
channel.callsign, channel.name FROM record  INNER JOIN channel ON
(channel.chanid = record.chanid)  LEFT JOIN recordmatch on
record.recordid = recordmatch.recordid WHERE (type = 1 OR type = 2 OR
type = 5 OR type = 7)  AND recordmatch.chanid IS NULL
2009-11-02 22:05:42.792 Driver error was [2/1017]:
QMYSQL3: Unable to prepare statement
Database error was:
Can't find file: './mythconverg/record.frm' (errno: 13)

2009-11-02 22:05:42.793 DB Error (AddNotListed):
Query was:
SELECT record.recordid, record.type, record.chanid, record.starttime,
record.startdate, record.endtime, record.enddate, record.startoffset,
record.endoffset, record.title, record.subtitle, record.description,
channel.channum, channel.callsign, channel.name FROM record  INNER
JOIN channel ON (channel.chanid = record.chanid)  LEFT JOIN
recordmatch on record.recordid = recordmatch.recordid WHERE (type = 1
OR type = 2 OR type = 5 OR type = 7)  AND recordmatch.chanid IS NULL
No error type from QSqlError?  Strange...
2009-11-02 22:05:42.809 Error preparing query: SELECT recordid,
next_record FROM record;
2009-11-02 22:05:42.826 Driver error was [2/1017]:
QMYSQL3: Unable to prepare statement
Database error was:
Can't find file: './mythconverg/record.frm' (errno: 13)



-- 
Steve
http://www.mythtv.org/wiki/index.php/User:Steveadeff
Before you ask, read the FAQ!
http://www.mythtv.org/wiki/index.php/Frequently_Asked_Questions
then search the Wiki, and this list,
http://www.gossamer-threads.com/lists/mythtv/
Mailinglist etiquette -
http://www.mythtv.org/wiki/index.php/Mailing_List_etiquette