Unable to install Wordpress: Unknown column 'app_id' in 'field list'

Created:

2016-11-16 12:42:50 UTC

Modified:

2017-04-24 12:14:23 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to install Wordpress: Unknown column 'app_id' in 'field list'

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

  • Installation of Wordpress fails with the following error:

    Error: The following error has occurred during the installation of application: Installation of WordPress at http://example.com/ failed. ODBC error #42S22: [MySQL][ODBC 5.1 Driver][mysqld-5.5.51-cll-lve]Unknown column 'app_id' in 'field list'
  • There is no column app_id in apsc.aps_resource table.

Cause

Database inconsistency.

Resolution

  1. Create backups of psa and apsc databases:

    # plesk db dump psa > psa.sql
    # plesk db dump apsc > apsc.sql
  2. Log into Plesk database:

    # plesk db
    mysql> use apsc
  3. Recreate the missing column and its properties:

    mysql>alter table aps_resource add `app_id` int(10) unsigned DEFAULT NULL;

    mysql>alter table aps_resource add KEY `FK_aps_resource_aps_application` (`app_id`);

    mysql>alter table aps_resource ADD CONSTRAINT `FK_aps_resource_aps_application` FOREIGN KEY (`app_id`) REFERENCES `aps_application` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
Have more questions? Submit a request
Please sign in to leave a comment.