Error during Plesk upgrade: There are duplicated entries in db_users table

Created:

2016-12-12 03:43:11 UTC

Modified:

2017-08-17 09:53:34 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Error during Plesk upgrade: There are duplicated entries in db_users table

Applicable to:

  • Plesk 12.0 for Linux

Symptoms

During the Plesk upgrade, the following message appears:

CONFIG_TEXT: EMERGENCY: There are duplicated entries in db_users table: test,test. Rename the database users to resolve the duplication.

Cause

There are two database users with the same username.

Resolution

Connect to the server using SSH and login to Plesk database and rename one of the users from the error message:

# plesk db
mysql> select login,id from db_users where name='test';

Find one of duplicate IDs, for example 8, and update it.

MYSQL_LIN: mysql> update db_users set login='test2' where id=8;

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