• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

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