Get 15% Off! Use Coupon: GlowUp-15

The deal ends in

Error: The Yoast Link Statistics feature is currently disabled


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.

PHPMyadmin Your Database

2. Click on the ‘SQL‘ tab from the top bar of PHPMyAdmin.

PHPMyadmin fix Yoast Database Error

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‘:

create yoast seo 5.0 tables.sql

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.

 

GlowFrog (1)

© 2022 GlowFrog Hosting, LLC. All rights reserved. | Proudly Powered by Vultr and Google Cloud

Get Notified.

Provide us with your email and we will keep you informed with latest updates and news.

Migrate Your WordPress Site to GlowFrog

Need Help Optimizing your WordPress Site?

Talk to our Experts and get a complimentary website review and consultation.