Unable to update Plesk: Migration failed: 17.0.10/xxxxxxx_insert_row_admin_preferences_update_to_actions.php

Symptoms

• Plesk update has failed with the error below:

  ***** problem report *****
  ===> Plesk database scheme was not upgraded completely. See installation log for details.
  ERROR: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
  Warning! Not all packages were installed.
  Please check if your system services are operable.
  Please resolve this issue and try to install the packages again.
  If you cannot resolve the issue on your own, contact product technical support for assistance.

• In /var/log/plesk/install/autoinstaller3.log a record similar to the following may be found:

  Applying migrations from: /opt/psa/bootstrapper/pp18.0.35-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

Previous migration leftover scripts, which are triggered with bootstrapper within the Plesk update.

Resolution

1. Connect to the server via SSH

2. Create a folder to back up the scripts:

   # mkdir /root/360012138933

3. Back up the bootstrapper upgrade scripts:

   # cp -a /usr/local/psa/bootstrapper/pp*-bootstrapper /root/360012138933/.

4. Remove the script folder shown in the error message:

   Note: Modify the part of the directory pp18.0.35 of this command accordingly to the path shown in the error message and modify 17.6.0 with the script folder name

   # rm -rf /usr/local/psa/bootstrapper/pp18.0.35-bootstrapper/migrations/17.6.0

5. Restart update:

   # plesk installer update

6. Run Plesk repair:

   # plesk repair installation