Articles in this section

See more

Unable to update hosting settings of a subscription in Plesk: Integrity constraint violation: 1062 Duplicate entry '18-username-username-us' for key 'pd_id'

Avatar
Alexey Lapshin
Updated
Follow
kb: fixed kb: bug ABT: Group A Plesk Obsidian for Linux

Applicable to:

  • Plesk Obsidian for Linux

Symptoms

Since update to Plesk Obsidian 18.0.27, unable to change hosting settings of a subscription, or manage Apache & nginx Settings menu:

PLESK_ERROR: Error: DB query failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '18-username-username-us' for key 'pd_id', query was: insert into pd_users (`id`,`login`,`account_id`,`pd_id`) VALUES ('0','example.com','70','18')

Cause

Product issue:

  • #PPPM-11955 "Hosting settings can now be changed if the sysuser login has more than 20 characters."
    Fixed in:

Resolution

Please consider updating your server:

Workaround

If update is not possible for some reason you may try the following

workaround

Until the fix will be available follow these steps as a workaround, :

  1. Connect to the server via SSH with root privileges.

  3. Run this command to modify psa.pd_users table:

    # plesk db "ALTER TABLE pd_users MODIFY COLUMN login VARCHAR(32)"

 

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles