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.

Was this post helpful?
Let us know, if you liked the post. Only in this way, we can improve us.
Yes0
No0

Leave a Reply

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