• Article for your preferred language does not exist. Below is international version of the article.

Article ID: 114225, created on Jun 27, 2012, last review on Aug 4, 2014

  • Applies to:
  • Operations Automation 5.5
  • Operations Automation 5.4

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
    

Search Words

Failed task in POA

Fatal exception of type MWException.

Failed Tasks: 'Configure site application'

Failed Task

tas

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 5b048d9bddf8048a00aba7e0bdadef37 2554725ed606193dd9bbce21365bed4e ac82ce33439a9c1feec4ff4f2f638899 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF