[mythtv-users] Database update schema error with trunk utf8

freedenizen freedenizen at gmail.com
Sun Dec 7 19:07:32 UTC 2008


I'm getting the following error when trying to upgrade from 21-fixes
to trunk.  Looks like the problem is with converting to utf8.  I'm
running mysql 5.0.60 but I am upgrading to 5.0.70-r1 incase that
resolves the issue.  Has anyone else seen this?  I've tried searching
the lists on dev and commit, I know there has been some work on utf8
conversion but I couldn't find anything related to this error.

TIA

2008-12-07 10:54:43.948 Newest Schema Version : 1226
2008-12-07 10:54:43.951 Upgrading to schema version 1217
2008-12-07 10:54:49.505 DB Error (Performing database upgrade):
Query was: ALTER TABLE oldprogram  DEFAULT CHARACTER SET default,  MODIFY oldtit
le varchar(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 'Cl' for key 1


More information about the mythtv-users mailing list