DNSZone::Table::select() failed: no such row in the table

So that error came. It so happen a user mistakenly suspendd the account, and when he tries to unsusped it, the error comes out. SO what do we have to do? To be honest im not sure myself, just try2 googing around.

Heres what i did:

1) Open CMD as ADMINISTRATOR (importatnt 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', 'user@email.com');"

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';"

And wallah! :D

Thans for guides here : http://www.supportsages.com/blog/2009/08/plesk-account-unsuspension-tableselect-failed-no-such-row-in-the-table/



Popular posts from this blog

SAP Fiori Launchpad Activation via Task List (STC01)

Windows 2003 W2k3 Getting Current MTU Size