[04-Dec-2019 06:25:14 UTC] WordPress database error COLLATION 'utf8_general_ci'

This support ticket is created 4 years, 4 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

Tagged: Toolset Maps, Views plugin

This topic contains 1 reply, has 2 voices.

Last updated by Luo Yang 4 years, 4 months ago.

Assisted by: Luo Yang.

Author

Posts

December 4, 2019 at 3:08 pm #1399839

Jonathon Hanten

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

December 5, 2019 at 1:58 am #1400351

Luo Yang

Hello,

It is a known issue, see our errata here:
https://toolset.com/errata/database-collation-error-when-using-toolset-maps/

Currently, you can try workaround in above errata.

Or you can also create that database table manually, see similar thread:
https://toolset.com/forums/topic/wordpress-database-error-collation-utf8_general_ci-is-not-valid-for-characte/

This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.