Plesk Installer fails during Plesk database scheme upgrade: "Table 'psa.PleskPagesStat' doesn't exist" or "Unknown column 'la.action_id' in 'on clause'"

Symptoms

Plesk Installer fails with one of the error messages below:

CONFIG_TEXT: ===> Plesk database scheme upgrade has been started.
Applying migrations from: /usr/local/psa/bootstrapper/pp18.0.78-bootstrapper/migrations/
Migration failed: 17.5.0/2016-12-26-09-56-48_change_dates_default_value.php
Table 'psa.PleskPagesStat' doesn't exist

CONFIG_TEXT: Applying migrations from: /usr/local/psa/bootstrapper/pp18.0.79-bootstrapper/migrations
Migration failed: 17.6.0/2017-04-04-06-56-59_remove_id_from_actions.php
Query failed: UPDATE log_actions la LEFT JOIN actions a ON la.action_id = a.id SET la.action_name = a.name
Unknown column 'la.action_id' in 'on clause'

Cause

Resolution

1. Connect to your Plesk server via SSH.

2. Create a temporary directory for migration scripts:

   # mkdir /root/bootstrapper_back

3. Locate the bootstrapper directory mentioned in the error message. In this example, it is /usr/local/psa/bootstrapper/pp18.0.79-bootstrapper/migrations.

4. Move corrupted migration scripts to the temporary directory:

   # mv /usr/local/psa/bootstrapper/pp18.0.79-bootstrapper/migrations/* /root/bootstrapper_back/

5. Update Plesk:

   # plesk installer --select-release-latest --upgrade-installed-components

6. If the update is successful, remove the temporary directory:

   # rm -rf /root/bootstrapper_back