Hello. I just tried to upgrade my mythv from 0.17 to 0.18.1 with "apt-get install mythtv-suite", but the mysql schema upgrade failed and now mysql is borked and mythbackend won't run. From mythbackend.log:
---------- 2005-07-06 08:54:49.366 New DB connection, total: 1 2005-07-06 08:54:49.641 Setting Lock for Database Schema upgrade. If you see a l ong pause here it means the Schema is already locked and is being upgraded by an other Myth process. 2005-07-06 08:54:49.709 New DB connection, total: 2 2005-07-06 08:54:49.714 Upgrading to schema version 1072 2005-07-06 08:54:49.797 DB Error (Performing database upgrade): Query was: ALTER TABLE program ADD COLUMN manualid INT UNSIGNED NOT NULL DEFAULT 0; Error was: Driver error was [2/1016]: QMYSQL3: Unable to execute query Database error was: Can't open file: 'program.MYD'. (errno: 145) new version: 1072 2005-07-06 08:54:49.815 Database Schema upgrade FAILED, unlocking. 2005-07-06 08:54:49.827 Couldn't upgrade database to new schema ---------- I have these installed: mysql-server-3.23.58-16.FC3.1 mysql-3.23.58-16.FC3.1 php-mysql-4.3.11-2.6 libdbi-dbd-mysql-0.6.5-9 mysql-devel-3.23.58-16.FC3.1 uname -a Linux tomvo.tomhines.net 2.6.11-1.27_FC3 #1 Tue May 17 20:27:37 EDT 2005 i686 i686 i386 GNU/Linux Running FC3 on a VIA M 10K Anyone know what went wrong? Or how I can fix it other than rebuilding the database? Thanks, Tom _______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users