DNS error while unsuspending domain in Plesk
Hi,
If you receive the error message "DNSZone::Table::select() failed: no such row in the table" while un-suspending domains or when you click on the "DNS Settings" button in the Plesk control panel hosted on Windows server, follow the steps below to get this sorted out.
Error:
"DNSZone::Table::select() failed: no such row in the table"
Solution :
1) Open CMD as ADMINISTRATOR (important to "run as administrator"
2) C:\>"%plesk_bin%"\dbclient.exe --direct-sql --sql="INSERT INTO dns_zone (name, displayName, email) VALUES ('poesyliang.net', 'poesyliang.net', '[email protected]');"
3) C:\>"%plesk_bin%"\dbclient.exe --direct-sql --sql="SELECT id, name FROM dns_zone where name='poesyliang.net';"
id name
46 poesyliang.net
47 poesyliang.net
4) C:\>"%plesk_bin%"\dbclient.exe --direct-sql --sql="UPDATE domains SET dns_zone_id='47' WHERE name='poesyliang.net';"
Once the above commands are executed, you can now go ahead & perform the desired changes..
If you receive the error message "DNSZone::Table::select() failed: no such row in the table" while un-suspending domains or when you click on the "DNS Settings" button in the Plesk control panel hosted on Windows server, follow the steps below to get this sorted out.
Error:
"DNSZone::Table::select() failed: no such row in the table"
Solution :
1) Open CMD as ADMINISTRATOR (important to "run as administrator"
2) C:\>"%plesk_bin%"\dbclient.exe --direct-sql --sql="INSERT INTO dns_zone (name, displayName, email) VALUES ('poesyliang.net', 'poesyliang.net', '[email protected]');"
3) C:\>"%plesk_bin%"\dbclient.exe --direct-sql --sql="SELECT id, name FROM dns_zone where name='poesyliang.net';"
id name
46 poesyliang.net
47 poesyliang.net
4) C:\>"%plesk_bin%"\dbclient.exe --direct-sql --sql="UPDATE domains SET dns_zone_id='47' WHERE name='poesyliang.net';"
Once the above commands are executed, you can now go ahead & perform the desired changes..
My friend issue has been resolved. 
always 
Rock
Comment