[mythtv] [mythtv-commits] Ticket #5957: Preserve collation of people.name to prevent duplicate errors

[Michael T. Dean]

On 12/03/2008 09:41 AM, greg wrote:
> MythTV wrote:
>   
>> #5957: Preserve collation of people.name to prevent duplicate errors
>>
>>  The attached patch modifies the 1226 update and the initial database
>>  creation code to maintain the utf8_bin collation for people.name.
> I am not sure it's proper to respond here or not,if not i apologize in 
> advance..
>   

Yep.  Much better place than in the bug database.  :)

> Sphery thanks for the help. I did have one problem,the data base would 
> not update when running mythtv-setup..

Do you mean after applying the patch (or after an svn update after it 
was committed by Janne at 2008-12-03 13:46:10 +0000 today)?

>  I then tried running the 
> mythbackend and it allowed the database to update..It runs fine 
> now..Thanks to you and kormoc..

If so (if after the patch was in place), it sounds like you may have 
multiple versions of Myth installed to different locations (/usr and 
/usr/local, perhaps), such that when calling "mythtv-setup" (probably 
without path information), it runs the older version and when starting 
mythbackend (probably with an init script, which may contain path 
information) it runs the newer version.  If that's the case, you'll want 
to remove one of the installations (feel free to ask for help on IRC).

Since both mythtv-setup and mythbackend use the same code to update the 
database, I can't think of any other reason one would work and the other 
wouldn't.  And, I can't think of any reason that the update would 
succeed after failing once if the patch weren't applied (i.e. no rows 
are removed from the database in the event of failure, so the same 
rows--JoAnna Garcia and Joanna Garcia in this case--would be there to 
cause a failure the second time, and the only way I can see to prevent 
the failure is to either delete one of the duplicate rows manually or to 
preserve the collation, as the patch does).

Then again, I don't have my database expert, kormoc, to set me straight, 
here, so there may be some magic happening that I don't know about.  :)

Mike