Plesk account unsuspension – Table::select() failed: no such row in the table

Account was suspended and now when trying to unsuspend it was causing errors like

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

Environment : Plesk 9.2 and Windows 2003 OS.

Solution

Identify the database which plesk uses. Now a days plesk choose MSAccess as the Database. Earlier days the choice was MSSQL and MySQL. Better choices now. Details on how to edit the database is at this KB url : http://kb.parallels.com/en/3472

Once you have it follow the next KB available at http://kb.parallels.com/en/1360 . This KB is meant for MySQL. But all other steps will work for MSAccess DB as well. Usually DB is at %plesk_bin%\admin\db\psa.mdb

Basically a few commands

find domains which have missed ID:

mysql> SELECT d.name FROM domains d LEFT JOIN dns_zone z ON d.dns_zone_id=z.id WHERE z.id IS NULL;

Then for each reported domain do the following:

1. create appropriate id records with following commands, do not forget to replace DOMAN-NAME with a real domain name and ADMIN-EMAIL with a correct email:

mysql> INSERT INTO dns_zone (name, displayName, email) VALUES ('DOMAIN-NAME', ‘DOMAIN-NAME', 'ADMIN-EMAIL');

2. know new zone ID:
mysql>  SELECT id, name FROM dns_zone where name='DOMAIN-NAME';

3. substitute correct ID into psa.domains table, don’t forget to replace DOMAN-NAME and DNS-ZONE-ID with correct values:

mysql> UPDATE domains SET dns_zone_id='DNS-ZONE-ID' WHERE name='DOMAIN-NAME';

Once it is done, take DNS Settings and then under the domain in question, do Restore Defaults. After that do the needed modification along with unsuspension of the domain. It should work!! Or else make it work

Related posts:

1. Fix: Error: Table::select()failed: no such row in the table (In a plesk Windows server)
2. Solving DNS related issues with Plesk running on windows platforms
3. Manually removing the domains from plesk – when plesk frontend don’t work
4. Unable to delete a domain from Windows Plesk
5. Solving “Service Unavailable” message just for one website in Plesk and IIS7