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.

Amplify’d from eitwebguru.com

Read more at eitwebguru.com

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

Solution:

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

Read more at eitwebguru.com

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s