Database error: Incorrect integer value: ” for column ‘has_ancestors’

  • Resolved jcastillo1

    (@jcastillo1)


    5 years, 8 months ago

    Hi, this problem is the same described in the post:

    https://ww.wp.xz.cn/support/topic/database-error-after-update-to-14-4-1/

    Error Incorrect integer value: ” for column ‘has_ancestors’ at row 1 de la base de datos de WordPress para la consulta UPDATE wp_yoast_indexable SET object_id = ‘68998’, object_type = ‘post’, object_sub_type = ‘nav_menu_item’, permalink = ‘https://domain.com/sin-categoria/productos/’, primary_focus_keyword_score = NULL, readability_score = ‘0’, is_cornerstone = ‘0’, is_robots_noindex = NULL, is_robots_nofollow = ‘0’, is_robots_noimageindex = NULL, is_robots_noarchive = NULL, is_robots_nosnippet = NULL, open_graph_image = NULL, open_graph_image_id = NULL, open_graph_image_source = NULL, open_graph_image_meta = NULL, twitter_image = NULL, twitter_image_id = NULL, twitter_image_source = NULL, primary_focus_keyword = NULL, canonical = NULL, title = NULL, description = NULL, breadcrumb_title = ‘Productos’, open_graph_title = NULL, open_graph_description = NULL, twitter_title = NULL, twitter_description = NULL, link_count = ‘0’, author_id = ‘8’, post_parent = ‘0’, number_of_pages = NULL, post_status = ‘publish’, is_protected = ‘0’, is_public = NULL, has_public_posts = NULL, blog_id = ‘1’, schema_page_type = NULL, schema_article_type = NULL, has_ancestors = ”, permalink_hash = ’45:bcd005a065e7e7d6645e112e6be1b0ab’, updated_at = ‘2020-09-25 12:00:32’ WHERE id = ‘46177’ realizada por wp_nav_menu_update_menu_items, wp_update_nav_menu_item, wp_update_post, wp_insert_post, do_action(‘wp_insert_post’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Watchers\Indexable_Post_Watcher->build_indexable, Yoast\WP\SEO\Builders\Indexable_Builder->build_for_id_and_type, 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

    Plugin version: 14.9

    The previous message has been closed due to inactivity, but the proposed solution (introducing a hack in the code) is not viable.

    Are you planning to solve this problem permanently?

    • This topic was modified 5 years, 8 months ago by jcastillo1.
    • This topic was modified 5 years, 8 months ago by jcastillo1.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    5 years, 8 months ago

    Hello @jcastillo1,

    Thanks for reaching out!

    Have you considered resetting the Indexables tables and migrations also?

    1. Install & activate the Yoast Test Helper plugin: https://ww.wp.xz.cn/plugins/yoast-test-helper/
    2. Go to Tools -> Yoast Test
    3. Locate the Yoast SEO section and select the “Reset indexables tables & migrations” button
    4. Click the “Click here to speed up your site now” button in the SEO->Tools section.

    Thread Starter jcastillo1

    (@jcastillo1)

    5 years, 8 months ago

    Hi Maybellyne!, I’ve executed:

    wp yoast index

    and the problem persists

    Error Incorrect integer value: ” for column ‘has_ancestors’ at row 1 …

    Pcosta88

    (@pcosta88)

    5 years, 8 months ago

    @jcastillo1

    We understand you are getting a database error. That is a bug. Thank you for bringing this issue to our attention. We apologize for the trouble you are experiencing with our plugin. An issue report is currently open with our development team for this issue.

    In the meantime, we suggest signing up for our newsletter as that is where we will announce product changes and updates. You can sign-up for it here https://yoast.com/newsletter/.

    No known workarounds exist for the bug at this time.

    Thread Starter jcastillo1

    (@jcastillo1)

    5 years, 8 months ago

    Hi Pcosta,

    You’re right, a database error.

    as a temporary fix i have applied the changes published by user japesj:

    https://ww.wp.xz.cn/support/topic/database-error-after-update-to-14-4-1/#post-13096427

    but we are using CI/CD and making constant deploys, changes are overwritten and I have to hardcode

    Priscilla Chapman

    (@priscillamc)

    5 years, 8 months ago

    Hi @jcastillo1,

    Thanks for the update! This problem could be related to an existing open issue.

    We still encourage you to comment or file a new bug report to give us more details or how we can reproduce the problem. That will help the Yoast developer team solve the problem.

    devnihil

    (@devnihil)

    5 years, 7 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 6 replies - 1 through 6 (of 6 total)

The topic ‘Database error: Incorrect integer value: ” for column ‘has_ancestors’’ is closed to new replies.