WordPress database error for column ‘has_ancestors’

  • Resolved rahulthipse

    (@rahulthipse)


    4 years, 3 months ago

    Hi Team,
    We have installed “Yoast SEO Premium 18.1, below are error log we are getting on our site, Please let us know resolution for this to avoid getting those

    1) Erro de banco de dados do WordPress Incorrect integer value: ” for column ‘has_ancestors’ at row 1 para a consulta SHOW FULL COLUMNS FROM wp_100_yoast_indexable feita por Yoast\WP\Lib\ORM::execute
    2) WordPress database error Incorrect integer value: ” for column ‘has_ancestors’ at row 1 for query SHOW FULL COLUMNS FROM wp_101_yoast_indexable made by Yoast\WP\Lib\ORM::execute
    3) WordPress 資料庫錯誤：Incorrect integer value: ” for column ‘has_ancestors’ at row 1 由指令 SHOW FULL COLUMNS FROM wp_102_yoast_indexable 引發，錯誤來自 Yoast\WP\Lib\ORM::execute`

    Thanks

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

    (@maybellyne)

    4 years, 3 months ago

    Hello Rahulthipse,

    Thanks for reaching out and we are sorry about the WordPress 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 to your website.

    devnihil

    (@devnihil)

    4 years, 2 months ago

    We are going ahead and marking this issue as resolved due to inactivity. If you require any further assistance please create a new issue.

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

The topic ‘WordPress database error for column ‘has_ancestors’’ is closed to new replies.