Resolved Help on Deleting Orphaned DNS Entree Command ?

[BobK]

I have an Orphaned DNS entree from a failed domain creation and now i cant add that new domain because it says DNS entree already exists. I found this article on how to remove it

Unable to create a new domain/subdomain or migrate/rename an existing domain/subdomain: DNS record already exists

Applicable to: Plesk for Linux Plesk for Windows Symptoms The article has many reuses, we should try to find the root cause for the inconsistencies when receiving tickets with such problem. ...

support.plesk.com

But I am not following the syntax of the delete commands they want. Assuming the domain name is DOMAIN.ABC could someone provide and example of how to delete that domain from the database?

delete from dns_recs where dns_zone_id in (select id from dns_zone where id not in (select dns_zone_id from domains) and id not in (select dns_zone_id from domain_aliases));

AND

delete from dns_zone where id not in (select dns_zone_id from domains) and id not in (select dns_zone_id from domain_aliases);


Much appreciated! Thanks!

 

[IgorG]

But I am not following the syntax of the delete commands they want.

Why? I think that there is absolutely clearly described steps for resolving the issue. Why not just follow them? What sort of problems with it?

 

[PAWLO]

delete from dns_zone where id not in (select dns_zone_id from domains) and id not in (select dns_zone_id from domain_aliases); Kodi nox