Article ID: 120204, created on Feb 18, 2014, last review on Apr 25, 2014

  • Applies to:
  • Plesk 11.0 for Linux


While trying to change customer contact information, the following error appears:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '<customername>' for key 3


The reason is in database inconsistency.


  1. Backup 'psa' database.
  2. Forcibly update all the customers configurations in database by using the below command:.

    mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -Ne "select login, email from clients where id != 1" | while read login email; do /usr/local/psa/bin/client -u $login -email $email; done

Search Words


SQLSTATE[23000]: Integrity constraint violation.

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c aea4cd7bfd353ad7a1341a257ad4724a 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f

Email subscription for changes to this article
Save as PDF