Issue while install WordPress APS instance

Pay for an account and support us

In this tutorial I will show you how to fix issue while APS instance.

If you get the following while installing or updating WordPress APS instance:


"Unknown column 'blog_id' in 'where clause'' and errors"

DB_main_TYPE=' 'DB_main_=password' 'DB_main_NAME=mydb 'DB_main_LOGIN=mylogin' 'DB_main_HOST=' 'BASE_URL_SCHEME=http' 'BASE_URL_PATH=/' 'BASE_URL_HOST=.tld' 'BASE_IP_ADDRESS=' /usr/bin/! -cgi -d open_basedir= -q configure 'configure'' for APS application instance with id 6185 returned value '1' with output 'Unable to execute  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 ''.

You can fix the issue by using the following steps.

Find out the credentials from the task. Then login to the database which mentioned in the error

mysql> USE mydb
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

That will fix all issues.

Pay for an account and support usPay for an account and support us

Leave a Reply

Your email address will not be published. Required fields are marked *