id summary reporter owner description type status priority milestone component version severity resolution keywords cc mlocked 8762 DB Schema Upgrade from 0.21 fails Martin Bene "When trying to update myth from 0.21, the pre-update dtabase check fails if the ""people"" table contains entries with names that differ only at character positions > 41. reason is in mythtv/libs/libmythtv/dbcheck.cpp 3593: the command generated for testing the table for unique utf8 entries is ""ALTER TABLE temp_people ADD UNIQUE INDEX verify_unique ( name(41) );"". thus only the first 41 characters are indexed and failures occur if two entries only differ past char 41. removal of the ""(41)"" should fix this problem. " defect closed minor unknown MythTV - General Master Head medium invalid schema upgrade 0