hi

We are getting an error when we try create subdomain (Subdomain on subfolder ) under www.example.com domain

check attached screen shot for your reference. Let me know what to do to resolve this issue

we are using Windows Server 2008 RC2 & Plesk Panel 9.5

I've Forgot to attach screen here , see here

As per the error, DNS zone already exists in backend and your control panel is probably out of sync with it. Hence, you can try to delete zone manually from DNS and then try to recreate sub domain from plesk panel.

As per the error, DNS zone already exists in backend and your control panel is probably out of sync with it. Hence, you can try to delete zone manually from DNS and then try to recreate sub domain from plesk panel.

Can you guide me step by step as i don't know how to do this ?

Nileshparmar,

The reason it fails is because the DNS records of the domain already exist in the psa database. The tables dns_recs and dns_zone holds the DNS records for a domain.

In order to add the domain example.com, you will have to remove the DNS entries from the tables dns_recs and dns_zone.

If you are using Mysql for Psa database follow below steps

1.Use the psa database

mysql> use psa;

2) Remove the DNS entries from the dns_recs and dns_zone tables:

mysql> delete from dns_recs where dns_zone_id=10;
mysql> delete from dns_zone where id=10;

where, 10 is the dns_zone_id of the domain example.com.

If it is MSSql or Ms Access Database You can easily delete specific entries through Graphical User interface.

Regards,
Kevin

The reason it fails is because the DNS records of the domain already exist in the psa database. The tables dns_recs and dns_zone holds the DNS records for a domain.

I thought dns record exists on dns server.
If this is the case, go to Administration Tools -> DNS to remove dns record.

Hi Nilesh ,

If its a windows server , then download and install sqlfront on your server as plesk stores its database in Mysql , then you need to login to sqlfront with localhost , username : admin , mysql password which = plesk password , remember to use port 8306 to connect with sql front . After connecting with sql front , you will see psa database , please be carefull while editing the psa database as its has the whole servers data . Now select the dns database , click data browser in the right pane , select the subdomain and delete the dns record . Now you can add the subdomain without any issues.

Prashant J
Windows System Administrator.

Exactly the problem which I had ... it normally happens when theres a miss-configurations in dns records .../not sure.

Check whether you have any entry in the dns of the main domain for the subdomain first and remove the same. If its not there i think there is kb in parallels for removing dns entry from plesk database.

It looks like DNS server zone existence issue you must have removed manually and added again through control panel, by now you would have solved, did you get solution for this? if so post it here what caused the issue.

There is discrepancy between Plesk PSA database and the real DNS records of your server.
Please check your Plesk control panel whether you see a subdomain record in Plesk, if not then Plesk database is not guilty, then access your server via RDC, locate plesk folder/dns, and delete the records of the mentioned subdomain manually by opening the records by notepad.