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.
One thought on “Fix:- DNSZone::Table::select() failed: no such row in the table”
You must log in to post a comment.