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?
-
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
fileSharingUsers
table:mysql> insert into fileSharingUsers(userId,login) select id, login from smb_users where id not in (select userId from fileSharingUsers);
Comments
0 comments
Please sign in to leave a comment.