I am trying to determine the cause of my site going down daily do to lack of resources. I have noticed some php errors in my log file that point to toolset that may or may not be helping to cause my problem and would like some help troubleshooting them. The following message is shown regularly in the log report.
[04-Dec-2019 06:25:14 UTC] WordPress database error COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'utf8mb4' for query CREATE TABLE wp_d1jdg4x9zr_toolset_maps_address_cache (
address_passed varchar(190) NOT NULL,
address varchar(255) NOT NULL,
point point NOT NULL,
PRIMARY KEY (address_passed)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8_general_ci made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('after_setup_theme'), WP_Hook->do_action, WP_Hook->apply_filters, Types_Main->after_setup_theme, Toolset_Common_Bootstrap::get_instance, Toolset_Common_Bootstrap->__construct, do_action('toolset_common_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, OTGS\Toolset\Maps\Bootstrap->initialize_classes, OTGS\Toolset\Maps\Controller\Troubleshooting\CacheUpdate->init, OTGS\Toolset\Maps\Controller\Cache\CreateDatabaseTable::run, dbDelta
I have created a staging copy of my site temporarily for your access. Additionally, I can provide log files if needed. As far as I can tell is that Toolset Maps is trying to create a table in a method the host doesn't like. The staging site is in privacy mode.
username: flywheel
password: awesome-bell
