Adding NEW sub domains to existing MULTISITE installation

Hi there,

two weeks we installed on a dedicated managed server the wordpress MULTISITE dealsmarthosting.com (main website/domain) application as a larger WordPress Network installs using as well a multi-DB structure. Setting up the first two sub domains (coffeelovers.dealsm... + stationary.dealsm….) could be done without any problem and are working since properly.

Now, adding additional sub domains (e.g. testing.dealsm…, welcome.dealsm…) the new sub domains are setup successfully, see attached email confirmation as well as screen shots (accordingly named with 01dsmh, 02dsmh...).

Clicking the link to login an ERROR 500 occurs… (provider stated it’s not a server issue; dealsmarthosting,com is accessable).

Checking the NEW Site setting reveals the following situation:

- New sit is NOT added to the database also
- ‘Multisite support is not enabled’ anymore
BUT hovering over the listing reveals that new site is an EXTERNAL Domain!

Comparing site entries of e.g. http://coffeelovers.dealsm... With the newly entered site turns out the ‘http’ prefix is missing.
Editing SITE SETTINGS of ://bandon2.dealsm… to http://brandon2.dealsm.... does not accept ‘SAVE CHANGES’.

Now: How do I solve this issue? Provider does NOT not support wordpress + multisite + database issues.

Any help to solve this hassle is much appreciated and will be awarded with 50 wpmu dev points.

