If you are using
WordPress and the infamous
Yoast SEO plugin and are getting the
Error: The Yoast Link Statistics feature is currently disabled then this guide is for you! In this guide, we will go over how to resolve this error in just a few simple steps.
Understanding the Error: The Yoast Link Statistics feature is currently disabled
This error occurs when the
Yoast SEO WordPress Plugin is unable to create the required tables for the new
link building feature. Generally these tables are created automatically however, sometimes they do not get created. The required tables are:
wp_yoast_seo_links
wp_yoast_seo_meta
To resolve this error, we will need to create the tables in your WordPress database. You can do this quickly via PHPMyadmin in
cPanel. First, you will need to know the name of your WordPress database.
Click here for help locating the name of your WordPress database using ‘wp-config.php’.
Secondly, you will need to create a backup of your WordPress database before making any changes. See
How to Make a Backup of Your MySQL Databases.
Resolving the Error: The Yoast Link Statistics feature is currently disabled
1. From PHPMyadmin, click on the Database that belongs to your WordPress website from the left-hand side.
Note: This was the database which we located in the previous step in the ‘wp-config.php’ file.
2. Click on the ‘SQL‘ tab from the top bar of PHPMyAdmin.
3. Create the Yoast Seo 5.0 Tables by pasting the following code into the box then clicking on the ‘Go‘ button at the bottom right-hand corner of the page.
CREATE TABLE `wp_yoast_seo_links` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`post_id` bigint(20) unsigned NOT NULL,
`target_post_id` bigint(20) unsigned NOT NULL,
`type` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `link_direction` (`post_id`,`type`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `wp_yoast_seo_meta` (
`object_id` bigint(20) unsigned NOT NULL,
`internal_link_count` int(10) unsigned NOT NULL DEFAULT '0',
`incoming_link_count` int(10) unsigned DEFAULT NULL,
UNIQUE KEY `object_id` (`object_id`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Paste the above code into the box as shown below, then click ‘Go‘:
That’s it! You have successfully created the Yoast seo 5.0 tables in your WordPress database. This should resolve the error you were receiving from Yoast.
If you are still experiencing issues or need help with the steps, please
Submit a Ticket and we will be happy to create the tables for you or assist you in resolving the issue.
Need Help? Ask us!
[cf7 slug=”Contact Form Style 1″ title=”Contact Form Style 1″]
Helpful Articles & Resources
