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 FROM domains LEFT JOIN dns_zone ON domains.dns_zone_id = WHERE 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


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

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

2) Then reconfigured it :

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

3) Then updated the DNS Zones :

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

Now try to delete the domain from Plesk.