Plesk updates installation fails: Failed to install or upgrade the extension 'WordPress Toolkit'

Symptoms

• The following message is shown on Plesk homepage:

PLESK_ERROR: Failed to update Plesk. To solve this problem, you can send the update log to Plesk support. View the update logs (Feb 18, 2018). Copy the logs to your computer before you close this message. To close this message, click here.

• The downloaded Plesk update log includes the following error:

CONFIG_TEXT: ERROR: Failed to install or upgrade the extension 'WordPress Toolkit' (package: wp-toolkit):
ERR [extension/wp-toolkit] Execution of /opt/psa/admin/plib/modules/wp-toolkit/scripts/post-install.php failed with exit code 1 and the output:
ERR [extension/wp-toolkit] SQLSTATE[HY000]: General error: 1 no such column: ownerId

• Execution of /opt/psa/admin/plib/modules/wp-toolkit/scripts/post-install.php failed:

CONFIG_TEXT: ERR [extension/wp-toolkit] SQLSTATE[HY000]: General error: 1 no such column: ownerId

Cause

This behavior is recognized as WordPress Toolkit bug with ID #EXTWPTOOLK-1268: WordPress toolkit database update is not retriable.

It will be fixed in one of the future WordPress Toolkit update.

Resolution

Note: if you don't have administrative access to Plesk server via SSH or RDP, contact your hosting provider regarding the issue

1. Connect to the server via SSH or RDP;

2. Update 'version' table of WordPress Toolkit database.

   # sqlite3 /usr/local/psa/var/modules/wp-toolkit/wp-toolkit.sqlite3
   sqlite> update version set dbVersion = '2017121502000';

3. Try to update WordPress Toolkit extension.

Additional information

WordPress instance marked as broken: /usr/local/psa/admin/plib/modules/wp-toolkit/vendor/wp-cli/wp-cli/bin/wp: Permission denied System error 13: Permission denied