[mythtv] [mythtv-commits] Ticket #5957: Preserve collation of people.name to prevent duplicate errors
Michael T. Dean
mtdean at thirdcontact.com
Wed Dec 3 16:16:44 UTC 2008
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
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. :)
More information about the mythtv-dev