Error: DNSZone::Table::select() failed

Error DNSZone
This article will help you to fix the issue "Error: DNSZone::Table::select() failed: no such row in the table”.

If you get the error “Error: DNSZone::Table::select() failed: no such row in the table” while choosing the DNS settings from your Plesk control panel(Windows ), you can follow the steps given below to fix it.

1).  Login to mysql using the Plesk administrator password,

cd %plesk_dir%Mysqlbin
mysql -u admin -p -P 8306

 

2). Select the psa database.

use psa;

 

3. Execute the following SQL query in mysql prompt to find those domains with the wrong zone ids.

SELECT domains.name FROM domains LEFT JOIN dns_zone ON domains.dns_zone_id = dns_zone.id WHERE dns_zone.id IS NULL;

 

4. Comparing the dns_zone_id in tables ‘domains’ and ‘dns_zone’.

mysql> select dns_zone_id,name from domains;
mysql> select id,name from dns_zone;

 

5. Manually inserted those missing zone id entries in the ‘dns_zone’ table using the insert query statement.

mysql> INSERT INTO dns_zone SET id= zone id, name='domain name';

 

Change zone id with the exact id and name with the exact domain which you want to insert.

 

That will fix all the issues!

Share this post

Services to Explore

Stay up to date!

Stay up to date with the Web Hosting, Cloud and Server Management Industry News and Tutorials!

We will send you only the relevant emails, and we respect your privacy. Please review our privacy policy for more info.

Plesk Management Services

Focus on your business, and let us take care of your Plesk Servers!
From what you are reading, it seems you are interested in Plesk and related technologies. If you have a moment to spare, please take a look at our Plesk Server Management Services plan, and which might interest you even more!
Plesk Server Management Plan

Value-Added Services

We have services that can help you run a successful business. With us, you don't have to worry about these areas because our experts will take care of it for you.

ServerHealers uses cookies.