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.
Sometime while deleting domain from Plesk it throws following Error:
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
1) We have removed the vhost setting by following command :