[mythtv] DB Schema update is failing
devan.lippman at gmail.com
Sun Dec 18 15:01:44 EST 2005
Installed yesterdays SVN to check out the new livetv and mythbackend
is dying because it is failing to update the db. Looks like its
trying to add a column that already exists...
2005-12-18 05:58:07.853 Current Schema Version: 1101
2005-12-18 05:58:07.853 Newest Schema Version : 1120
2005-12-18 05:58:07.854 Setting Lock for Database Schema upgrade. If
you see a long pause here it means the Schema is already locked and is
being upgraded by another Myth process.
2005-12-18 05:58:07.854 New DB connection, total: 2
2005-12-18 05:58:07.855 Upgrading to schema version 1102
2005-12-18 05:58:07.856 DB Error (Performing database upgrade):
Query was: ALTER TABLE tvchain ADD COLUMN hostprefix VARCHAR(128) NOT
NULL DEFAULT '';
Error was: Driver error was [2/1060]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate column name 'hostprefix'
new version: 1102
2005-12-18 05:58:07.856 Database Schema upgrade FAILED, unlocking.
2005-12-18 05:58:07.856 Couldn't upgrade database to new schema
Devan Lippman <devan at lippman dot net>
More information about the mythtv-dev