[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