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

Hello, after softacolus autopudate Yoast SEO Versión 14.0.1 i see this message

Error: Yoast SEO cannot create database tables

I contact the support of my domain but no one encounter a problem in the database. So, what i have to do to fix it?
Thanks.

@joostdevalk help me please

• This reply was modified 4 years, 10 months ago by emperorshin.

Hi,
I have same error “Yoast SEO was unable to create the database tables required and as such will not function correctly” and I can`t create a new post or page even with 14.0.1.
host confirms we have all permissions needed.

I am having the same issue on my site Mesheble.com after updating the Yoast SEO plugin. How to resolve this error. I am not much technical. Can anyone please help me to resolve this bug?

I tried upgrading to 14.0.2 after having this same error message with 14.0 and 14.0.1 and granting UPDATE and CREATE privileges to the WordPress user and I still get the same error message. Downgrading again…

Upgraded to 14.0.2 and still receiving same error. Deactivated and reactivated plugin and error persists “Yoast SEO was unable to create the database tables required and as such will not function correctly.” Host confirmed yesterday all permissions needed are in place. Ideas?

One thing to check is the database prefix. My problem was caused by mixed-case database prefix. MySQL on our Windows server (and maybe other servers) converts table names to lower case, so a table named wp_yoast_migrations is different than WP_yoast_migrations.

I ended up editing wp-config to change the prefix to all lower case, which broke the admin area. I tried to log in and could not. So after I changed wp-config back to the original database prefix, Yoast started working and I was able to complete the indexation. To summarize how I fixed it:

1. Edit wp-config and change the $database_prefix value to all lower case.
2. Attempt to access the admin area of the site.
3. Edit wp-config back to the original value.
4. Log in again.

Hope this helps! Good luck.

• This reply was modified 4 years, 10 months ago by Emily. Reason: Subscribing to replies

This looks like a Yoast problem. Not a hosting or permissions issue. Anyone agree?

@cleanup

Thanks Emily, we are also hosting on a Windows server and indeed your guidance had ‘seemed’ to resolve the issue for me.

I say ‘seemed’ as I need to test this first, but after applying your ‘fix’ the database error message has gone.

Just as a hint:

In my case, the database table yoast_indexable was created successfully, but the creation of an index was not allowed by the database user. This ended up in a loop that the database table was already created.

[29-Apr-2020 08:29:02 UTC] WordPress database error INDEX command denied to user 'XXX'@'XXX' for table 'wp_yoast_indexable' for query CREATE INDEX <code>object_type_and_sub_type</code> ON <code>wp_yoast_indexable</code>(<code>object_type</code>, <code>object_sub_type</code>) 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, WpYoastIndexable->up, WpYoastIndexable->add_table, WpYoastIndexable->add_indexes, YoastSEO_Vendor\Ruckusing_Migration_Base->add_index, Yoast\WP\Lib\Ruckusing_Adapter->add_index, Yoast\WP\Lib\Ruckusing_Adapter->execute_ddl, Yoast\WP\Lib\Ruckusing_Adapter->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query

Solution:

1. Backup your yoast database tables if not already done
2. Grant database user the index right and flush privileges if needed
3. Drop the affected database table, here yoast_indexable
4. All required database tables should be created now successfully.

Cheers,

Matthieu

• This reply was modified 4 years, 10 months ago by Matthieu-P. Schapranow.

Yoast 14.0.2 installed without a hitch on all of my other sites. For the site I initially installed 14.0.0 on, it was fixed by

1. installing the Yoast Test Helper plugin:

https://www.ads-software.com/plugins/yoast-test-helper/

2. Go to Tools -> Yoast Test

3. Locate the Yoast SEO section and select the “Reset indexables tables & migrations” button

That fixed the issue and the site is operational. I did have to run through the Yoast setup again for that site, but the error did go away.

@albie2011 This seems to have worked, along with rolling back the version of the database. Thanks!

@albie2011 It does seem like it worked. Thanks for sharing. One more question, On your WordPress dashboard, Under Tools > Site Health…

There is a message under the recommended improvements that still says…

“An error occurred while checking whether your site can be found by search engines”

Do you see that message too under that section?

@wpgiftshava no, I do not see that message. Site health says site is healthy.

Have a site with the same error message.

Where can the yoast 14.0.0 version be found?

Thx
Lene

Have a site with the same error message.

Where can the yoast 14.0.0 version be found?

or will yoast create an update soon?

Thx
Lene