Yoast database table is missing

  • Resolved siribakke01

    (@siribakke01)


    8 months, 2 weeks ago

    Hi there,

    Hope you are well!

    My host has just advised me that the yoast database table is missing from my database and to contact you on how to fix. This is causing high CPU usage on my site and I’m over the allowed limit. I have tried to delete the plugin and reinstall in but that didn’t help. Please see below error code:

    [17-Jun-2024 13:55:11 UTC] WordPress database error Table ‘dbaap19zq1u0lm.wtm_yoast_indexable’ doesn’t exist for query INSERT INTO wtm_yoast_indexable (object_type, object_id, permalink, title, description, is_cornerstone, is_robots_noindex, is_robots_nofollow, is_robots_noarchive, is_robots_noimageindex, is_robots_nosnippet, is_public, has_public_posts, blog_id, open_graph_image, open_graph_image_id, open_graph_image_source, open_graph_image_meta, twitter_image, twitter_image_id, twitter_image_source, object_published_at, object_last_modified, version, permalink_hash, created_at, updated_at) VALUES (‘user’, ‘1’, ‘https://www.orendagd.com.au/author/siri/’, NULL, NULL, ‘0’, ‘0’, NULL, NULL, NULL, NULL, NULL, ‘0’, ‘1’, ‘https://www.orendagd.com.au/wp-content/litespeed/avatar/17ccbc7db4ed51fe2faa3f62fc4e525b.jpg?ver=1718200252’, NULL, ‘gravatar-image’, NULL, ‘https://www.orendagd.com.au/wp-content/litespeed/avatar/17ccbc7db4ed51fe2faa3f62fc4e525b.jpg?ver=1718200252’, NULL, ‘gravatar-image’, ‘2017-11-18 14:47:50’, ‘2024-06-10 13:27:51’, ‘2’, ’40:34357880606017be512b3b114bc88732′, ‘2024-06-17 13:55:11’, ‘2024-06-17 13:55:11’) made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/Divi/includes/builder/frontend-builder/theme-builder/frontend-body-template.php’), get_header, do_action(‘get_header’), WP_Hook->do_action, WP_Hook->apply_filters, et_theme_builder_frontend_override_header, et_theme_builder_frontend_override_partial, require_once(‘/themes/Divi/includes/builder/frontend-builder/theme-builder/frontend-header-template.php’), wp_head, do_action(‘wp_head’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Front_End_Integration->call_wpseo_head, do_action(‘wpseo_head’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Front_End_Integration->present_head, Yoast\WP\SEO\Presenters\Schema_Presenter->present, Yoast\WP\SEO\Presenters\Schema_Presenter->get, Yoast\WP\SEO\Presentations\Abstract_Presentation->__get, Yoast\WP\SEO\Presentations\Indexable_Presentation->generate_schema, Yoast\WP\SEO\Generators\Schema_Generator->generate, Yoast\WP\SEO\Generators\Schema_Generator->generate_graph, Yoast\WP\SEO\Generators\Schema\Breadcrumb->generate, Yoast\WP\SEO\Presentations\Abstract_Presentation->__get, Yoast\WP\SEO\Presentations\Indexable_Presentation->generate_breadcrumbs, Yoast\WP\SEO\Generators\Breadcrumbs_Generator->generate, Yoast\WP\SEO\Repositories\Indexable_Repository->find_by_id_and_type, Yoast\WP\SEO\Builders\Indexable_Builder->build_for_id_and_type, Yoast\WP\SEO\Builders\Indexable_Builder->build, Yoast\WP\SEO\Builders\Indexable_Builder->maybe_build_author_indexable, Yoast\WP\SEO\Builders\Indexable_Builder->build, Yoast\WP\SEO\Builders\Indexable_Builder->save_indexable, Yoast\WP\SEO\Models\Indexable->save, Yoast\WP\Lib\Model->save, Yoast\WP\Lib\ORM->save, Yoast\WP\Lib\ORM::execute

    Thank you!

    Best regards,

    Siri

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

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

    (@maybellyne)

    Hello @siribakke01

    Thanks for reaching out. We have seen unexpected issues where the previously optimized data is invalid or incomplete. We’ll start with a reset of the optimization to ensure we’ve removed any invalid data. Let’s cover a few important things to be aware of beforehand.

    First, we would understand if you were hesitant to reset the optimized data. We can assure you that your hard work will not be lost as the default WordPress tables also contain the SEO data. This process will only reset the custom Yoast tables with the combined data pulled from those default tables.

    Second, we recommend creating regular backups of your site and database for your site’s health and safety. Backups are especially important before making substantial changes to your website. It provides you with a safety net if something were to go wrong. Learn more about the benefits of regular backups.

    Thirdly, we highly recommend using a staging or testing site to reduce the impact on your live site. Some popular web hosts offer quick setups for a staging site, so please contact your web host for assistance. They will probably be able to help you out. If your web host does not offer staging sites, the WordPress plugin repository offers staging plugins, or you can create your own staging site. To run the data optimization, you must set the WordPress environment type to ‘production’ and restrict access to logged-in users. For some parts of the data optimization, you’ll also need to temporarily switch the subscription from your production site to your staging site.

    Now, back to the issue at hand. We know that resetting the data may sound intimidating, but our How to reset the Yoast indexables guide will walk you through the process step by step. We’ve also summarized the steps below.

    1. Install & activate the?Yoast Test Helper plugin
    2. Go to Tools > Yoast Test
    3. Locate the Yoast SEO section and click on the ‘Reset indexables tables & migrations‘, ‘Reset Prominent words calculation‘, and ‘Reset Internal link counter‘ buttons. After each click, the page will reload to confirm that the specific reset was successful.
    4. Go to SEO > Tools, and under SEO data, click the “Start SEO data optimization” button to allow Yoast to rescan your content.

    Please let us know if the reported issue remains after resetting the optimized data.

    Plugin Support Jose Varghese

    (@josevarghese)

    This thread was marked resolved due to a lack of recent activity. The original poster can change the status to Not Resolved to re-open the issue or open a new topic.

    If you are not the original poster but have a similar issue, please open a new topic.

    Thread Starter siribakke01

    (@siribakke01)

    Thank you very much for all your help! This worked and it’s all back as usual again ??

    Thank you fro your help!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Yoast database table is missing’ is closed to new replies.