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

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);