Article ID: 121780, created on May 27, 2014, 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


After Plesk upgrade the following error appears when attempting to load the user interface:

Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhostIpDefault.php, error = [MySQL][ODBC 3.51 Driver][mysqld-5.5.30]Table 'apsc.aps_application_resource' doesn't exist


A table is missing in the apsc database.


  1. The recommended solution is to recreate the apsc database according to the article #116442.

  2. If you cannot complete the solution above (for example, if a database dump is missing), create the table manually:

    mysql> show create table apsc.aps_application_resource;
    ERROR 1146 (42S02): Table 'apsc.aps_application_resource' doesn't exist
    mysql> CREATE TABLE `aps_application_resource` (`app_id` int(10) unsigned NOT NULL,`resource_id` int(10) unsigned NOT NULL, KEY `FK_aps_application_resource_aps_application` (`app_id`), KEY `FK_aps_application_resource_aps_resource` (`resource_id`), CONSTRAINT `FK_aps_application_resource_aps_application` FOREIGN KEY (`app_id`) REFERENCES `aps_application` (`id`), CONSTRAINT `FK_aps_application_resource_aps_resource` FOREIGN KEY (`resource_id`)  REFERENCES `aps_resource` (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    Query OK, 0 rows affected (0.02 sec)

Search Words


Plesk errors when upgrading to 12

ERROR while trying to upgrade APSC SQL

ERROR 1146 (42S02) at line 89: Table 'apsc.aps_application_resource' doesn't exist

ERROR while trying to upgrade APSC SQL database from 11.1.0

Internal error: ODBC error #42S02: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73]Table 'apsc.aps_resource' doesn't exist



ERROR: An error occurred during performing of installation PREP actions

Template processing failed

Update Error

image slider

Connection to the database server has failed because of a name clash

Odbc errors

Missing table in the apsc database

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 01bc4c8cf5b7f01f815a7ada004154a2 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f aea4cd7bfd353ad7a1341a257ad4724a 2a5151f57629129e26ff206d171fbb5f e335d9adf7edffca6a8af8039031a4c7 742559b1631652fadd74764ae8be475e

Email subscription for changes to this article
Save as PDF