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

Symptoms

• Error 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 fails:

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

Cause

WordPress Toolkit bug with ID #EXTWPTOOLK-1268: WordPress toolkit database update is not retrievable.

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.