[horde] horde-db-migrate error

[Jan Schneider]

Zitat von Vilius ?umskas <vilius at lnk.lt>:

> Sveiki,
>
> Monday, April 11, 2011, 4:12:01 PM, you wrote:
>
>> Thanks to ronan from another thread. That problem found a solution:
>
> mysql>> update kronolith_events set event_creator_id=lower(event_
>> creator_id);
>
>> some users logged in a long time ago, and ldap is case insensitive. So some
>> records were added using a capital and generating a duplicate key error.
>> Don't know what could be the fix is uids are sensitive..
>
> I  saw  similar  behaviour with IMAP auth backend, which in my case is
> also  case  insensitive. Did not had trouble upgrading, but saw a fair
> amount  of "duplicate" uids in pref table. There were "duplicates" not only
> by   case,  but  also such  usernames  as  "user1 at example.com"  and
> "user1 @example.com" (note space after username).

User names are case and whitespace sensitive in Horde. If your  
authentication backend is not, you have to normalize user names with  
user name hooks.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/