Unable to install or update WordPress APS instance: Unknown column 'blog_id'

Created:

2016-11-16 13:07:48 UTC

Modified:

2017-08-16 17:12:08 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to install or update WordPress APS instance: Unknown column 'blog_id'

Applicable to:

  • Plesk 11.x for Windows

Symptoms

A WordPress installation or update task is failing with the following output:

Task name   APS application 'WordPress', id 106, instance 6185 : executing configuration script
Last execution output Script execution failed: executing 'env 'WEB__wp-content_DIR=/usr/local/pem/vhosts/109521/webspace/siteapps/6185/htdocs wp-content''WEB__wp-config.php_DIR=/usr/local/pem/vhosts/109521/webspace/siteapps/6185/htdocs/wp-config.php' 'WEB__tmp_DIR=/usr /local/pem/vhosts/109521/webspace/siteapps/6185/htdocs/tmp' 'WEB__blogs_media_DIR=/usr/local/pem/vhosts/109521/webspace/siteapps /6185/htdocs/blogs/media' 'WEB___DIR=/usr/local/pem/vhosts/109521/webspace/siteapps/6185/htdocs' 'SETTINGS_title=WohnSinn' 'SETTINGS_locale=de-DE' 'SETTINGS_admin_password=password' 'SETTINGS_admin_name=admin' 'SETTINGS_admin_email=someone@domain.tld' 'SERVICE_ID=wordpress' 'PHP_VERSION=5.2.17' 'DB_main_VERSION=5.0.83' 'DB_main_TYPE=mysql' 'DB_main_PASSWORD=password' 'DB_main_NAME=mywpdb' 'DB_main_LOGIN=mylogin' 'DB_main_HOST=192.168.1.23' 'BASE_URL_SCHEME=http' 'BASE_URL_PATH=/' 'BASE_URL_HOST=domain.tld' 'BASE_IP_ADDRESS=64.131.89.6' /usr/bin/php! -cgi -d open_basedir= -q configure 'configure'' for APS application instance with id 6185 returned value '1' with output

'Unable to execute SQL statement (UPDATE `wp_options` SET `option_value`='http://domain.tld' WHERE `blog_id`=0 AND `option_name`='siteurl'): Unknown column 'blog_id' in 'where clause'' and errors ''.

Cause

The column blog_id is missing in the wp_options table of the Wordpress database.

Resolution

  1. Find out the database credentials from the task parameter Last execution output.
  2. Log in to the MySQL server with shared database hosting and update the database in question:
    mysql> USE mywpdb
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A

    Database changed

    mysql> ALTER TABLE wp_options ADD COLUMN blog_id int(11) NOT NULL default '0';
    Query OK, 159 rows affected (0.02 sec)
    Records: 159 Duplicates: 0 Warnings: 0
Have more questions? Submit a request
Please sign in to leave a comment.