Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: Error: DNSZone::Table::select() failed: no such row in the table  (Read 4043 times)

0 Members and 1 Guest are viewing this topic.

sajugovind

  • Guest
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 use the following steps to fix the issue.

1. Login to mysql using the plesk administrator password,

Code: [Select]
cd %plesk_dir%\Mysql\bin
mysql -u admin -p -P 8306

2. Select the psa database.

Code: [Select]
use psa;
3. Execute the following sql query in mysql prompt to find those domains that have the wrong zone ids.

Code: [Select]
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’.

Code: [Select]
mysql> select dns_zone_id,name from domains;
mysql> select id,name from dns_zone;
5. Manually inserted those missing zone id entries in ‘dns_zone’ table using the insert query statement.
Code: [Select]
mysql> INSERT INTO dns_zone SET id= zone id, name='domain name';
Change zone id with exact id and name with the exact domain which you want to insert.

That will fix all the issues!

Thank you.......