• Resolved manikandan2021

    (@manikandan2021)


    Hi,

    We have getting errors in all pages.
    Please find the below issue and let us know how to rectify,

    WordPress database error: [Unknown
    column ‘estimated_reading_time_minutes’ in ‘field list’]

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

    (@maybellyne)

    Hello Manikandan2021

    We are sorry about the database error. 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 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 SEO > Tools, and under SEO data, click the “Start SEO data optimization” button to allow Yoast to rescan your?content.

    For your site’s health and safety, we recommend creating regular backups of your site and database. This is especially important before making important changes on your website.

    Thread Starter manikandan2021

    (@manikandan2021)

    Maybellyne,

    Once Start SEO data optimization button is triggered it keeps on loading, It is been running for more than 3 to 4 hours now but still it is processing, please advise.

    Thanks,
    Mani

    Plugin Support Michael Ti?a

    (@mikes41720)

    Hi @manikandan2021

    Depending on the size of your website, the SEO data optimization process will take a while to complete. If you check the progress bar underneath the SEO data optimization process, it should continue to show the progress over time.

    If you open your browser’s console and check the network tab, you can check if it continues to process requests as well. Once the process has completed, could you check if the errors still appear?

    Thread Starter manikandan2021

    (@manikandan2021)

    Maybellyne,

    We have left the optimization to run for a while and we get and issue as 502 gateway error. Please find attached screenshot. Please advise
    https://ibb.co/0Dn8fF6

    Thanks,
    Mani

    Plugin Support devnihil

    (@devnihil)

    @manikandan2021 Thanks for your reply and we’re sorry to hear about the continued difficulties.

    Can you please let us know whether your site is particularly large?

    For sites with more than 10,000 posts, we’d advise using the WP CLI command to do the indexation on the server. You can read more about this here:?https://yoa.st/wp-cli-index

    Can you please let us know if this resolves the problems?

    Plugin Support Michael Ti?a

    (@mikes41720)

    Hi,

    This thread has been marked as resolved due to a lack of activity.

    You’re always welcome to re-open this topic. Please read this post before opening a new request.

    Thanks for understanding!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘WordPress database error’ is closed to new replies.