Hello Michael,
Thanks for reaching out.
Reinstalling the Yoast SEO plugin should have created all the necessary tables. Particularly, wp_yoast_seo_links table contains links for the text link counter tool feature. This article explains more about that feature https://yoast.com/how-to-use-the-text-link-counter/. One more thing, can you confirm if you have run the SEO data optimization analysis in WordPress > SEO > Tools?
Thank you Maybellyne,
I did again a re-install and the 1 yoast_seo_links table still is missing.
Sure i did dissable all caches. Is there any way one can “manually” import an maybe empty yoast_seo_links table into the existing database?
Btw. Yes the internal link counting (text link counting) connected with this feature is also missing when i see the “pages” overview. Just the first 2 columns are there with Focus-Keyprhase and “Readability” are there. 🙂
I also did the SEO data optimization analysis. I had not done that previously. But also it brings no change.
I just tried to take an almost empty yoast_seo_links table from another site and import it into the actual database. The import works – still an error remains.
The error in detail is this here:
Database Error: [Table ‘123456789.wp_yoast_seo_links’ doesn’t exist]
SELECT COUNT(P.ID) FROM eac_posts AS P LEFT JOIN eac_yoast_indexable AS I ON P.ID = I.object_id AND I.link_count IS NOT NULL AND I.object_type = ‘post’ LEFT JOIN eac_yoast_seo_links AS L ON L.post_id = P.ID AND L.target_indexable_id IS NULL AND L.type = ‘internal’ AND L.target_post_id IS NOT NULL AND L.target_post_id != 0 WHERE ( I.object_id IS NULL OR L.post_id IS NOT NULL ) AND P.post_status = ‘publish’ AND P.post_type IN (‘post’, ‘page’, ‘fl-builder-template’, ‘pauschale’, ‘zimmertyp’, ‘photouploads’, ‘astra-advanced-hook’)`
Would you have any idea Maybellyne?
Thanks, Michael for the feedback.
Please try these steps that help in resetting the Yoast SEO Indexables tables and migrations:
1. Install and activate the Yoast SEO Test Helper plugin
2. Go to Tools → Yoast Test → Yoast SEO → Reset indexables tables & migrations options to reset it
3. Run the SEO data optimization from the SEO → Tools page again
Then check if the issue is resolved. Do let us know how it goes.
We are going ahead and marking this issue as resolved due to inactivity. If you require any further assistance please create a new issue.
Hi Fevnihil and Maybellyne,
sorry for checking back late.
YES the test helper plugin worked out super fine.
I could recreate the missing yoast_seo_links table with it.
Many thanks for that tip.
Kind greetings,
Michael
