[mythtv-users] upgrading database from ATRPMS latest to source

Justin Luitjens 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 mailing list