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

Sometime while deleting domain from Plesk it throws following Error:

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

This error occurs when there were invalid columns in DNS table of Plesk Database.

You can check if there is a invalid column in database using following command

"%plesk_bin%"\dbclient.exe --direct-sql --sql="SELECT domains.name FROM domains LEFT JOIN dns_zone ON domains.dns_zone_id = dns_zone.id WHERE dns_zone.id IS NULL"

The server on which I have face has following invalid columns

dns_zone.serial default value: actual = "0" expected = no value
dns_zone.serial NULL attribute: actual = false

Solution:

1) We have removed the vhost setting by following command :

C:\Parallels\Plesk\admin\bin>websrvmng.exe --remove-vhost --vhost-name=[domainname.com]

2) Then reconfigured it :

C:\Parallels\Plesk\admin\bin>websrvmng.exe --reconfigure-vhost --vhost-name=[domainaname.com]

3) Then updated the DNS Zones :

C:\Parallels\Plesk\admin\bin>DNSMng.exe UPDATE [domainname.com]

Now try to delete the domain from Plesk.