Plesk inaccessible: Dependent row(s) 'smb_roles.id = 1' isn't found for 'smb_users.roleId = 1'

Follow

Comments

3 comments

  • Avatar
    Marcin Luniz

    luniz@localhost:~$ sudo plesk db
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A

    Welcome to the MariaDB monitor. Commands end with ; or \g.
    Your MariaDB connection id is 566
    Server version: 10.1.29-MariaDB-6 Ubuntu 18.04

    Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    MariaDB [psa]> INSERT INTO smb_roles VALUES (1,'Admin',1,1),(2,'WebMaster',0,1),(3,'Application User',0,1),(4,'Accountant',1,1);
    ERROR 1136 (21S01): Column count doesn't match value count at row 1
    MariaDB [psa]>

  • Avatar
    Marcin Luniz

    ok. Sorry. THX 

     

    that works, 

    mysql> INSERT INTO smb_roles VALUES (1,'Admin',1,1,0),(2,'WebMaster',0,1,0),(3,'Application User',0,1,0),(4,'Accountant',1,1,0);
    mysql> UPDATE smb_users SET ownerId=1;

  • Avatar
    Anzhelika Khapaknysh

    Hi @Marcin Luniz!

    Glad to know the issue is fixed!
    The article was updated a bit to be more clear.

Please sign in to leave a comment.

Have more questions? Submit a request