OK the fix is:
mysql mythconverg
drop table jobqueue;
CREATE TABLE jobqueue (
id INTEGER NOT NULL AUTO_INCREMENT,
chanid INTEGER(10) NOT NULL,
starttime DATETIME NOT NULL,
inserttime DATETIME NOT NULL,
type INTEGER NOT NULL,
cmds INTEGER NOT NULL DEFAULT 0,
flags INTEGER NOT NULL DEFAULT 0,
status INTEGER NOT NULL DEFAULT 0,
statustime TIMESTAMP NOT NULL,
hostname VARCHAR(255) NOT NULL DEFAULT '',
args BLOB NOT NULL DEFAULT '',
comment VARCHAR(128) NOT NULL DEFAULT '',
PRIMARY KEY(id),
UNIQUE(chanid, starttime, type, inserttime)
);
Oh keep in mind that the table names are case sensitive (YAY)
Thanks
Lachlan McIntosh
________________________________
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Lachlan McIntosh
Sent: Sunday, 20 February 2005 8:28 AM
To: [email protected]
Subject: [mythtv-users] Can't open file: 'jobqueue.MYI'. (errno: 145)
Can anyone point me in the right direction for fixing this one?
I can't flag commercials or transcode anything....
DB Error (Error in JobQueue::ChangeJobComment()):
Query was:
SELECT status,cmds FROM jobqueue WHERE type = :TYPE AND chanid = :CHANID
AND starttime = :STARTTIME;
Driver error was [2/1016]:
QMYSQL3: Unable to execute query
Database error was:
Can't open file: 'jobqueue.MYI'. (errno: 145)
Thanks
Lachlan McIntosh
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
