Yoast SEO 5.0 Cointer Links Error in all my sites

I’ve the same problem too !!

I’ve the same problem too !!

Same Problem

Take a look at https://kb.yoast.com/kb/error-link-statistics-disabled/

how to create these tables using phpmyadmin ?

{WordPress_table_prefix}yoast_seo_links
{WordPress_table_prefix}yoast_seo_meta

As i say in the first post,in my case tables are created and they have content.

mywebsite have same problem what is problem ? :/

Assuming your DB prefix is “wp” then the below will add the tables. If you have another DB prefix, just replace it in SQL below before running.

CREATE TABLE IF NOT EXISTS wp_yoast_seo_meta (
object_id bigint(20) NOT NULL,
internal_link_count int(10) NOT NULL DEFAULT ‘0’,
incoming_link_count int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

—
— Indexes for dumped tables
—

—
— Indexes for table wp_yoast_seo_meta
—
ALTER TABLE wp_yoast_seo_meta
ADD PRIMARY KEY (object_id);

—
— AUTO_INCREMENT for dumped tables
—

—
— AUTO_INCREMENT for table wp_yoast_seo_meta
—
ALTER TABLE wp_yoast_seo_meta
MODIFY object_id bigint(20) NOT NULL AUTO_INCREMENT;

CREATE TABLE IF NOT EXISTS wp_yoast_seo_links (
id bigint(20) NOT NULL,
url varchar(255) NOT NULL,
post_id bigint(20) NOT NULL,
target_post_id bigint(20) NOT NULL,
type varchar(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

—
— Indexes for dumped tables
—

—
— Indexes for table wp_yoast_seo_links
—
ALTER TABLE wp_yoast_seo_links
ADD PRIMARY KEY (id),
ADD KEY link_direction (post_id,type);

—
— AUTO_INCREMENT for dumped tables
—

—
— AUTO_INCREMENT for table wp_yoast_seo_links
—
ALTER TABLE wp_yoast_seo_links
MODIFY id bigint(20) NOT NULL AUTO_INCREMENT;

Somebody here that the plugin creates the tables with content perfectly but they have the Counter Links error?

I can confirm.
I have checked in PHP MyAdmin and there are mentioned tables with proper content in them.

I also can see this message that this feature is disabled and I have to manually create those tables.

SCREEN

Same problem here. Tables were created and have content. I updated Yoast on several sites today and this error occurred on all of them where it froze in the middle of counting links. The tables were created and partially filled with content. There doesn’t seem to be any way to “reset” the count.

Tried truncating the tables and deleting/re-importing the structure but neither worked. Clicking the “Count Links” button again does nothing – not even an error in the Console.

Edit: Some reason they just allowed me to click the “Count Links” button again, but it does the same thing as before – gets through about 345 and then grinds to a hault. One site doesn’t even get past 0 (of 400+) … Maybe they haven’t tested this yet on large sites.

same here. counts the links, creates the tables with loads of data. but then I’m told the feature has been disabled because the plugin cannot create those tablets automatically

Same here, commenting so I see replies.

If the relevant tables are already created in your database and you’re still seeing the error in the plugin related to the new Text Link Counter feature, you’ll need to wait for a while (i.e. one hour) and the error will just disappear eventually.

If the tables exists, there is most likely a cache that is not updated which causes the error to appear. We expect that the message should resolve itself when the cache resets, typically within an hour.

If the tables do not exist, our developers have added the sql query to create the the necessary tables in the following article.

Error: The Yoast Link Statistics feature is currently disabled