Table doesn’t exist

  • 1337mirth

    (@1337mirth)


    5 years, 12 months ago

    I’m running CentOS7, apache 2.4, php7.0 using php-fpm and mariadb 5.5.56. The database is completely empty (except for the standard system tables) and the DocRoot has a pristine copy of latest.tar.gz extracted to it and downloaded from https://wordpress.org. I create the database ‘blogs’ exactly as described on https://codex.wordpress.org/Installing_WordPress using the MySQL CLI commands. I then run the install script from http://blogs-test.example.com/wp-admin/install.php. I then put in the database parameters and get the message that the connection was successful and that I can proceed. The next screen is a form to fill in the blog site title, email, misc. stuff as well as the temp password. I then get the message that the install was successful and it immediately redirects me to http://blogs-test.example.com/wp-login.php and I get a message “Error establishing a database connection”. The log files from the php-fpm/www-error.log state the following:

    [27-Apr-2018 18:31:36 UTC] WordPress database error Table ‘blogs.wp_blogs’ doesn’t exist for query SELECT blog_id FROM wp_blogs WHERE domain IN ( ‘blogs-test.example.com’ ) AND path IN ( ‘/wp-login.php/’, ‘/’ ) ORDER BY CHAR_LENGTH(path) DESC LIMIT 1 made by require(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), require(‘wp-includes/ms-settings.php’), ms_load_current_site_and_network, get_site_by_path, get_sites, WP_Site_Query->query, WP_Site_Query->get_sites, WP_Site_Query->get_site_ids
    [27-Apr-2018 18:31:36 UTC] WordPress database error Table ‘blogs.wp_site’ doesn’t exist for query SELECT wp_site.id FROM wp_site WHERE wp_site.domain IN ( ‘blogs-test.example.com’, ‘example.com’, ‘com’ ) AND wp_site.path IN ( ‘/wp-login.php/’, ‘/’ ) ORDER BY CHAR_LENGTH(wp_site.domain) DESC, CHAR_LENGTH(wp_site.path) DESC made by require(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), require(‘wp-includes/ms-settings.php’), ms_load_current_site_and_network, WP_Network::get_by_path, get_networks, WP_Network_Query->query, WP_Network_Query->get_networks, WP_Network_Query->get_network_ids

    I get another message about wp_site not existing as well. (I replaced the actual domain with example.com in the above).

    I’ve tried this several times all with the exact same errors. Any help will be greatly appreciated.

    Thanks,
    Mike

Viewing 1 replies (of 1 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    5 years, 12 months ago

    1. As the root database user, create a database

    create database wpdb;

    2. Create a user and assign to the database

    grant all on wpdb.* to 'wpdb_user'@'localhost' identified by 'arandompassword';

    Exit from the MySQL command line.

    Edit wp-config.php for the WP site and put those values in for the DB_* defines.

Viewing 1 replies (of 1 total)
  • The topic ‘Table doesn’t exist’ is closed to new replies.

Tags