Lachlan McIntosh wrote:
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)
Actually, your fix was to run mysqlcheck or whatever the recovery
program is for mysql. You can refer to their online documentation for
how to repair damaged tables.
Kevin
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
