Issue while install WordPress APS instance

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

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

Errors:

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

DB_main_TYPE=mysql' 'DB_main_PASSWORD=password' 'DB_main_NAME=mydb 'DB_main_LOGIN=mylogin' 'DB_main_HOST=189.154.1.25' 'BASE_URL_SCHEME=http' 'BASE_URL_PATH=/' 'BASE_URL_HOST=domain.tld' 'BASE_IP_ADDRESS=164.134.79.63' /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 ''.

You can fix the issue by using the following steps.

Find out the database 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.

Leave a Reply

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