On October 19, 2021, we have enabled single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
If you had already registered your account at Plesk 360 (formerly known as My Plesk) please use one for login. Otherwise please re-register it using the same email address as your existing Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account.

Articles in this section

See more

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

Avatar
Julia Minenkova
Updated
Follow
Plesk Onyx for Linux kb: technical ABT: Group A

Applicable to:

  • Plesk Onyx for Linux

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

  • When running the command "plesk login" in a command-line interface, it may return 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`

  • 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

  4. Access Plesk.

If the issue persists, restore the Plesk 'psa' database from a pre-upgrade dump. In this example, we are restoring the 'psa' database from a pre-upgrade dump created before an upgrade from Plesk 12.5:

  1. Connect to the Plesk server via SSH.

  2. Switch to the directory with daily dumps:

    # cd /var/lib/psa/dumps

  3. List all available pre-upgrade dumps:

    # ls -l mysql.preupgrade*
    -rw------- 1 root root 212341 Feb 1 05:18 mysql.preupgrade.12.5.30-12.5.30.20190214-051821.dump.gz
    -rw------- 1 root root 213230 Feb 1 13:50 mysql.preupgrade.12.5.30-17.8.11.20190214-135000.dump.gz

  4. Restore the 'psa' database from a pre-upgrade dump:

    # zcat mysql.preupgrade.12.5.30-12.5.30.20190214-051821.dump.gz | sed -n '/-- Current Database: `psa`/,/-- Current Database:*/p' | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin

  5. Upgrade MySQL databases:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin -T --debug-check mysql

  6. Access Plesk.

Comments

2 comments

Sort by Date Votes
  • Avatar
    Hedi Ouled-Hani

    Both didn´t work for me. There are NO pre-upgrade dumps in the folder dumps.

     

    [root@h2890615 /]# cd /var/lib/psa/dumps
    [root@h2890615 dumps]# ls -l mysql.preupgrade*
    ls: cannot access mysql.preupgrade*: No such file or directory

    0
    Comment actions Permalink
  • Avatar
    Kuzma Ivanov

    Hi Hedi Ouled-Hani,

    If there are no mysql.preupgrade dumps, that may mean that:

    • there was no upgrade performed
    • or these dump files have been removed manually

     

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles