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

Created:

2016-11-16 13:03:46 UTC

Modified:

2017-08-08 13:08:29 UTC

1

Was this article helpful?


Have more questions?

Submit a request

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

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

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'

Cause

Database is not upgraded correctly.

Resolution

  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/bootstrapper.sh rerun
Have more questions? Submit a request
Please sign in to leave a comment.