Hi,
Sometimes you get failed upgrade or data storage issues due to corrupted database structure. You can fix such types of issues by using the following steps.
1. Back up the Parallels Plesk Panel database before applying any changes.
2. Check the database structure to display issues in the Parallels Plesk Panel database:
/usr/local/psa/admin/bin/php check_db.php --by-problem | --by-table
3. Run the utility with --help to get a list of all available options:
/usr/local/psa/admin/bin/php check_db.php --help
4. Show the recommended SQL instructions to fix the database inconsistency issues:
/usr/local/psa/admin/bin/php check_db.php --sql
5. Fix the database structure by applying the recommended SQL instructions.
6. Check the database after making the changes.
