[mythtv] problems upgrading database to 1217

Simon Kenyon simon at koala.ie
Fri May 9 14:04:18 UTC 2008


had a hard disk crash
reinstalled everything
installed svn  16772, all was good - except my lost configuration
decided to upgrade to latest svn (had been avoiding due to qt4 upgrade)

this is what i got when i tried to start mythbackend

2008-05-09 14:53:39.300 Newest Schema Version : 1220
2008-05-09 14:53:39.302 Upgrading to schema version 1216
2008-05-09 14:53:42.287 Upgrading to schema version 1217
2008-05-09 14:53:42.899 DB Error (Performing database upgrade):
Query was: ALTER TABLE people  DEFAULT CHARACTER SET default,  MODIFY 
name char(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '';
Error was: Driver error was [2/1062]:
QMYSQL: Unable to execute query
Database error was:
Duplicate entry 'J' for key 2

new version: 1217
2008-05-09 14:53:42.904 Database Schema upgrade FAILED, unlocking.
2008-05-09 14:53:42.905 Couldn't upgrade database to new schema

this is on a brand new install of everything (including mysql 5.0.54) on 
an AMD64 X2 running gentoo
regards
--
simon


More information about the mythtv-dev mailing list