[mythtv-users] upgrading database from ATRPMS latest to source
luitjens at cs.utah.edu
Wed Jan 17 05:06:08 UTC 2007
How do I upgrade the database from ATRPMS latest to source?
Currently I'm getting the following error:
2007-01-16 22:00:57.664 Current Schema Version: 1164
2007-01-16 22:00:57.666 Newest Schema Version : 1175
2007-01-16 22:00:57.676 New DB connection, total: 2
2007-01-16 22:00:57.677 Connected to database 'mythconverg' at host:
2007-01-16 22:00:57.678 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.
2007-01-16 22:00:57.680 New DB connection, total: 3
2007-01-16 22:00:57.681 Connected to database 'mythconverg' at host:
2007-01-16 22:00:57.683 Upgrading to schema version 1165
2007-01-16 22:00:57.685 DB Error (Performing database upgrade):
Query was: CREATE INDEX program_manualid ON program (manualid);
Error was: Driver error was [2/1061]:
QMYSQL3: Unable to execute query
Database error was:
Duplicate key name 'program_manualid'
and trying to restart after that gave me
new version: 1165
2007-01-16 22:00:57.685 Database Schema upgrade FAILED, unlocking.
2007-01-16 22:00:57.686 Couldn't upgrade database to new schema, exiting.
More information about the mythtv-users