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.

About: Mike

Milind Koyande loves to work on new technologies specially virtualization and troubleshoot server problems. I’m an avid photographer and love to spend my free time close to nature, trying to capture its glory on my camera.


One thought on “Fix:- DNSZone::Table::select() failed: no such row in the table”

This site uses Akismet to reduce spam. Learn how your comment data is processed.