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

[greg]

Michael T. Dean wrote:
> 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)?
>   
After svn update.
>   
>>  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).
>
>   
I checked and i only have myth installed in one location..I did see 
where janneg suggested to drop the db and create a new one if you 
installed after 19221,which i did.
  I believe i have other problems with my DB.. It says i have no 
recordings scheduled but i do and they continue to record.. I ran a 
check on the DB and it shows no crashed tables,so i will drop the DB and 
create a new one..
 
> 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
>   

Thanks, Greg
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>
>