[imp] Horde_Prefs db-schema upgrade crashes identities

[Jan Schneider]

Zitat von norbi <norbi at rocknob.de>:

>> Zitat von norbi <norbi at rocknob.de>:
>>
>>> Hi List,
>>>
>>> next day, next problem :(
>>> After upgrading the db-shema for Horde_prefs via the webinterface,  
>>> horde 5.0.4/imp 6.0.4 dont shows existing identitys.
>>>
>>> Its reproducable, in database i can see alls identitys(select *  
>>> from horde_prefs where pref_uid='name at domain.tld' and pref_name  
>>> ='identities'), but horde dont use/listen them. So we have lost in  
>>> one account about 140 identitys in another one "only" 5!
>>> I think it has to do with umlauts in this identitys, like name of  
>>> Identity "Standardidentität"
>>>
>>> any hints ?
>>>
>>> Norbert
>>
>> You probably change the charset in either your database or the sql  
>> configuration while upgrading.
>
> is there a way to repair the defect identities? i cant find any  
> charset changes between the update :(

With a bit of PHP and charset knowledge, probably.
-- 
Jan Schneider
The Horde Project
http://www.horde.org/