Unable to access to Subscriptions, Users or WordPress tabs: 'smb_apsMetas.id = ' isn't found for 'smb_apsInstances.metaId = '.

Created:

2016-11-16 12:46:00 UTC

Modified:

2017-08-16 17:12:47 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to access to Subscriptions, Users or WordPress tabs: 'smb_apsMetas.id = ' isn't found for 'smb_apsInstances.metaId = '.

Applicable to:

  • Plesk 11.x for Linux
  • Plesk 12.0 for Linux

Symptoms

Unable to access to Subscriptions , Users or WordPress tabs:

Internal error: Dependent row(s) 'smb_apsMetas.id = 62' isn't found for 'smb_apsInstances.metaId = 62'.

Message Dependent row(s) 'smb_apsMetas.id = 62' isn't found for 'smb_apsInstances.metaId = 62'.
File Abstract.php
Line 297
Type Exception
Go To Previous Page

Cause

Database inconsistency.

Resolution

  1. Check whether entry is missing:

    mysql> select * from smb_apsMetas where id=62;
    Empty set (0.00 sec)
  2. Find the missing record in dumps of psa dtabase at /var/lib/psa/dumps/ :

    # zgrep -i "smb_apsMetas (62" /var/lib/psa/dumps/mysql.daily.dump.*
    /var/lib/psa/dumps/mysql.daily.dump.0.gz:INSERT INTO smb_apsMetas values (62,'Drupal','','aps::aps12::Drupal::drupal','',95);
  3. Create backup of psa database:

    # plesk db dump  > psa.sql
  4. Insert the missing record.

    mysql> insert into smb_apsMetas values (62,'Drupal','','aps::aps12::Drupal::drupal','',95);
    Query OK, 1 row affected (0.08 sec)
Have more questions? Submit a request
Please sign in to leave a comment.