Parallels Virtualization and Automation Software

SYMPTOMS

When attempting to remove a domain the following error is displayed

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

CAUSE

There could be several possible reasons related to missing values in Plesk database. The number of such problems has been fixed in Plesk 8.2 version.

The problems on Plesk 8.2 could appear in case the domain has installed are:

- Site Application which was removed physically from Application Vault on server level.
- Missed domain alias in DNS zone
- Different values in Plesk database which depend on this domain

RESOLUTION

First of all please consider upgrading Plesk to 8.2 version.

If Plesk version is already 8.2 and the problem still occurs please:

1. Download the following file which fixes the problem with proper Site Application removing:

http://download1.swsoft.com/Plesk/Autoupdate/Windows/8.2.0/125688/class.SiteAppManager.php
and place it to %plesk_dir%\admin\plib\SiteApps\ folder.

2. Download the following file to fix the issue with missed domain alias dns zone:

http://download1.swsoft.com/Plesk/Autoupdate/Windows/8.2.0/125908/DomainAlias.php

and place it to %plesk_dir%\admin\plib\domainaliases\

3. Download the following file to eliminate object dependence in Plesk database:

http://download1.swsoft.com/Plesk/Autoupdate/Windows/8.2.0/125908/class.PhDomain.php
and copy it to %plesk_dir%\admin\plib

Note: Please see how to install Plesk hotfixes properly.

When it is done, please try to remove domain again.

Note that the error is quite common and appears in case of any database value is missed. So provided solution is for most often arising problems only.

In case the issue still exists after upgrade and hotfix installation, please contact plesk support to resolve one.

Additional information

%plesk_dir% is environment variable which points to Plesk installation folder. By default it is C:\Program Files\SWsoft\Plesk

%plesk_bin% is environment variable which points to Plesk binaries folder. By default it is C:\Program Files\SWsoft\Plesk\admin\bin