Unable to manage subscription: Unable to find row by field login with value admin in the smb_users table

Created:

2017-02-14 21:45:58 UTC

Modified:

2017-08-16 16:26:00 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to manage subscription: Unable to find row by field login with value admin in the smb_users table

Applicable to:

  • Plesk for Linux

Symptoms

  • On a fresh Plesk installation it is unable to manage subscription with the following error:

    Unable to find row by field login with value admin in the smb_users table
    
  • The following mysql querry gives an empty output

    mysql> SELECT `smb_users`.* FROM `smb_users` WHERE (`login` = 'admin');
    
    Empty set (0.01 sec)

Cause

Database inconsistency. Admin's information is not recorded in psa database.

Resolution

Go to Profile & Preferences under admin user and click OK .

prefs.png

If Plesk is not accessible with the same error, restore recent daily dump of Plesk database, when Plesk was accessible in Plesk dump directory:

# grep DUMP_D /etc/psa/psa.conf
DUMP_D /var/lib/psa/dumps

And restore it according to the steps in How to backup/restore a Plesk database dump article.

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