Unable to create subdomain: ProtDir_IIS::update() failed: Add Protected Directory failed: columns siteId, path are not unique

Created:

2017-05-31 09:16:13 UTC

Modified:

2017-08-08 13:24:39 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to create subdomain: ProtDir_IIS::update() failed: Add Protected Directory failed: columns siteId, path are not unique

Symptoms

Unable to create subdomain sub.example.com:

Error: ProtDir_IIS::update() failed: Add Protected Directory failed: columns siteId, path are not unique at execute console command --add-protected-url(vconsoleapp::start line 122) at execute "C:\Program Files (x86)\Plesk\admin\bin64\websrvmng.exe" --add-protected-url "--vhost-name=sub.example.com" "--path=plesk-stat" "--realm=Domain statistics"(vconsoleapp::run line 139) (Error code 1)

In Plesk database the following query returns one or more records in dns_recs table:

mysql> select * from dns_recs where host like '%sub%';

Any other subdomains, like sub2.example.com or test.example.com can be created successfully

Cause

Database inconsistency

Resolution

1. Create a database backup according to instructions here.

2. Delete orphan record:

mysql> delete from dns_recs where host like '%sub%';
Have more questions? Submit a request
Please sign in to leave a comment.