Article ID: 115761, created on Mar 20, 2013, last review on Apr 26, 2014

  • Applies to:
  • Plesk 11.x for Linux
  • Plesk 10.x for Linux
  • Plesk 11.x for Windows
  • Plesk 10.x for Windows


  1. Domain with physical hosting is missing from Apache configuration.
  2. Unable to add domain alias due to error: DB query failed: Duplicate entry 'älías.test' for key 2


Domain and domain alias name field in Plesk database is defined in such way, that causes letters with diacritics (ä, ó) to be treated as letters without diacritics (a, o).


Perform following select using domain name without diacritics in letters on either or psa.domainaliases table:

	mysql> select id, name, displayName from domains where displayName = 'domain.test'
	| id | name                | displayName |
	| 39 | domain.test         | domain.test |
	| 40 | xn--dmin-moa2g.test | d▒m▒in.test |
	2 rows in set (0.00 sec)

If more than two domains/aliases are found while searching for one name, then server is affected by the problem.


The problem is going to be fixed in Parallels Plesk Panel 11.0.9 MU #26.


Definition of column displayName in tables and psa.domainaliases should be changed manually using following SQL statements:

alter table domain_aliases modify displayName VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
alter table domains modify displayName VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;

Note: on Plesk for Windows, domain aliases table is named domain_aliases.

bd7fc88cf1b01f097749ae6f87272128 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 dd0611b6086474193d9bf78e2b293040 29d1e90fd304f01e6420fbe60f66f838 c796c01d6951fa24ed54c7f1111667c6 0a53c5a9ca65a74d37ef5c5eaeb55d7f

Email subscription for changes to this article
Save as PDF