WordPress Database Error on articles

  • Resolved l1z0b

    (@l1z0b)


    3 years ago

    I’m getting this error:

    WordPress Database Error [Unknown column ‘object_published_at’ in ‘field list’]

    on every article that I published and in my WordPress backend I Can’t see any article but all I see is the error.
    The problem disappears when I disable Yoast SEO, how can I solve this issue?
    The plugin has the 17.6 version and WordPress is updated at 5.8.2

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

    (@maybellyne)

    Hello @l1z0b

    We are sorry about the WordPress database error you received. 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. Learn more about the benefits of regular backups.

    • This reply was modified 3 years ago by Maybellyne.
    Thread Starter l1z0b

    (@l1z0b)

    Will resetting the indexables in the database tables affect my website? I don’t want risk to lose all of my posts and pages and similar and also I don’t want to lose my WordPress configurations.

    • This reply was modified 3 years ago by l1z0b.
    Plugin Support Maybellyne

    (@maybellyne)

    Resetting the indexables and migrations table does not affect the website negatively.

    Thread Starter l1z0b

    (@l1z0b)

    Thank you very much for your help, everything seems okay now!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WordPress Database Error on articles’ is closed to new replies.