Article ID: 124615, created on Feb 26, 2015, last review on Feb 26, 2015

  • Applies to:
  • Web Presence Builder 12.0
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 11.5 for Windows


Attempts to change Administrator's interface language under Home > Profile & Preferences fails with the following message:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'


The issue is caused by missing user admin in smb_users table of Plesk psa.database.


Steps to resolve the issue:

  1. Make a backup copy of the psa and apsc databases:

    # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa > ~/psa.`date +%F_%H:%M`.sql
    # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` apsc > ~/apsc.`date +%F_%H:%M`.sql
  2. Check entry for user admin in psa.smb_users table:

    mysql> select * from smb_users where login='admin';
    Empty set (0.00 sec)

    The user with login name admin always has id = 1:

    mysql> select id,login from smb_users where id=1;
    | id |         login          |
    |  1 |    <not_admin_login>   |

    As it can be seen the login name set up incorrectly.

  3. Set up correct name:

    mysql> update smb_users set login='admin' where id=1;

Search Words

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'

Integrity constraint violation


Error change Administrator's interface language

ed7be2b984f9c27de1d2dc349dc19c6d 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 a766cea0c28e23e978fa78ef81918ab8 29d1e90fd304f01e6420fbe60f66f838 9305481d3bd31663b68451e3bfdec5a5 01bc4c8cf5b7f01f815a7ada004154a2 0a53c5a9ca65a74d37ef5c5eaeb55d7f 46a8e394d6fa13134808921036a34da8 bd7fc88cf1b01f097749ae6f87272128 1c99f07514acb28df1f1cbc138d5c135

Email subscription for changes to this article
Save as PDF