Error: DNSZone::Table::select() failed: no such row in the table

[sajugovind]

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.......