Error on modifying an object in Plesk: Dependent row(s) isn't found

Created:

2016-11-16 12:40:27 UTC

Modified:

2017-08-16 18:35:08 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Error on modifying an object in Plesk: Dependent row(s) isn't found

Applicable to:

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

Symptoms

The following error is shown while performing operations on Plesk objects (i.e. subscriptions, mailboxes etc.):

Error: Unable to execute file-sharing: ERROR: Dependent row(s) 'FileSharingUsers.userId = 268' isn't found for 'smb_users.id = 268'.

Cause

Missing entries in fileSharingUsers table.

Resolution

Note : Before performing any actions with database create a backup according to the article How to backup/restore a Plesk database dump?

  1. Connect to Plesk database:

    # plesk db
    
  2. Identify the missing entries:

    mysql> select count(*) from smb_users where id not in (select userId from fileSharingUsers);
    +----------+
    | count(*) |
    +----------+
    |      230 |
    +----------+
  3. Insert the missing values into the fileSharingUsers table:

    mysql> insert into fileSharingUsers(userId,login) select id, login from smb_users where id not in (select userId from fileSharingUsers);
    

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