Plesk error: An operation fails in Plesk: SQLSTATE[23000]: Integrity constraint violation: 1062

Connect to the server via RDP . Script will assist you to fix the inconestancy of plesk db. Download the script to your Server. Extract the script from the zip file on C:\ drive Start a command prompt as an…

All Articles

Connect to the server via RDP.

Script will assist you to fix the inconestancy of plesk db. Download the script to your Server.

Extract the script from the zip file on C:\ drive

Start a command prompt as an Administrator.

Create a backup of the Plesk database:

plesk db dump > C:\psa_dump.sql

Switch to the folder where extracted script on step 2 is stored.

cd C:\

Run the script:

plesk php 115003292185_auto_increment_fix.php -v -y

Rerun the script until you see:

...
No inconsistencies were detected.

Published by

anup

Technical content from the 24x7ServerSupport infrastructure, server management and cloud operations team.