Table 'apsc.aps_application_resource' doesn't exist" error when loading Plesk

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux

Created:

2016-11-16 13:21:27 UTC

Modified:

2017-02-01 12:32:14 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Table 'apsc.aps_application_resource' doesn't exist" error when loading Plesk

Symptoms

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

Cause

A table is missing in the apsc database.

Resolution

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

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