Error on creating new mailbox: Unable to execute file-sharing

Created:

2016-11-16 12:40:27 UTC

Modified:

2017-04-24 11:34:27 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Error on creating new mailbox: Unable to execute file-sharing

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux

Symptoms

The following error is shown while creating email account:

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

  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. Add those entries by following steps:

    • Create a temporary table paratest :

      mysql> create table paratest ( id INT NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, PRIMARY KEY ( id ) );
    • Insert the missing values into paratest :

      mysql> insert into paratest(id,name) select id, login from  smb_users where id  not in (select userId from fileSharingUsers);
      
    • Add those entries to the fileSharingUsers table:

      mysql> insert into fileSharingUsers(userId,login) select id,name from paratest;
      

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

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