Unable to find row by field login with value

Created:

2016-11-16 12:48:14 UTC

Modified:

2017-08-16 17:13:05 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to find row by field login with value

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk Onyx for Windows
  • Plesk 11.x for Windows
  • Plesk 11.x for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux
  • Plesk 12.5 for Windows

Symptoms

When trying to access the domain from the domains plane, the following error occurs:

    Unable to find row by field login with value 'domain.tld' in smb_users table.

I can also see that the login filed differs from the displayed one in the error message.

mysql> select login from smb_users where email='example@domain.tld';
+-----+------------+
| id | login |
+-----+------------+
|ID## | domain2.tld|
+-----+------------+
1 row in set (0.00 sec)

Cause

Wrong login field value in smb_users tables in psa database.

Resolution

  1. Create backup of the psa database:

    # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` psa > /tmp/psa.`date +%F_%H.%M`.sql
  2. Change login field for the record with id='ID##' to 'domain.tld'

    mysql> update smb_users set login='domain.tld' where id=ID##;
Have more questions? Submit a request
Please sign in to leave a comment.