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.
/var/log/plesk/install/autoinstaller3.loga 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'
Previous migration leftover scripts, which are triggered with bootstrapper within the Plesk update.
Connect to the server via SSH
Create a folder to back up the scripts:
# mkdir /root/360012138933
Back up the bootstrapper upgrade scripts:
# cp -a /usr/local/psa/bootstrapper/pp*-bootstrapper /root/360012138933/.
Remove the script folder shown in the error message:
Note: Modify the part of the directory
pp18.0.35of this command accordingly to the path shown in the error message and modify
17.6.0with the script folder name
# rm -rf /usr/local/psa/bootstrapper/pp18.0.35-bootstrapper/migrations/17.6.0
# plesk installer update
Run Plesk repair:
# plesk repair installation