[mythtv] DB Schema update is failing

Devan Lippman 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
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 mailing list