Regards
Brandon

  • Rupok

    Hi Steven Zimmerman

    Hope you had a wonderful day.

    Thanks for sending screenshots. It helps to understand the process really better. I believe, I can help you solve this.

    As you said "Network installs using as well a multi-DB structure", can you please describe how different it is from default WordPress database structure? Can you please login to your cPanel and go to phpmyadmin, then select your database, then search for "://bandon2.dealsm" and replace with "http://bandon2.dealsm". Do this for all your subdomains which has same status. This will resolve the URL issue.

    Clicking the link to login an ERROR 500 occurs

    Well, this can occur for many reasons. I could find a clue from your log files. Can you turn on debug mode in WordPress? To enable it, open your wp-config.php file and look for define(‘WP_DEBUG’, false);. Change it to:

    define('WP_DEBUG', true);

    In order to enable the error logging to a file on the server you need to add yet one more similar line:

    define( 'WP_DEBUG_LOG', true );

    In this case the errors will be saved to a debug.log log file inside the /wp-content/directory.

    Depending on whether you want your errors to be only logged or also displayed on the screen you should also have this line there, immediately after the line mentioned above:

    define( 'WP_DEBUG_DISPLAY', false );

    The wp-config.php is located in your WordPress root directory. It’s the same file where the database configuration settings are. You will have to access it by FTP or SFTP in order to edit it.

    Past errors here. If file is very long, please paste them to a text file and attach with your reply. Can you please also provide your server log so I can have a look at that too?

    I'm looking forward to hear from you and resolve this issue as soon as possible.

    Have a nice day. Cheers!

  • Steven Zimmerman

    How to add log because it is to big - .zip is not accepted? Below excerpt ...
    debug.log

    ASCII text, with very long lines
    [24-Apr-2016 08:01:46 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'dsmhprf01_4_user_roles' LIMIT 1 made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, switch_to_blog, WP_Roles->reinit, get_option, m_wpdb->query
    [24-Apr-2016 08:01:46 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'blogname' LIMIT 1 made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, get_option, m_wpdb->query
    [24-Apr-2016 08:01:46 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'siteurl' LIMIT 1 made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, get_option, m_wpdb->query
    [24-Apr-2016 08:01:46 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'post_count' LIMIT 1 made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, get_option, m_wpdb->query
    [24-Apr-2016 08:01:46 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'home' LIMIT 1 made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, get_option, m_wpdb->query
    [24-Apr-2016 08:01:46 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'stylesheet' LIMIT 1 made by require_once('wp-admin/admin-header.php'), do_action('admin_head'), call_user_func_array, Multisite_Add_Admin_Favicon->set_admin_bar_blog_icon, get_blog_option, get_option, m_wpdb->query
    [24-Apr-2016 08:01:46 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'site_icon' LIMIT 1 made by require_once('wp-admin/admin-header.php'), do_action('admin_head'), call_user_func_array, Multisite_Add_Admin_Favicon->set_admin_bar_blog_icon, get_blog_option, get_option, m_wpdb->query
    [24-Apr-2016 08:01:46 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'blog_public' LIMIT 1 made by require_once('wp-admin/admin-header.php'), do_action('in_admin_header'), call_user_func_array, wp_admin_bar_render, do_action_ref_array, call_user_func_array, Multisite_Add_Site_Status_labels->add_status_label, Multisite_Add_Site_Status_labels->is_site_live, get_blog_option, get_option, m_wpdb->query
    [24-Apr-2016 08:01:46 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_comments' doesn't exist for query
    SELECT comment_approved, COUNT( * ) AS total
    FROM dsmhprf01_4_comments

    GROUP BY comment_approved
    made by require_once('wp-admin/admin-header.php'), do_action('in_admin_header'), call_user_func_array, wp_admin_bar_render, do_action('wp_before_admin_bar_render'), call_user_func_array, Multisite_Admin_Bar_Tweaks->enhance_network_blog_admin_bar, wp_count_comments, get_comment_count, m_wpdb->query
    [24-Apr-2016 08:01:59 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'dsmhprf01_4_user_roles' LIMIT 1 made by require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, switch_to_blog, WP_Roles->reinit, get_option, m_wpdb->query
    [24-Apr-2016 08:01:59 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'blogname' LIMIT 1 made by require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, get_option, m_wpdb->query
    [24-Apr-2016 08:01:59 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'siteurl' LIMIT 1 made by require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, get_option, m_wpdb->query
    [24-Apr-2016 08:01:59 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'post_count' LIMIT 1 made by require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, get_option, m_wpdb->query
    [24-Apr-2016 08:01:59 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'home' LIMIT 1 made by require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, get_option, m_wpdb->query
    [24-Apr-2016 08:01:59 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'stylesheet' LIMIT 1 made by include('wp-admin/admin-header.php'), do_action('admin_head'), call_user_func_array, Multisite_Add_Admin_Favicon->set_admin_bar_blog_icon, get_blog_option, get_option, m_wpdb->query
    [24-Apr-2016 08:01:59 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'site_icon' LIMIT 1 made by include('wp-admin/admin-header.php'), do_action('admin_head'), call_user_func_array, Multisite_Add_Admin_Favicon->set_admin_bar_blog_icon, get_blog_option, get_option, m_wpdb->query
    [24-Apr-2016 08:01:59 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'blog_public' LIMIT 1 made by include('wp-admin/admin-header.php'), do_action('in_admin_header'), call_user_func_array, wp_admin_bar_render, do_action_ref_array, call_user_func_array, Multisite_Add_Site_Status_labels->add_status_label, Multisite_Add_Site_Status_labels->is_site_live, get_blog_option, get_option, m_wpdb->query
    [24-Apr-2016 08:01:59 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_comments' doesn't exist for query
    SELECT comment_approved, COUNT( * ) AS total
    FROM dsmhprf01_4_comments

    GROUP BY comment_approved
    made by include('wp-admin/admin-header.php'), do_action('in_admin_header'), call_user_func_array, wp_admin_bar_render, do_action('wp_before_admin_bar_render'), call_user_func_array, Multisite_Admin_Bar_Tweaks->enhance_network_blog_admin_bar, wp_count_comments, get_comment_count, m_wpdb->query
    [24-Apr-2016 08:02:28 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'dsmhprf01_4_user_roles' LIMIT 1 made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, switch_to_blog, WP_Roles->reinit, get_option, m_wpdb->query
    [24-Apr-2016 08:02:28 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'blogname' LIMIT 1 made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, get_option, m_wpdb->query
    [24-Apr-2016 08:02:28 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'siteurl' LIMIT 1 made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, get_option, m_wpdb->query
    [24-Apr-2016 08:02:28 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'post_count' LIMIT 1 made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, get_option, m_wpdb->query
    [24-Apr-2016 08:02:28 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'home' LIMIT 1 made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, get_option, m_wpdb->query
    [24-Apr-2016 08:02:28 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'stylesheet' LIMIT 1 made by require('wp-admin/admin-header.php'), do_action('admin_head'), call_user_func_array, Multisite_Add_Admin_Favicon->set_admin_bar_blog_icon, get_blog_option, get_option, m_wpdb->query
    [24-Apr-2016 08:02:28 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'site_icon' LIMIT 1 made by require('wp-admin/admin-header.php'), do_action('admin_head'), call_user_func_array, Multisite_Add_Admin_Favicon->set_admin_bar_blog_icon, get_blog_option, get_option, m_wpdb->query
    [24-Apr-2016 08:02:28 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'blog_public' LIMIT 1 made by require('wp-admin/admin-header.php'), do_action('in_admin_header'), call_user_func_array, wp_admin_bar_render, do_action_ref_array, call_user_func_array, Multisite_Add_Site_Status_labels->add_status_label, Multisite_Add_Site_Status_labels->is_site_live, get_blog_option, get_option, m_wpdb->query
    [24-Apr-2016 08:02:28 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_comments' doesn't exist for query
    SELECT comment_approved, COUNT( * ) AS total
    FROM dsmhprf01_4_comments

    GROUP BY comment_approved
    made by require('wp-admin/admin-header.php'), do_action('in_admin_header'), call_user_func_array, wp_admin_bar_render, do_action('wp_before_admin_bar_render'), call_user_func_array, Multisite_Admin_Bar_Tweaks->enhance_network_blog_admin_bar, wp_count_comments, get_comment_count, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'dsmhprf01_4_user_roles' LIMIT 1 made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, switch_to_blog, WP_Roles->reinit, get_option, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'blogname' LIMIT 1 made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, get_option, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'siteurl' LIMIT 1 made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, get_option, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'post_count' LIMIT 1 made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, get_option, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error Table 'dealsm5_a.dsmhprf01_4_options' doesn't exist for query SELECT option_value FROM dsmhprf01_4_options WHERE option_name = 'home' LIMIT 1 made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('admin_init'), call_user_func_array, _wp_admin_bar_init, WP_Admin_Bar->initialize, get_blogs_of_user, get_blog_details, get_option, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' for query CREATE TABLE dsmhprf01_5_termmeta (
    meta_id bigint(20) unsigned NOT NULL auto_increment,
    term_id bigint(20) unsigned NOT NULL default '0',
    meta_key varchar(255) default NULL,
    meta_value longtext,
    PRIMARY KEY (meta_id),
    KEY term_id (term_id),
    KEY meta_key (meta_key(191))
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci made by wpmu_create_blog, install_blog, make_db_current_silent, dbDelta, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' for query
    CREATE TABLE dsmhprf01_5_terms (
    term_id bigint(20) unsigned NOT NULL auto_increment,
    name varchar(200) NOT NULL default '',
    slug varchar(200) NOT NULL default '',
    term_group bigint(10) NOT NULL default 0,
    PRIMARY KEY (term_id),
    KEY slug (slug(191)),
    KEY name (name(191))
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci made by wpmu_create_blog, install_blog, make_db_current_silent, dbDelta, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' for query
    CREATE TABLE dsmhprf01_5_term_taxonomy (
    term_taxonomy_id bigint(20) unsigned NOT NULL auto_increment,
    term_id bigint(20) unsigned NOT NULL default 0,
    taxonomy varchar(32) NOT NULL default '',
    description longtext NOT NULL,
    parent bigint(20) unsigned NOT NULL default 0,
    count bigint(20) NOT NULL default 0,
    PRIMARY KEY (term_taxonomy_id),
    UNIQUE KEY term_id_taxonomy (term_id,taxonomy),
    KEY taxonomy (taxonomy)
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci made by wpmu_create_blog, install_blog, make_db_current_silent, dbDelta, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' for query
    CREATE TABLE dsmhprf01_5_term_relationships (
    object_id bigint(20) unsigned NOT NULL default 0,
    term_taxonomy_id bigint(20) unsigned NOT NULL default 0,
    term_order int(11) NOT NULL default 0,
    PRIMARY KEY (object_id,term_taxonomy_id),
    KEY term_taxonomy_id (term_taxonomy_id)
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci made by wpmu_create_blog, install_blog, make_db_current_silent, dbDelta, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' for query
    CREATE TABLE dsmhprf01_5_commentmeta (
    meta_id bigint(20) unsigned NOT NULL auto_increment,
    comment_id bigint(20) unsigned NOT NULL default '0',
    meta_key varchar(255) default NULL,
    meta_value longtext,
    PRIMARY KEY (meta_id),
    KEY comment_id (comment_id),
    KEY meta_key (meta_key(191))
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci made by wpmu_create_blog, install_blog, make_db_current_silent, dbDelta, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' for query
    CREATE TABLE dsmhprf01_5_comments (
    comment_ID bigint(20) unsigned NOT NULL auto_increment,
    comment_post_ID bigint(20) unsigned NOT NULL default '0',
    comment_author tinytext NOT NULL,
    comment_author_email varchar(100) NOT NULL default '',
    comment_author_url varchar(200) NOT NULL default '',
    comment_author_IP varchar(100) NOT NULL default '',
    comment_date datetime NOT NULL default '0000-00-00 00:00:00',
    comment_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
    comment_content text NOT NULL,
    comment_karma int(11) NOT NULL default '0',
    comment_approved varchar(20) NOT NULL default '1',
    comment_agent varchar(255) NOT NULL default '',
    comment_type varchar(20) NOT NULL default '',
    comment_parent bigint(20) unsigned NOT NULL default '0',
    user_id bigint(20) unsigned NOT NULL default '0',
    PRIMARY KEY (comment_ID),
    KEY comment_post_ID (comment_post_ID),
    KEY comment_approved_date_gmt (comment_approved,comment_date_gmt),
    KEY comment_date_gmt (comment_date_gmt),
    KEY comment_parent (comment_parent),
    KEY comment_author_email (comment_author_email(10))
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci made by wpmu_create_blog, install_blog, make_db_current_silent, dbDelta, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' for query
    CREATE TABLE dsmhprf01_5_links (
    link_id bigint(20) unsigned NOT NULL auto_increment,
    link_url varchar(255) NOT NULL default '',
    link_name varchar(255) NOT NULL default '',
    link_image varchar(255) NOT NULL default '',
    link_target varchar(25) NOT NULL default '',
    link_description varchar(255) NOT NULL default '',
    link_visible varchar(20) NOT NULL default 'Y',
    link_owner bigint(20) unsigned NOT NULL default '1',
    link_rating int(11) NOT NULL default '0',
    link_updated datetime NOT NULL default '0000-00-00 00:00:00',
    link_rel varchar(255) NOT NULL default '',
    link_notes mediumtext NOT NULL,
    link_rss varchar(255) NOT NULL default '',
    PRIMARY KEY (link_id),
    KEY link_visible (link_visible)
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci made by wpmu_create_blog, install_blog, make_db_current_silent, dbDelta, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' for query
    CREATE TABLE dsmhprf01_5_options (
    option_id bigint(20) unsigned NOT NULL auto_increment,
    option_name varchar(191) NOT NULL default '',
    option_value longtext NOT NULL,
    autoload varchar(20) NOT NULL default 'yes',
    PRIMARY KEY (option_id),
    UNIQUE KEY option_name (option_name)
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci made by wpmu_create_blog, install_blog, make_db_current_silent, dbDelta, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' for query
    CREATE TABLE dsmhprf01_5_postmeta (
    meta_id bigint(20) unsigned NOT NULL auto_increment,
    post_id bigint(20) unsigned NOT NULL default '0',
    meta_key varchar(255) default NULL,
    meta_value longtext,
    PRIMARY KEY (meta_id),
    KEY post_id (post_id),
    KEY meta_key (meta_key(191))
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci made by wpmu_create_blog, install_blog, make_db_current_silent, dbDelta, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' for query
    CREATE TABLE dsmhprf01_5_posts (
    ID bigint(20) unsigned NOT NULL auto_increment,
    post_author bigint(20) unsigned NOT NULL default '0',
    post_date datetime NOT NULL default '0000-00-00 00:00:00',
    post_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
    post_content longtext NOT NULL,
    post_title text NOT NULL,
    post_excerpt text NOT NULL,
    post_status varchar(20) NOT NULL default 'publish',
    comment_status varchar(20) NOT NULL default 'open',
    ping_status varchar(20) NOT NULL default 'open',
    post_password varchar(20) NOT NULL default '',
    post_name varchar(200) NOT NULL default '',
    to_ping text NOT NULL,
    pinged text NOT NULL,
    post_modified datetime NOT NULL default '0000-00-00 00:00:00',
    post_modified_gmt datetime NOT NULL default '0000-00-00 00:00:00',
    post_content_filtered longtext NOT NULL,
    post_parent bigint(20) unsigned NOT NULL default '0',
    guid varchar(255) NOT NULL default '',
    menu_order int(11) NOT NULL default '0',
    post_type varchar(20) NOT NULL default 'post',
    post_mime_type varchar(100) NOT NULL default '',
    comment_count bigint(20) NOT NULL default '0',
    PRIMARY KEY (ID),
    KEY post_name (post_name(191)),
    KEY type_status_date (post_type,post_status,post_date,ID),
    KEY post_parent (post_parent),
    KEY post_author (post_author)
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci made by wpmu_create_blog, install_blog, make_db_current_silent, dbDelta, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT option_name FROM dsmhprf01_5_options WHERE option_name in ( 'siteurl', 'home', 'blogname', 'blogdescription', 'users_can_register', 'admin_email', 'start_of_week', 'use_balanceTags', 'use_smilies', 'require_name_email', 'comments_notify', 'posts_per_rss', 'rss_use_excerpt', 'mailserver_url', 'mailserver_login', 'mailserver_pass', 'mailserver_port', 'default_category', 'default_comment_status', 'default_ping_status', 'default_pingback_flag', 'posts_per_page', 'date_format', 'time_format', 'links_updated_date_format', 'comment_moderation', 'moderation_notify', 'permalink_structure', 'rewrite_rules', 'hack_file', 'blog_charset', 'moderation_keys', 'active_plugins', 'category_base', 'ping_sites', 'comment_max_links', 'gmt_offset', 'default_email_category', 'recently_edited', 'template', 'stylesheet', 'comment_whitelist', 'blacklist_keys', 'comment_registration', 'html_type', 'use_trackback', 'default_role', 'db_version', 'uploads_use_yearmonth_folders', 'upload_path', 'blog_public', 'default_link_category', 'show_on_front', 'tag_base', 'show_avatars', 'avatar_rating', 'upload_url_path', 'thumbnail_size_w', 'thumbnail_size_h', 'thumbnail_crop', 'medium_size_w', 'medium_size_h', 'avatar_default', 'large_size_w', 'large_size_h', 'image_default_link_type', 'image_default_size', 'image_default_align', 'close_comments_for_old_posts', 'close_comments_days_old', 'thread_comments', 'thread_comments_depth', 'page_comments', 'comments_per_page', 'default_comments_page', 'comment_order', 'sticky_posts', 'widget_categories', 'widget_text', 'widget_rss', 'uninstall_plugins', 'timezone_string', 'page_for_posts', 'page_on_front', 'default_post_format', 'link_manager_enabled', 'finished_splitting_shared_terms', 'site_icon', 'medium_large_size_w', 'medium_large_size_h' ) made by wpmu_create_blog, install_blog, populate_options, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query INSERT INTO dsmhprf01_5_options (option_name, option_value, autoload) VALUES ('siteurl', 'http://dealsmarthosting.com', 'yes'), ('home', 'http://dealsmarthosting.com', 'yes'), ('blogname', 'My Site', 'yes'), ('blogdescription', 'Just another Emporium Sites site', 'yes'), ('users_can_register', '0', 'yes'), ('admin_email', 'you@example.com', 'yes'), ('start_of_week', '1', 'yes'), ('use_balanceTags', '0', 'yes'), ('use_smilies', '1', 'yes'), ('require_name_email', '1', 'yes'), ('comments_notify', '1', 'yes'), ('posts_per_rss', '10', 'yes'), ('rss_use_excerpt', '0', 'yes'), ('mailserver_url', 'mail.example.com', 'yes'), ('mailserver_login', 'login@example.com', 'yes'), ('mailserver_pass', 'password', 'yes'), ('mailserver_port', '110', 'yes'), ('default_category', '1', 'yes'), ('default_comment_status', 'open', 'yes'), ('default_ping_status', 'open', 'yes'), ('default_pingback_flag', '1', 'yes'), ('posts_per_page', '10', 'yes'), ('date_format', 'F j, Y', 'yes'), ('time_format', 'g:i a', 'yes'), ('links_updated_date_format', 'F j, Y g:i a', 'yes'), ('comment_moderation', '0', 'yes'), ('moderation_notify', '1', 'yes'), ('permalink_structure', '/%year%/%monthnum%/%day%/%postname%/', 'yes'), ('rewrite_rules', '', 'yes'), ('hack_file', '0', 'yes'), ('blog_charset', 'UTF-8', 'yes'), ('moderation_keys', '', 'no'), ('active_plugins', 'a:0:{}', 'yes'), ('category_base', '', 'yes'), ('ping_sites', 'http://rpc.pingomatic.com/', 'yes'), ('comment_max_links', '2', 'yes'), ('gmt_offset', '0', 'yes'), ('default_email_category', '1', 'yes'), ('recently_edited', '', 'no'), ('template', 'twentysixteen', 'yes'), ('stylesheet', 'twentysixteen', 'yes'), ('comment_whitelist', '1', 'yes'), ('blacklist_keys', '', 'no'), ('comment_registration', '0', 'yes'), ('html_type', 'text/html', 'yes'), ('use_trackback', '0', 'yes'), ('default_role', 'subscriber', 'yes'), ('db_version', '36686', 'yes'), ('uploads_use_yearmonth_folders', '1', 'yes'), ('upload_path', '', 'yes'), ('blog_public', '1', 'yes'), ('default_link_category', '2', 'yes'), ('show_on_front', 'posts', 'yes'), ('tag_base', '', 'yes'), ('show_avatars', '1', 'yes'), ('avatar_rating', 'G', 'yes'), ('upload_url_path', '', 'yes'), ('thumbnail_size_w', '150', 'yes'), ('thumbnail_size_h', '150', 'yes'), ('thumbnail_crop', '1', 'yes'), ('medium_size_w', '300', 'yes'), ('medium_size_h', '300', 'yes'), ('avatar_default', 'mystery', 'yes'), ('large_size_w', '1024', 'yes'), ('large_size_h', '1024', 'yes'), ('image_default_link_type', 'none', 'yes'), ('image_default_size', '', 'yes'), ('image_default_align', '', 'yes'), ('close_comments_for_old_posts', '0', 'yes'), ('close_comments_days_old', '14', 'yes'), ('thread_comments', '1', 'yes'), ('thread_comments_depth', '5', 'yes'), ('page_comments', '0', 'yes'), ('comments_per_page', '50', 'yes'), ('default_comments_page', 'newest', 'yes'), ('comment_order', 'asc', 'yes'), ('sticky_posts', 'a:0:{}', 'yes'), ('widget_categories', 'a:0:{}', 'yes'), ('widget_text', 'a:0:{}', 'yes'), ('widget_rss', 'a:0:{}', 'yes'), ('uninstall_plugins', 'a:0:{}', 'no'), ('timezone_string', '', 'yes'), ('page_for_posts', '0', 'yes'), ('page_on_front', '0', 'yes'), ('default_post_format', '0', 'yes'), ('link_manager_enabled', '0', 'yes'), ('finished_splitting_shared_terms', '1', 'yes'), ('site_icon', '0', 'yes'), ('medium_large_size_w', '768', 'yes'), ('medium_large_size_h', '0', 'yes') made by wpmu_create_blog, install_blog, populate_options, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT option_value FROM dsmhprf01_5_options WHERE option_name = 'home' made by wpmu_create_blog, install_blog, populate_options, __get_option, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT option_value FROM dsmhprf01_5_options WHERE option_name = 'siteurl' made by wpmu_create_blog, install_blog, populate_options, __get_option, __get_option, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query INSERT INTO dsmhprf01_5_options (option_name, option_value, autoload) VALUES ('home', 'http://dealsmarthosting.com', 'yes') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by wpmu_create_blog, install_blog, populate_options, update_option, add_option, m_wpdb->query
    [24-Apr-2016 08:03:03 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'blodotgsping_url' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'bodyterminator' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'emailtestonly' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'phoneemail_separator' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'smilies_directory' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'subjectprefix' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'use_bbcode' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'use_blodotgsping' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'use_phoneemail' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'use_quicktags' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'use_weblogsping' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'weblogs_cache_file' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'use_preview' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'use_htmltrans' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'smilies_directory' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'fileupload_allowedusers' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'use_phoneemail' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'default_post_status' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'default_post_category' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'archive_mode' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'time_difference' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_minadminlevel' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_use_adminlevels' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_rating_type' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_rating_char' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_rating_ignore_zero' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_rating_single_image' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_rating_image0' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_rating_image1' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_rating_image2' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_rating_image3' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_rating_image4' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_rating_image5' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_rating_image6' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_rating_image7' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_rating_image8' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_rating_image9' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_recently_updated_time' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_recently_updated_prepend' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'links_recently_updated_append' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query
    [24-Apr-2016 08:03:04 UTC] WordPress database error Table 'dealsm5_e.dsmhprf01_5_options' doesn't exist for query SELECT autoload FROM dsmhprf01_5_options WHERE option_name = 'weblogs_cacheminutes' made by wpmu_create_blog, install_blog, populate_options, delete_option, m_wpdb->query

  • Rupok

    Hi Steven Zimmerman

    Hope you had a wonderful day.

    From your debug log, it seems like lots of tables are not available in your database. That's why mainly this is happening.

    As I asked before, can you please describe how different it is from default WordPress Multisite database structure? Can you please try repairing your WordPress database? You can get idea about how you can repair your WordPress database from here: https://www.maketecheasier.com/fix-corrupted-wordpress-database-2/

    As tables are missing for subsites, can you deletes those problematic blogs and create new subsites and see if the issue is still there? Please let us know the result.

    Have a nice day. Cheers!

  • Steven Zimmerman

    Hello Rupok,

    - repaired db as suggested - no success (screen shot)
    - added http:// as suggested - no success (screen shot)
    - deleted problematic subsite and created new once - still same problem
    - problem is that :// can not be deleted and I did not find any db-entries

    To answer your question - difference from wordpress database: me predecessor installed/setup successfully our db structure using wpmu dev multi-db (as already mentioned).

    Do you have any further advice?
    Brandon

  • Steven Zimmerman

    Database DOES NOT add any NEW Site...

    The dsmhprf01_users table is okay.
    The dsmhprf01_users table is already optimized.
    The dsmhprf01_usermeta table is okay.
    The dsmhprf01_usermeta table is already optimized.
    The dsmhprf01_posts table is okay.
    The dsmhprf01_posts table is already optimized.
    The dsmhprf01_comments table is okay.
    The dsmhprf01_comments table is already optimized.
    The dsmhprf01_links table is okay.
    The dsmhprf01_links table is already optimized.
    The dsmhprf01_options table is okay.
    The dsmhprf01_options table is already optimized.
    The dsmhprf01_postmeta table is okay.
    The dsmhprf01_postmeta table is already optimized.
    The dsmhprf01_terms table is okay.
    The dsmhprf01_terms table is already optimized.
    The dsmhprf01_term_taxonomy table is okay.
    The dsmhprf01_term_taxonomy table is already optimized.
    The dsmhprf01_term_relationships table is okay.
    The dsmhprf01_term_relationships table is already optimized.
    The dsmhprf01_termmeta table is okay.
    The dsmhprf01_termmeta table is already optimized.
    The dsmhprf01_commentmeta table is okay.
    The dsmhprf01_commentmeta table is already optimized.
    The dsmhprf01_blogs table is okay.
    The dsmhprf01_blogs table is already optimized.
    The dsmhprf01_signups table is okay.
    The dsmhprf01_signups table is already optimized.
    The dsmhprf01_site table is okay.
    The dsmhprf01_site table is already optimized.
    The dsmhprf01_sitemeta table is okay.
    The dsmhprf01_sitemeta table is already optimized.
    The dsmhprf01_registration_log table is okay.
    The dsmhprf01_registration_log table is already optimized.
    The dsmhprf01_blog_versions table is okay.
    The dsmhprf01_blog_versions table is already optimized.
    The dsmhprf01_2_commentmeta table is okay.
    The dsmhprf01_2_commentmeta table is already optimized.
    The dsmhprf01_2_comments table is okay.
    The dsmhprf01_2_comments table is already optimized.
    The dsmhprf01_2_cpk_wpcsv_export_queue table is okay.
    The dsmhprf01_2_cpk_wpcsv_export_queue table is already optimized.
    The dsmhprf01_2_cpk_wpcsv_log table is okay.
    The dsmhprf01_2_cpk_wpcsv_log table is already optimized.
    The dsmhprf01_2_links table is okay.
    The dsmhprf01_2_links table is already optimized.
    The dsmhprf01_2_options table is okay.
    The dsmhprf01_2_options table is already optimized.
    The dsmhprf01_2_postmeta table is okay.
    The dsmhprf01_2_postmeta table is already optimized.
    The dsmhprf01_2_posts table is okay.
    The dsmhprf01_2_posts table is already optimized.
    The dsmhprf01_2_revslider_css table is okay.
    The dsmhprf01_2_revslider_css table is already optimized.
    The dsmhprf01_2_revslider_layer_animations table is okay.
    The dsmhprf01_2_revslider_layer_animations table is already optimized.
    The dsmhprf01_2_revslider_navigations table is okay.
    The dsmhprf01_2_revslider_navigations table is already optimized.
    The dsmhprf01_2_revslider_sliders table is okay.
    The dsmhprf01_2_revslider_sliders table is already optimized.
    The dsmhprf01_2_revslider_slides table is okay.
    The dsmhprf01_2_revslider_slides table is already optimized.
    The dsmhprf01_2_revslider_static_slides table is okay.
    The dsmhprf01_2_revslider_static_slides table is already optimized.
    The dsmhprf01_2_term_relationships table is okay.
    The dsmhprf01_2_term_relationships table is already optimized.
    The dsmhprf01_2_term_taxonomy table is okay.
    The dsmhprf01_2_term_taxonomy table is already optimized.
    The dsmhprf01_2_termmeta table is okay.
    The dsmhprf01_2_termmeta table is already optimized.
    The dsmhprf01_2_terms table is okay.
    The dsmhprf01_2_terms table is already optimized.
    The dsmhprf01_3_commentmeta table is okay.
    The dsmhprf01_3_commentmeta table is already optimized.
    The dsmhprf01_3_comments table is okay.
    The dsmhprf01_3_comments table is already optimized.
    The dsmhprf01_3_cpk_wpcsv_export_queue table is okay.
    The dsmhprf01_3_cpk_wpcsv_export_queue table is already optimized.
    The dsmhprf01_3_cpk_wpcsv_log table is okay.
    The dsmhprf01_3_cpk_wpcsv_log table is already optimized.
    The dsmhprf01_3_links table is okay.
    The dsmhprf01_3_links table is already optimized.
    The dsmhprf01_3_options table is okay.
    The dsmhprf01_3_options table is already optimized.
    The dsmhprf01_3_postmeta table is okay.
    The dsmhprf01_3_postmeta table is already optimized.
    The dsmhprf01_3_posts table is okay.
    The dsmhprf01_3_posts table is already optimized.
    The dsmhprf01_3_revslider_css table is okay.
    The dsmhprf01_3_revslider_css table is already optimized.
    The dsmhprf01_3_revslider_layer_animations table is okay.
    The dsmhprf01_3_revslider_layer_animations table is already optimized.
    The dsmhprf01_3_revslider_navigations table is okay.
    The dsmhprf01_3_revslider_navigations table is already optimized.
    The dsmhprf01_3_revslider_sliders table is okay.
    The dsmhprf01_3_revslider_sliders table is already optimized.
    The dsmhprf01_3_revslider_slides table is okay.
    The dsmhprf01_3_revslider_slides table is already optimized.
    The dsmhprf01_3_revslider_static_slides table is okay.
    The dsmhprf01_3_revslider_static_slides table is already optimized.
    The dsmhprf01_3_term_relationships table is okay.
    The dsmhprf01_3_term_relationships table is already optimized.
    The dsmhprf01_3_term_taxonomy table is okay.
    The dsmhprf01_3_term_taxonomy table is already optimized.
    The dsmhprf01_3_termmeta table is okay.
    The dsmhprf01_3_termmeta table is already optimized.
    The dsmhprf01_3_terms table is okay.
    The dsmhprf01_3_terms table is already optimized.
    Repairs complete. Please remove the following line from wp-config.php to prevent this page from being used by unauthorized users.
    define('WP_ALLOW_REPAIR', true);

  • Rupok

    Hi Steven Zimmerman

    Hope you had a wonderful day.

    I tried to load "http://brandon2.deal*********.com/" and it's saying "Error establishing a database connection" but "http://coffee.dealsmarthosting.com/" was loading fine.

    This might not be the reason, but I've a weird feeling about your database user. Does your user have full access on your database for creating tables and other stuffs? I know this is a vague question, but can you please confirm?

    I could tell you better about the issue if I could see it live, check your current configuration and make some tests on your site. I tried to login with Support Access but it's showing me the following error:

    The admin did not enable remote access. Please ask the user to grant access.

    Would you mind allowing Support Access so we can have a closer look at this?

    To enable support access you can follow this guide here:
    https://premium.wpmudev.org/manuals/wpmu-dev-dashboard-enabling-staff-login/ht

    Have a nice day. Cheers!

  • Rupok

    Hi Steven Zimmerman

    Hope you had a wonderful day.

    Thanks for granting Support Access. I logged in and checked your configuration. It's not the normal behavior. For example, I created a test site, but it didn't have "http" part that you said, but it already got 3 users. Normally it should have only one user. Can you please send me message with access credentials through our secure contact form here: https://premium.wpmudev.org/contact/

    Subject: "Attn: Rupok"
    - cPanel Username
    - cPanel Password
    - cPanel Login URL
    - Link back to this thread for reference
    - Any other relevant URLs

    Select "I have a different question" for your topic. This and the subject line ensure that it gets assigned to me.

    Does your user have full access on your database for creating tables and other stuffs?

    I actually meant database user, not WordPress user. However, I can check this on behalf of you if you send me cPanel details as I requested above.

    Have a nice day. Cheers!

  • Rupok

    Hi Brandon

    Hope you had a wonderful day.

    Well, thanks for sending cPanel credentials. I investigated the issue further, and found, your database user doesn't have proper access to your database. When a new site is being created, it's not populating the database. So I tried to fix the permission from your cPanel but I got this error:

    Manage User Privileges
    User: dealsm5_steveusr
    Database: dealsm5_stevesstore
    (XID 43bmgh) DBD::mysql::db do failed: There is no such grant defined for user 'dealsm5_steveusr' on host 'ded947.inmotionhosting.com'

    That error indicates there are no grants defined for that MySQL user. It's possible some of the settings in your /etc/my.cnf file are causing this behavior. Can you please talk to your host regarding this and let us know what they say about this? I'm looking forward to hear from you and resolve this issue as soon as possible.

    Have a nice day. Cheers!

  • Steven Zimmerman

    Hello Rupok,

    as suggested we contacted the provider. Below his response:

    Thank you for contacting us today.

    After we spoke, I had one of senior techs look at the email your developer sent you. There does not appear to be anything in the my.cnf that is blocking anything. However, the caveat here is that we are not WordPress multi-site gurus, so would be unsure of the best configuration for that. Here is your current my.cnf:

    root@ded947 [~]# cat /etc/my.cnf
    [mysqld]
    max_connections = 150
    max_user_connections = 100
    query_cache_size = 64M
    skip-external-locking
    key_buffer_size = 64M
    max_allowed_packet=268435456
    table_open_cache = 256
    sort_buffer_size = 1M
    net_buffer_length = 16K
    read_buffer_size = 1M
    read_rnd_buffer_size = 1M
    myisam_sort_buffer_size = 32M
    innodb_file_per_table
    tmp_table_size = 64M
    max_heap_table_size = 64M
    thread_cache_size = 8
    query_cache_type = on

    # This setting allows the use of asynchronous I/O in InnoDB.
    # The following files track usage of this resource:
    # - /proc/sys/fs/aio-max-nr
    # - /proc/sys/fs/aio-nr
    # Default limit is 65536, of which a single instance of mysql uses 2661 out of the box
    innodb_use_native_aio = 1
    default_storage_engine = MyISAM
    open_files_limit=10000
    default-storage-engine=MyISAM

    If there is something there you want changed or added, just let us know.

    I do hope this helps to solve the issue shortly.
    Looking forward hearing from you soon.
    Cheers
    Brandon

  • Rupok

    Hi Brandon

    Hope you had a wonderful day.

    This is really really weird, man. I checked in your cPanel again today, but this time, I could grant permission again. I tried to check almost every possible thing with your site, but nothing is populate your database. Every settings on your site seems to be okay, except .htaccess file. In Network Dashboard > Settings > Network Setup page, you will see some code to place in .htaccess file replacing all previous code. But when I checked your .htaccess file, I saw a lot of other code inside. From those lines, I got idea that you might be using some caching plugin or something.

    Can you please deactivate all plugins and try again? Can you replace your current .htaccess code with the code found in "Network Setup" and let us know the result? I'm really curious about this unique issue and I'd love to solve it as soon as possible.

    Have a nice day. Cheers!
    Rupok

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.