Opened 14 years ago
Closed 14 years ago
Last modified 14 years ago
#8762 closed defect (invalid)
DB Schema Upgrade from 0.21 fails
Reported by: | Owned by: | ||
---|---|---|---|
Priority: | minor | Milestone: | unknown |
Component: | MythTV - General | Version: | Master Head |
Severity: | medium | Keywords: | schema upgrade |
Cc: | Ticket locked: | no |
Description
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.
Change History (3)
Note: See
TracTickets for help on using
tickets.
original unique constraaint on people table as of db version 1038 should also have been 41 - must have manualy changed the existing constraint. please close. sorry for the noise