Article ID: 1360, created on Oct 6, 2008, last review on Jun 3, 2016

  • Applies to:
  • Odin Business Automation Standard 4.5
  • Plesk 11.5 for Windows


  1. Unable to manage domain or a customer (suspend/resume/remove, etc.);

  2. Unable to manage hosting settings;

  3. Unable to access DNS Settings menu:

    Error: DNSZone::Table::select() failed: no such row in the table
  4. Plesk domains are added in HSPcomplete, but the DNS zones are not created in the HSPcomplete name servers automatically.

The complete error looks like this:

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

0: /usr/local/psa/admin/plib/dns/DNSZone.php:52
    DNSZone->DNSZone(string '100')
1: /usr/local/psa/admin/plib/common_func.php3:2610
    objectMaker(string 'DNSZone', string '100')
2: /usr/local/psa/admin/plib/dns/DNSManager.php:39
    DNSManager::getDNSZone(string '100')
3: /usr/local/psa/admin/htdocs/domains/dns.php:21


Database inconsistency: dns_zone_id record in domains table points to a non-existent ID record in the dns_zone table for one or several domains.


  1. Make psa database backup:


    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin psa  > FILE_NAME.sql


    "%plesk_dir%"\Mysql\bin\mysqldump.exe -uadmin -p<plesk_admin_password> -P8306 psa > backup_name.sql
  2. Log in to Plesk database:


    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa


    "%plesk_dir%"\Mysql\bin\mysql.exe -uadmin -p<plesk_admin_password> -P8306 psa
  3. Find affected domains that have missing IDs:

    mysql> SELECT FROM domains d LEFT JOIN dns_zone z ON WHERE IS NULL;
  4. For each reported domain, create appropriate zone in the dns_zone table:

    mysql> INSERT INTO dns_zone (name, displayName, email) VALUES ('', '', '');
  5. Determine the new zone ID:

    mysql>  SELECT id, name FROM dns_zone where name='';
  6. Substitute dns_zone_id in domains table with the correct value obtained from the previous step: сф mysql> UPDATE domains SET dns_zone_id='' WHERE name='';

  7. For each affected domain, go to Home > Domains > > Website & Domains > DNS and use Default button to regenerate the DNS records.

Search Words

user failed: ftpmng --remove-user failed



no able to modify dns recors

Table 'psa.protected_dirs' doesn't exist

sub-domain removal fail

Unable to restore the DNS zone

Internal error: is out of webspace


DNSZone::Table::select() failed:

delete domain

Remove Domain and Recreate as Forward

IP address is not changed for a subdomain

Some of the selected domains or aliases were not activated

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

Execute websrvmng failed

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

ERROR: PleskObjectNotFoundException

remove doman

dns settings

Reseller account activation

Could not connect to Plesk Agent host or response is empty.

no such row in table

unable to open DNS Settings

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 85a92ca67f2200d36506862eaa6ed6b8 46a8e394d6fa13134808921036a34da8 bd7fc88cf1b01f097749ae6f87272128 400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065 624ca542e40215e6f1d39170d8e7ec75 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF