Yoast SEO was unable to create the database tables required and as such will not

Resolved Julia Reichbaum
(@bigmattres)

3 years, 11 months ago

Hello! Didn’t find an answer to an error like that. The Yoast Test plugin is installed, the reset button removes the error, but it appears immediately when you go to another page. What can I do?
The debug-log:

[07-May-2020 10:06:10 UTC] WordPress database error Unknown character set: ‘utf8_general_ci’ for query ALTER TABLE wp_yoast_migrations CONVERT TO CHARACTER SET utf8_general_ci made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wpseo_init, YoastSEO, Yoast\WP\SEO\Main->load, Yoast\WP\SEO\Loader->load, Yoast\WP\SEO\Loader->load_initializers, Yoast\WP\SEO\Initializers\Migration_Runner->initialize, Yoast\WP\SEO\Initializers\Migration_Runner->run_free_migrations, Yoast\WP\SEO\Initializers\Migration_Runner->run_migrations, YoastSEO_Vendor\Ruckusing_Task_Manager->execute, YoastSEO_Vendor\Task_Db_Migrate->execute, YoastSEO_Vendor\Task_Db_Migrate->prepare_to_migrate, YoastSEO_Vendor\Task_Db_Migrate->run_migrations, AddCollationToTables->up, YoastSEO_Vendor\Ruckusing_Migration_Base->query, Yoast\WP\Lib\Ruckusing_Adapter->query

[07-May-2020 10:06:17 UTC] WordPress database error Unknown character set: ‘utf8_general_ci’ for query ALTER TABLE wp_yoast_migrations CONVERT TO CHARACTER SET utf8_general_ci made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wpseo_init, YoastSEO, Yoast\WP\SEO\Main->load, Yoast\WP\SEO\Loader->load, Yoast\WP\SEO\Loader->load_initializers, Yoast\WP\SEO\Initializers\Migration_Runner->initialize, Yoast\WP\SEO\Initializers\Migration_Runner->run_free_migrations, Yoast\WP\SEO\Initializers\Migration_Runner->run_migrations, YoastSEO_Vendor\Ruckusing_Task_Manager->execute, YoastSEO_Vendor\Task_Db_Migrate->execute, YoastSEO_Vendor\Task_Db_Migrate->prepare_to_migrate, YoastSEO_Vendor\Task_Db_Migrate->run_migrations, AddCollationToTables->up, YoastSEO_Vendor\Ruckusing_Migration_Base->query, Yoast\WP\Lib\Ruckusing_Adapter->query

[07-May-2020 10:06:17 UTC] WordPress database error Unknown character set: ‘utf8_general_ci’ for query ALTER TABLE wp_yoast_migrations CONVERT TO CHARACTER SET utf8_general_ci made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wpseo_init, YoastSEO, Yoast\WP\SEO\Main->load, Yoast\WP\SEO\Loader->load, Yoast\WP\SEO\Loader->load_initializers, Yoast\WP\SEO\Initializers\Migration_Runner->initialize, Yoast\WP\SEO\Initializers\Migration_Runner->run_free_migrations, Yoast\WP\SEO\Initializers\Migration_Runner->run_migrations, YoastSEO_Vendor\Ruckusing_Task_Manager->execute, YoastSEO_Vendor\Task_Db_Migrate->execute, YoastSEO_Vendor\Task_Db_Migrate->prepare_to_migrate, YoastSEO_Vendor\Task_Db_Migrate->run_migrations, AddCollationToTables->up, YoastSEO_Vendor\Ruckusing_Migration_Base->query, Yoast\WP\Lib\Ruckusing_Adapter->query

[07-May-2020 10:07:16 UTC] WordPress database error Unknown character set: ‘utf8_general_ci’ for query ALTER TABLE wp_yoast_migrations CONVERT TO CHARACTER SET utf8_general_ci made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wpseo_init, YoastSEO, Yoast\WP\SEO\Main->load, Yoast\WP\SEO\Loader->load, Yoast\WP\SEO\Loader->load_initializers, Yoast\WP\SEO\Initializers\Migration_Runner->initialize, Yoast\WP\SEO\Initializers\Migration_Runner->run_free_migrations, Yoast\WP\SEO\Initializers\Migration_Runner->run_migrations, YoastSEO_Vendor\Ruckusing_Task_Manager->execute, YoastSEO_Vendor\Task_Db_Migrate->execute, YoastSEO_Vendor\Task_Db_Migrate->prepare_to_migrate, YoastSEO_Vendor\Task_Db_Migrate->run_migrations, AddCollationToTables->up, YoastSEO_Vendor\Ruckusing_Migration_Base->query, Yoast\WP\Lib\Ruckusing_Adapter->query

[07-May-2020 10:07:55 UTC] WordPress database error Unknown character set: ‘utf8_general_ci’ for query ALTER TABLE wp_yoast_migrations CONVERT TO CHARACTER SET 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(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, wpseo_init, YoastSEO, Yoast\WP\SEO\Main->load, Yoast\WP\SEO\Loader->load, Yoast\WP\SEO\Loader->load_initializers, Yoast\WP\SEO\Initializers\Migration_Runner->initialize, Yoast\WP\SEO\Initializers\Migration_Runner->run_free_migrations, Yoast\WP\SEO\Initializers\Migration_Runner->run_migrations, YoastSEO_Vendor\Ruckusing_Task_Manager->execute, YoastSEO_Vendor\Task_Db_Migrate->execute, YoastSEO_Vendor\Task_Db_Migrate->prepare_to_migrate, YoastSEO_Vendor\Task_Db_Migrate->run_migrations, AddCollationToTables->up, YoastSEO_Vendor\Ruckusing_Migration_Base->query, Yoast\WP\Lib\Ruckusing_Adapter->query

Viewing 4 replies - 1 through 4 (of 4 total)

djennez
(@djennez)

3 years, 11 months ago

Hi @bigmattres , that’s a strange issue.. Can you tell me which DB_CHARSET and DB_COLLATION are set in your wp-config.php?

Thread Starter Julia Reichbaum
(@bigmattres)

3 years, 11 months ago

Hi @djennez!
Of course:
define(‘DB_CHARSET’, ‘utf8_general_ci’);
define(‘DB_COLLATE’, ”);

djennez
(@djennez)

3 years, 11 months ago

@bigmattres that would explain, utf8_general_ci is not a valid charset as far as I know, it’s a collation. I wonder how you’re able to post anything on your site at all, as I’m running into lots of errors if I try that.

The charset would need to be utf8 and the collation utf8_general_ci. Now, I’m not sure if that would interfere with any custom code / database setups you have. But the way you have it set up now would cause problems on default WordPress installations, as well as with our plugin.

Of course it would be nice if we would catch this, but seeing as it’s an edge case due to wrong configuration I’m not sure if we will prioritize it. I have created an issue on our repositories (https://github.com/Yoast/wordpress-seo/issues/15098) so I’m going to mark this as resolved.

Thread Starter Julia Reichbaum
(@bigmattres)

3 years, 11 months ago

@djennez, really, it did help. I didn’t see any problems with the encoding on the website, so I had no idea that something was wrong with us.
Thank you, you are awesome ♥♥♥!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Yoast SEO was unable to create the database tables required and as such will not’ is closed to new replies.