Article ID: 120924, created on Apr 5, 2014, last review on Jun 19, 2016

  • Applies to:
  • Plesk for Linux/Unix


Plesk Panel upgrade fails with the error message like this:

Unknown column ipAddress in where clause


  • The issue can be caused by the custom directive 'sql-mode' in the '/etc/my.cnf' configuration file.
  • Absence of psa.ServiceNodes.ipAddress field


  1. Remove the custom entry from MySQL configuration.

  2. Restore the 'psa' and 'apsc' databases from pre-upgrade dumps:

        # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa < mysql.<previous_plesk_version>-<upgrade_plesk_version>.<date_timestamp.dump
    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin apsc < mysql.preupgrade.apsc.<previous_plesk_version>-<upgrade_plesk_version>.<date_timestamp>.dump

    As an example:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa < mysql.preupgrade.11.0.9-
    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin apsc < mysql.preupgrade.apsc.11.0.9-

    Pre-upgrade dumps could be found in '/var/lib/psa/dumps'

  3. Run the 'bootstrapper' script to restart upgrade process by the following commands:

    Plesk 11.5

    # /usr/local/psa/bootstrapper/pp<plesk_version>-bootstrapper/ prep-install
    # /usr/local/psa/bootstrapper/pp11.5.30-bootstrapper/ rerun

    Plesk 12:

    # /usr/local/psa/bootstrapper/pp12.0.18-bootstrapper/ prep-install
    # /usr/local/psa/bootstrapper/pp12.0.18-bootstrapper/ rerun

Search Words

Can't login to the panel


ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES) (Abstract.php:144)

ERROR: Zend_Db_Statement_Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ipAddress' in 'where clause'

Cannot run queries on psa database

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 29d1e90fd304f01e6420fbe60f66f838

Email subscription for changes to this article
Save as PDF