• 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!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    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.

Forwarded to devs SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry after Update 18.0.26 to 18.08.27

straddi

Basic Pleskian
User name: straddi

TITLE

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry after Update 18.0.26 to 18.08.27

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE

Obsidian, Debian 9.12‬

PROBLEM DESCRIPTION
After the update from Obsidian 18.0.26 to 18.08.27, the hosting settings cannot be updated on a website.

STEPS TO REPRODUCE

Update from Obsidian 18.0.26 to 18.08.27

ACTUAL RESULT

Database error
ERROR: DB query failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '11-example' for key 'pd_id', query was: insert into pd_users (`id`,`login`,`account_id`,`pd_id`) VALUES ('0','example','136','11')

EXPECTED RESULT

Hosting settings can be changed

ANY ADDITIONAL INFORMATION

I imported a backup. In 10.0.26 the hosting settings can be changed. After that I only carried out the update to 10.0.27. The error occurs.

YOUR EXPECTATIONS FROM PLESK SERVICE TEAM

Confirm bug
 
Back
Top