Unable to open Website & Domains tab

Created:

2016-11-16 13:08:46 UTC

Modified:

2017-08-08 13:41:22 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to open Website & Domains tab

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk Onyx for Linux
  • Plesk 12.0 for Linux

Symptoms

Unable to open Website & Domains tab, the following error is shown:

Internal error:  Dependent row(s) 'smb_apsPackages.id = 19' isn't found for 'smb_apsContexts.packageId = 19'.

Cause

One of the applications was not properly removed, which caused database inconsistency.

Resolution

  1. Create a backup of psa database:
    # plesk db dump psa > psa.sql
  2. Check whether it's possible to find database inconstancy using below command:

    # plesk repair db -n
  3. Analyze errors and fix them using
    # plesk repair db

    To repair all found errors use:
    # plesk repair db -y
  4. If the issue is not fixed, remove orphan records from the psa database manually:

    # plesk db

    mysql> delete from smb_apsPackages where id = 19;
    mysql> delete from smb_apsContexts where packageId = 19;
    mysql> delete from smb_apsMetas where id = 19;
    mysql> delete from smb_apsInstances where metaId = 19;

Note: restore psa database if something goes wrong:

   # plesk db psa < psa.sql

Have more questions? Submit a request
Please sign in to leave a comment.