Opened 9 years ago

Closed 9 years ago

Last modified 9 years ago

#8762 closed defect (invalid)

DB Schema Upgrade from 0.21 fails

Reported by: Martin Bene <martin.bene@…> 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)

comment:1 Changed 9 years ago by Martin Bene <martin.bene@…>

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

comment:2 Changed 9 years ago by robertm

Resolution: invalid
Status: newclosed

Thanks for at least coming back and mentioning it :)

comment:3 Changed 9 years ago by sphery

User was using a pre-release version of 0.22. This was fixed in [22081] before 0.22 release.

Note: See TracTickets for help on using tickets.