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:- Plesk Obsidian 25 May 2020 (Linux)
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, :
-
Connect to the server via SSH with root privileges.
-
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.