- Plesk 12.5 for Linux
- Plesk 11.x for Linux
- Plesk 12.0 for Linux
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'.
Missing entries in
Note : Before performing any actions with database create a backup according to the article How to backup/restore a Plesk database dump?
Connect to Plesk database:
# plesk db
Identify the missing entries:
mysql> select count(*) from smb_users where id not in (select userId from fileSharingUsers);
| count(*) |
| 230 |
Insert the missing values into the
mysql> insert into fileSharingUsers(userId,login) select id, login from smb_users where id not in (select userId from fileSharingUsers);