DNS zone of a domain alias cannot be edited because the domain alias is turned off

Question

If a domain not resolving to the server IP and on activating the DNS zone of a domain can give the error “DNS zone of a domain alias cannot be edited because the domain alias is turned off”. To correct this you need to check and change the domain status.

Answer 1

Open up command prompt in Remote Desktop and type the command

cd %plesk_bin%

dbclient.exe --direct-sql --sql="update dns_zone set status=0

where name='domain.com';

Finally login to plesk and switch off and on the DNS and it should fix the issue.