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:ParallelsPleskadminbin>websrvmng.exe --remove-vhost --vhost-name=[domainname.com]

2) Then reconfigured it :

C:ParallelsPleskadminbin>websrvmng.exe --reconfigure-vhost --vhost-name=[domainaname.com]

3) Then updated the DNS Zones :

C:ParallelsPleskadminbin>DNSMng.exe UPDATE [domainname.com]

Now try to delete the domain from Plesk.

About Milind Koyande

Milind Koyande is the Senior Research Engineer and his job is to work with new technologies, specially Cloud Computing / Virtualization Technology. His past projects include Government Sector initiatives, Backup and Disaster Recovery Solutions.

Tags: dbclient.exe, DNSZone::Table::select, DNSZone::Table::select() failed, DNSZone::Table::select() failed: no such row in the table, Plesk DNS Error