Yoast DB Error

  • Resolved fmgguy

    (@fmgguy)


    3 months ago

    I am seeing a database error in my error log file:

    WordPress database error Unknown column ‘estimated_reading_time_minutes’ in ‘field list’ for query UPDATE wp_yoast_indexable SET object_id = ‘438’, object_type = ‘post’,

    This has been happening since Jan 2024, and the log file is now 24megs. How do I repair this issue?

    Thanks in advance.

    Jeff

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter fmgguy

    (@fmgguy)

    FYI…Running WordPress 6.6.1, and Youst SEO Version 23.3.

    Plugin Support Mushrit Shabnam

    (@611shabnam)

    Hi @fmgguy

    Can you please try resetting our indexables in the database tables by following the steps below?

    1. Install & activate the?Yoast Test Helper plugin
    2. Go to WordPress dashboard > 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 each reset was successful.
    Note: Resetting the optimization doesn’t undo any of the hard work you’ve put into the plugin as the SEO data is also stored in WordPress’ default tables. It’ll just reset the custom Yoast tables that contain the combined data pulled from those default tables.
    4. Go to WordPress dashboard > Yoast SEO > Tools, and under SEO data, click the “Start SEO data optimization” button to allow Yoast to rescan your?content.

    After that, does that resolve the issue?

    Before you proceed with the aforementioned steps, kindly know that we recommend creating regular backups of your site and database for your site’s health and safety. A backup is crucial before making important changes on your website and provides you with a safety net if something were to go wrong. Learn more about the benefits of regular backups.

    Thread Starter fmgguy

    (@fmgguy)

    Thank you so much for the detailed info. I was able to ‘Reset indexables tables & migrations’, ‘Reset Prominent words calculation’, and ‘Reset Internal link counter’, then run the SEO data optimization. I am hopeful that this has corrected the issue. I’ll keep my eye on the log files for a few days, but so far, so good. Again, thank you for the great detailed info!

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.