Article ID: 116442, created on Jul 15, 2013, last review on Jun 17, 2016

  • Applies to:
  • Plesk 12.5 for Linux
  • Plesk 12.0 for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.5 for Windows
  • Plesk 12.0 for Windows
  • Plesk 11.0 for Windows
  • Plesk 11.5 for Windows


It is not possible to install an application after an upgrade to Parallels Plesk 11.5:

Unknown column 'T163798480.app_id' in 'on clause'


Tables in the apsc database were not upgraded properly.


Run the following command:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin -Dapsc -e "desc aps_resource"

If you do not see the app_id field, the table was not upgraded correctly.


  1. Make sure you have a pre-upgrade dump of the apsc database in the folder /var/lib/psa/dumps/. Create a backup of the apsc database:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow`  mysqldump -uadmin apsc > apsc.dump
  2. Extract the archive:

    # gzip -dc /var/lib/psa/dumps/mysql.preupgrade.apsc.[...some info here...].dump.gz > apsc.sql
  3. Make sure that all the tables in the file have the storage engine innodb. If they do not, change the storage engine to innodb in this file:

    # sed -e 's/MyISAM/InnoDB/g' apsc.sql > apsc_fixed.sql
  4. Recreate a new apsc database without tables:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow`  mysql -uadmin
    mysql> drop database apsc;
    mysql> create database apsc;
  5. Restore the tables from the pre-upgrade dump:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow`  mysql -uadmin -Dapsc < apsc_fixed.sql
  6. Run repair:

    For Plesk version 11.5.30:

    # /usr/local/psa/bootstrapper/pp11.5.30-bootstrapper/ repair

    For Plesk version 12.0.18:

    # /usr/local/psa/bootstrapper/pp12.0.18-bootstrapper/ repair

Search Words

ODBC code #42S22

Previous product version is 12.0.18, but previous database version is 011005030

Unknown column 'AR.app_id'

Unknown column T .app_id in on clause

Unknown column app_id


Cannot install wordpress due to Mysql error

01bc4c8cf5b7f01f815a7ada004154a2 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f 85a92ca67f2200d36506862eaa6ed6b8 46a8e394d6fa13134808921036a34da8 bd7fc88cf1b01f097749ae6f87272128 aea4cd7bfd353ad7a1341a257ad4724a 2a5151f57629129e26ff206d171fbb5f e335d9adf7edffca6a8af8039031a4c7 ed7be2b984f9c27de1d2dc349dc19c6d a766cea0c28e23e978fa78ef81918ab8 514af229ae32522202a910a2649c80fb 742559b1631652fadd74764ae8be475e 8b661cab116c79dbe6c4ac5bbdf1c8cb

Email subscription for changes to this article
Save as PDF