Articles in this section

Plesk update failed on step Plesk database scheme upgrade

Plesk for Linux kb: technical update

Symptoms

  • The log at /var/log/plesk/install/autoinstaller3.log shows the following error:

    CONFIG_TEXT: ===> Plesk database scheme upgrade has been started.
    Applying migrations from: /usr/local/psa/bootstrapper/pp18.0.51-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'
    ===> Plesk database scheme was not upgraded completely.

Cause

The issue occurs due to missing or corrupted migration scripts during the update process.

Resolution

Remove the existing migration scripts and restart the update process to regenerate them through the following commands:

# mkdir /root/bootstrapper_back
# cp -a /usr/local/psa/bootstrapper/pp18.0.51-bootstrapper/migrations /root/bootstrapper_back/
# rm -rf /usr/local/psa/bootstrapper/pp18.0.51-bootstrapper/migrations/*
# plesk installer update

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.