• Debian 11 is approaching its end-of-life (vendor EOL date - August 31, 2026). Plesk Obsidian 18.0.80 will be the last release to support it.
    If you are running Plesk Obsidian on Debian 11, we recommend you upgrade those servers to Debian 12 using our dist-upgrade tool.
  • We plan to deprecate and remove the support for XML RPC protocol versions earlier than 1.6.9.1 in Plesk Obsidian 18.0.82. We strongly recommend that you update all existing integrations using earlier versions of the XML RPC protocol to comply with the version 1.6.9.1 specification.

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