Article ID: 128411, created on Feb 21, 2016, last review on Feb 21, 2016

  • Applies to:
  • Plesk 12.5 for Linux


Plesk upgrade fails. Plesk shows the following error on attempt to open a subscription:

error: MySQL query failed: Unknown column 'external_id' in 'field list'


Database is not upgraded correctly.


  1. Back up current state of 'psa', 'apsc', and 'mysql' databases:

    # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` --databases psa apsc mysql >  /root/psa_apsc_mysql.dump2.sql
  2. Modify /usr/local/psa/version and /usr/local/psa/core.version files to contain previous Plesk version, like below:

    # cat /usr/local/psa/version /usr/local/psa/core.version  <<<---- This is the current details
    12.5.30 CentOS 6 1205151127.16
    12.5.30 CentOS 6 1205151127.16
    # cat /usr/local/psa/version /usr/local/psa/core.version  <<<---- Need to make changes as below
    12.0.18 CentOS 6 1200151014.14
    12.0.18 CentOS 6 1200151014.14
  3. Restore 'psa' and 'apsc' from preupgarde dumps at /var/lib/psa/dumps/ directory:

    # cp /var/lib/psa/dumps/mysql.preupgrade.apsc.12.0.18-12.5.30.dump.gz ./
    # gunzip mysql.preupgrade.apsc.12.0.18-12.5.30.dump.gz
    # cp /var/lib/psa/dumps/mysql.preupgrade.12.0.18-12.5.30.dump.gz ./
    # gunzip mysql.preupgrade.12.0.18-12.5.30.dump.gz
    # mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa < mysql.preupgrade.12.0.18-12.5.30.dump
    # mysql -uadmin -p`cat /etc/psa/.psa.shadow` apsc < mysql.preupgrade.apsc.12.0.18-12.5.30.dump
  4. Run 'bootstarpper' utility with 'rerun' option:

    # /usr/local/psa/bootstrapper/pp12.5.30-bootstrapper/ rerun

Search Words

plesk upgrade

MySQL query failed: Unknown column 'external_id' in 'field list'

742559b1631652fadd74764ae8be475e 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 e335d9adf7edffca6a8af8039031a4c7

Email subscription for changes to this article
Save as PDF