[mythtv] Master database upgrade failed
Russell Gower
mythtv at thegowers.me.uk
Thu Jun 19 18:18:14 UTC 2014
Hi,
I’m running master here and have just tried to upgrade from gbefdc4d to g99c7296 but the database schema upgrade failed, here’s the output from mythtv-setup
2014-06-19 19:02:52.091388 I Current MythTV Schema Version (DBSchemaVer): 1327
2014-06-19 19:02:52.100456 E Backing up database with script: '/usr/share/mythtv/mythconverg_backup.pl'
2014-06-19 19:03:03.067877 C Database Backup complete.
2014-06-19 19:03:03.068628 C Backed up database to file: '/mythtv/A/DB/mythconverg-1327-20140619180252.sql.gz'
2014-06-19 19:03:14.412413 C Upgrading to MythTV schema version 1328
2014-06-19 19:03:14.412783 E DB Error (Performing database upgrade):
Query was: ALTER TABLE record DROP INDEX chanid
Error was: Driver error was [2/1091]:
QMYSQL: Unable to execute query
Database error was:
Can't DROP 'chanid'; check that column/key exists
new version: 1328
2014-06-19 19:03:14.412796 E Database schema upgrade failed.
2014-06-19 19:03:14.413192 E Couldn't upgrade database to new schema.
I’ve downgraded and restored the database from the backup so I up and running again now, just not sure how to upgrade to a more recent checkout.
Regards
Russell
More information about the mythtv-dev
mailing list