Support » Plugin: Yoast SEO » Yoast SEO 5.0 Cointer Links Error in all my sites

  • Resolved alfredo49

    (@alfredo49)


    Hi:

    I just updated Yoast SEO 5.0 but when i count the links (perfect) ,

    “The Text link counter feature (introduced in Yoast SEO 5.0) is currently disabled. For this feature to work Yoast SEO needs to create a table in your database. We were unable to create this table ”

    The tables are created and have content in the database, i dont understand the problem

Viewing 15 replies - 1 through 15 (of 18 total)
  • I’ve the same problem too !!

    I’ve the same problem too !!

    Same Problem

    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.

    Plugin Support jerparx

    (@jerparx)

    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.

    Plugin Support amboutwe

    (@amboutwe)

    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

Viewing 15 replies - 1 through 15 (of 18 total)
  • The topic ‘Yoast SEO 5.0 Cointer Links Error in all my sites’ is closed to new replies.