While trying to change customer contact information, the following error appears:
SQLSTATE: Integrity constraint violation: 1062 Duplicate entry '<customername>' for key 3
The reason is in database inconsistency.
- 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