[mythtvnz] Upgrade Error - Attn: Hads

[Hadley Rich]

On Thursday 12 June 2008 09:22:51 Ashley Kirk wrote:
> 2008-06-12 09:18:35.847 Upgrading to schema version 1181
> 2008-06-12 09:18:35.852 DB Error (Performing database upgrade):
> Query was: ALTER TABLE recordedseek MODIFY mark MEDIUMINT UNSIGNED NOT NULL
> DEFAULT 0,MODIFY offset BIGINT UNSIGNED NOT NULL,MODIFY type TINYINT NOT
> NULL DEFAULT 0;
> Error was: Driver error was [2/145]:
> QMYSQL3: Unable to execute query
> Database error was:
> Table './mythconverg/recordedseek' is marked as crashed and should be
> repaired

There's your problem right there. At least one of the tables in your DB is 
marked as crashed and needs to be repaired. Try running;

mysqlcheck --databases mythconverg --repair

That should find and fix it. If it doesn't there's another couple of commands 
that can be tried.

hads
-- 
http://nicegear.co.nz
VoIP, DVB and other Linux compatible hardware. Linux laptops.