Duplicate entry when editing login parameters

Petr

New Pleskian
When you try to change the password of the client to login the control panel gives an error:
SQLSTATE [23000]: Integrity constraint violation: 1062 Duplicate entry '<login>' for key 'login'

The impression that instead of UPDATE done INSERT.
How to fix it?

Parallel Plesk Version: 11.5
OS: Debian Squeeze

P.S. Sorry for my bad English. I'am use Google Translate.
 
OK.
It says about the contact information, and in my case the error when changing the password.
'<any_username>' for key 'login'

How should look like this script in this case?
Code:
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

This method has not resolved the problem.
 
Last edited:
Back
Top