Issue after updating to 14.2

  • Resolved althafrahman

    (@althafrahman)


    4 years, 9 months ago

    I have updated Yoast from 13.5 to 14.2 but on my dashboard it shows this:

    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.

    Show debug information

    WpYoastIndexable – Error executing ‘query’ with: CREATE TABLE wp_yoast_indexable ( id int(11) UNSIGNED auto_increment NOT NULL, permalink mediumtext, permalink_hash varchar(191), object_id int(11) UNSIGNED, object_type varchar(32) NOT NULL, object_sub_type varchar(32), author_id int(11) UNSIGNED, post_parent int(11) UNSIGNED, title varchar(191), description text, breadcrumb_title varchar(191), post_status varchar(191), is_public tinyint(1), is_protected tinyint(1) DEFAULT ‘0’, has_public_posts tinyint(1), number_of_pages int(11) UNSIGNED, canonical mediumtext, primary_focus_keyword varchar(191), primary_focus_keyword_score int(3), readability_score int(3), is_cornerstone tinyint(1) DEFAULT ‘0’, is_robots_noindex tinyint(1) DEFAULT ‘0’, is_robots_nofollow tinyint(1) DEFAULT ‘0’, is_robots_noarchive tinyint(1) DEFAULT ‘0’, is_robots_noimageindex tinyint(1) DEFAULT ‘0’, is_robots_nosnippet tinyint(1) DEFAULT ‘0’, twitter_title varchar(191), twitter_image mediumtext, twitter_description mediumtext, twitter_image_id varchar(191), twitter_image_source varchar(191), open_graph_title varchar(191), open_graph_description mediumtext, open_graph_image mediumtext, open_graph_image_id varchar(191), open_graph_image_source varchar(191), open_graph_image_meta text, link_count int(11), incoming_link_count int(11), prominent_words_version int(11) UNSIGNED, PRIMARY KEY (id)) DEFAULT CHARSET=utf8; Reason: Table ‘wp_yoast_indexable’ already exists

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hi,

    We apologize for the difficulties the plugin is causing for you. We would like some more information.

    1.?Verify your database has the: ALTER, CREATE, DELETE, INDEX, INSERT, SELECT, UPDATE, DROP permissions. These are required to create these tables in your database: wp_yoast_indexable, wp_yoast_indexable_hierarchy, wp_yoast_migrations, wp_yoast_primary_term. If you are not sure, your host provider can help.

    2.?Can you confirm your server has all the right requirements?? If you are not sure, speak to your host provider. This guide explains more:?https://kb.yoast.com/kb/plugin-requirements/.

    3.?If you use the Yoast Helper Tool does the issue resolve? Please try the steps below:
    – i. Install & activate the Yoast Test Helper plugin:?https://www.ads-software.com/plugins/yoast-test-helper/
    – ii. Go to Tools -> Yoast Test
    – iii. Locate the Yoast SEO section and select the “Reset indexables tables & migrations” button
    – iv. Click the “Click here to speed up your site now” button in the SEO->Tools section.

    Thread Starter althafrahman

    (@althafrahman)

    Hello,

    The Yoast Test Helper fixed the issue.

    Thank you!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Issue after updating to 14.2’ is closed to new replies.