Plesk database was not upgraded: Unknown column 'icpStatus' in 'field list'

Created:

2016-11-16 12:49:42 UTC

Modified:

2017-08-16 18:33:55 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Plesk database was not upgraded: Unknown column 'icpStatus' in 'field list'

Applicable to:

  • Plesk 10.x for Linux
  • Plesk 12.5 for Linux
  • Plesk Onyx for Linux
  • Plesk 11.x for Linux
  • Plesk 11.x for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux
  • Plesk 12.5 for Windows

Symptom

  1. Plesk database is not upgraded to version 12.5.

    The following error is shown in Plesk:

    DB query failed: Unknown column 'icpStatus' in 'field list'

    OR

    Specified column "plesk_max_version" is not in the row
  2. Plesk upgrade failed. The following error is shown when trying to access Plesk:

    ERROR: Zend_Db_Table_Row_Exception: Specified column "plesk_max_version" is not in the row

Resolution

For Windows:

  1. Restore pre-upgrade psa and apsc databases dumps.

  2. Upgrade database manually running "% plesk_bin%\\dbupgrade.exe " in command prompt:

    If upgrade was performed from 12.0.18 version:

    "%plesk_bin%\\dbupgrade.exe" --upgrade "--from-version=12.0.18" "--to-version=12.5.16193"

    If upgrade was performed from 11.0.9 version:

    "%plesk_bin%\\dbupgrade.exe" --upgrade "--from-version=11.0.9" "--to-version=12.5.16193"
  3. Run the following command to apply the changes to Plesk database scheme:

    "%plesk_bin%\\php.exe" -q "%plesk_dir%\\admin\\upgrade\\db\\db.php" migrate --force

Note: If there is no pre-upgrade dumps, try to run steps 2 and 3. Make sure first that you created current database state dump.

For Linux

  1. Restore pre-upgrade psa and apsc databases dumps from /var/lib/psa/dumps directory.

  2. Change /usr/local/psa/core.version to:

    12.0.18 CentOS 6 1200180000.00

    Note : This is an example. It should contain your OS.

  3. Run

    # /usr/local/psa/bootstrapper/pp12.5.30-bootstrapper/bootstrapper.sh rerun
  4. If previous command fails with the same message:

    Unknown column '********' in 'field list'

    4.1. Install a new server with Plesk 12.5.30, or find a Plesk 12.5.30 that you can connect to its database to get a dump with:

    mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa --no-data > 12.5.30-db-struct.sql

    4.2. Identify the columns that are missing from the error message shown with bootstrapper commandline ran in point 3.
    The message should be like:

    Unknown column '********' in 'field list'

    4.3. Then, restore the DB of Plesk of point 1.

    4.4. Connect to the " plesk db" a nd in another terminal open the file from the other server " 12.5.30-db-struct.sql"
    Then search for the column name in the SQL file.

    4.5. Then keep adding the missing columns with in mysql with: ALTER TABLE `********` ADD COLUMN and copy the column structure from the file 12.5.30-db-struct.sql
    The column will look like:

    `********` int(1) NOT NULL DEFAULT '0'


    All this line has to be added after ADD COLUMN in ALTER statement from MySQL.
    More info at MySQL manual: http://dev.mysql.com/doc/refman/5.7/en/alter-table.html
    4.6. Once you've finished with tables from PSA database, return to point 2 of this guide for Linux.

  5. Finish the upgrade
    # /usr/local/psa/admin/bin/autoinstaller

[KB213904125]How can I backup/restore a Plesk database dump?

Have more questions? Submit a request
Please sign in to leave a comment.