Plesk Onyx is not accessible after an upgrade on a Linux server: Unknown column 'id' in 'field list', query was: SELECT id, name, descr, enabled FROM actions

Symptoms

• Plesk Onyx is not accessible with the following error message in a browser:

  PLESK_INFO: Internal error:
  DB query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'field list', query was: SELECT id, name, descr, enabled FROM actions
  Message DB query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'field list', query was: SELECT id, name, descr, enabled FROM actions
  File Mysql.php
  Line 53
  Type Plesk\Exception\Database

  OR

  PLESK_INFO: Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'action_name' in 'field list', query was: insert into log_actions(`date`, `ip_address`, `user`, `action_nam e`, `object_id`)

• When running the command "plesk login" in a command-line interface, it returns the following error message:

  # plesk login
  [2018-05-21 20:34:16] ERR [panel] DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.ServiceInstallations' doesn't exist, query was: DESCRIBE `ServiceInstallations`
  DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.ServiceInstallations' doesn't exist, query was: DESCRIBE `ServiceInstallations`

  OR

  CONFIG_TEXT: Internal error:
  DB query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'field list', query was: SELECT id, name, descr, enabled FROM actions
  Message DB query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'field list', query was: SELECT id, name, descr, enabled FROM actions
  File Mysql.php
  Line 53
  Type Plesk\Exception\Database

• The table psa.ServiceInstallations does not exist:

  # plesk db "select * from ServiceInstallations"
  ERROR 1146 (42S02) at line 1: Table 'psa.ServiceInstallations' doesn't exist
  exit status 1

Cause

The Plesk database was not converted successfully after an upgrade from previous release.

Resolution

Complete Plesk upgrade:

1. Connect to the Plesk server via SSH.

2. Start Plesk Installer as follows to complete upgrade:

   # plesk installer update --repatch

3. Run the Plesk repair tool to fix Plesk database:

   # plesk repair db

    

If the above steps do not help, restore Plesk database from a database dump:

1. Find the latest backup that contains the psa.PlanServiceInstallations table. In this example, it is /var/lib/psa/dumps/mysql.daily.dump.0.gz:

   # zgrep "CREATE TABLE \`PlanServiceInstallations\`" /var/lib/psa/dumps/*
   /var/lib/psa/dumps/mysql.daily.dump.0.gz:CREATE TABLE `PlanServiceInstallations` (
   /var/lib/psa/dumps/mysql.daily.dump.1.gz:CREATE TABLE `PlanServiceInstallations` (

2. Run these commands to restore this backup, replacing /var/lib/psa/dumps/mysql.daily.dump.0.gz with a suitable backup name from the previous step:

   # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin -e"DROP DATABASE psa;"
   # zcat /var/lib/psa/dumps/mysql.daily.dump.0.gz | sed -n '/-- Current Database: `psa`/,/-- Current Database:*/p' | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -f -uadmin

3. Run the Plesk repair tool to fix Plesk database:

   # plesk repair db