Article ID: 120132, created on Feb 14, 2014, last review on May 9, 2014

  • Applies to:
  • Plesk 11.5 for Linux


In Horde addressbook contacts are broken if they contain umlauts.


Root cause is in the upgrade mechanism


Root cause is in upgrade mechanism. Horde 3 database was encoded in latin1, since Horde 5 database is encoded in utf8. Existing records should be update updated in database to new encoding; but they do not currently. Internal software issue is #PPPM-1391

To workaround the problem you can make database dump with 'latin1' encoding set and restore it with 'utf8' encoding:

Please note that this workaround should be applied ONLY in case no new entries with non-latin symbols were added to Horde address books after upgrade. Otherwise these new entries become corrupted as well.

mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` horde --default-character-set=latin1 --skip-set-charset > hordedump

mysql -uadmin -p`cat /etc/psa/.psa.shadow` horde --default-character-set=utf8 < hordedump`

If the above workaround is applicable for you, then please take the backup of all necessary databases using below commands and apply the above provided workaround:

mkdir /root/__sqlbackups
mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` psa > /root/__sqlbackups/psa.`date +%F_%H.%M`.sql
mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` mysql> /root/__sqlbackups/mysql.`date +%F_%H.%M`.sql
mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` --all-databases > /root/__sqlbackups/all.`date +%F_%H.%M

Search Words


a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 01bc4c8cf5b7f01f815a7ada004154a2 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f

Email subscription for changes to this article
Save as PDF