SymptomsIt is impossible to create domain with national symbols with the name which is close to existing domain with Latin characters.
I.e. there is existing domain - domain.com. When trying to create domain - domaiñ.com, Plesk returns the error:
Domain already exists
MySQL is used as Plesk database engine.
CauseThe reason of the problem is that MySQL collation does not recognize national symbols from ASCII ones. So when domain with the “same” name in ASCII is already exists MySQL does not allow to create new one with close name with national symbols.
Resolution1. Open cmd
2. Go to %plesk_dir%\mysql\bin folder
3. Login to MySql
mysql –uadmin –p<plesk_password> -P8306 psa
4. Execute the following mysql commands to drop current domain name checking and allow to recognize national symbols in close domain names:
drop index displayName on domains;
create index displayname on domains(displayname);
5. Exit from mysql using quit; command.
Now it should be possible to add domains with close name using national symbols.
%plesk_dir% is environment variable which points to Plesk installation folder. By default it is C:\Program Files\SWsoft\Plesk
%plesk_bin% is environment variable which points to Plesk binaries folder. By default it is C:\Program Files\SWsoft\Plesk\admin\bin