Undismissable error message

  • Resolved Eivin Landa

    (@forsvunnet)


    4 years, 5 months ago

    I am the webmaster and server administrator of many websites that use yoast SEO. To my surprise when I updated yoast SEO which usually plays nice I get this error message saying

    Yoast SEO had problems creating the database tables needed to speed up your site.

    Please read this help article to find out how to resolve this problem.

    Your site will continue to work normally, but won’t take full advantage of Yoast SEO.

    Accompanied by a debug message saying it could not run the SQL CREATE UNIQUE INDEX idx_wp_yoast_migrations_version ON wp_yoast_migrations(version)

    I ran this SQL manually to no avail. Then I read the help article,
    https://yoast.com/help/cannot-create-database-tables, which essentially said “Change hosting provider”. I am the hosting provider and I am not prepared to change the database user permissions which have been selected carefully to provide better security and consistency on our servers.

    I would like help with two things.

    1. Could you provide instructions for what database changes should be made?
    2. Could you provide instructions for how to get rid of the error message?

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    Hello @forsvunnet,

    Thanks for reaching out.

    The ‘Yoast SEO was unable to create the database tables required and as such will not function correctly.’ message is displayed when Yoast is unable to access or create the required database tables. The issue will cause specific features to not work as efficiently as possible, but the majority of the plugin features will work.

    Have you tried to run the Yoast Test Helper while using the Yoast SEO 14.3 plugin? If not, please try the following steps:

    • Go to Tools -> Yoast Test
    • Hit the “Reset indexables & migrations” button
    • Click the “Start processing and speed up your site now” button in SEO > Tools.

      • Please note that, while the above instructions are safe, we always recommend having a current, full backup of your site for safety reasons.

      Furthermore, the database user must have the following database permissions:

    • CREATE
    • DROP
    • ALTER
    • INDEX

      • If the database user has the correct database permissions, please verify that your database contains the tables listed below:

    • wp_yoast_indexable
    • wp_yoast_indexable_hierarchy
    • wp_yoast_migrations
    • wp_yoast_primary_term
    • wp_yoast_seo_links
    • wp_yoast_seo_meta

      • Many thanks.

    Plugin Support Jerlyn

    (@jerparx)

    Hi @forsvunnet ,

    We’re closing this thread because we haven’t heard back from you in a while. Should you have further questions, please open a new thread.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Undismissable error message’ is closed to new replies.