Post sitemap broken

  • Resolved Enrique Gonzalez

    (@rickyprice)


    1 year, 7 months ago

    This sitemap suddenly stopped working. It works on my other sites that also use Dreampres (ie https://pontik.com ) so I contacted Dreamhost support and here is their answer. Please advise what to do.

    Hello,

Good day!

This is Neo again, and I hope this email finds you well.

As per further review, we found a database fatal errors with the Yoast
    plugin in the PHP logs:
    [Tue Apr 11 16:02:27.386735 2023] [proxy_fcgi:error] [pid 15146:tid
    140462072559360] [client 180.190.27.62:0] AH01071: Got error 'PHP
    message: WordPress database error Commands out of sync; you can't run
    this command now for query SELECT * FROM     aiheg_yoast_indexable WHERE
    object_type = 'home-page' LIMIT 1 made by
    WP_Fatal_Error_Handler->handle,
    WP_Fatal_Error_Handler->display_error_template,
    WP_Fatal_Error_Handler->display_default_error_template, wp_die,
    _default_wp_die_handler, wp_robots, apply_filters('wp_robots'),
    WP_Hook->apply_filters,
    Yoast\\WP\\SEO\\Integrations\\Front_End\\WP_Robots_Integration->add_robots,
    Yoast\\WP\\SEO\\Integrations\\Front_End\\WP_Robots_Integration->get_robots_value,
    Yoast\\WP\\SEO\\Memoizers\\Meta_Tags_Context_Memoizer->for_current_page,
    Yoast\\WP\\SEO\\Repositories\\Indexable_Repository->for_current_page,
    Yoast\\WP\\SEO\\Repositories\\Indexable_Repository->find_for_home_page,
    Yoast\\WP\\Lib\\ORM->find_one, Yoast\\WP\\Lib\\ORM->run,
    Yoast\\WP\\Lib\\ORM::executePHP message: WordPress database error
    Commands out of sync; you can't run this command now for query SELECT *
    FROM aiheg_yoast_indexable WHERE object_type = 'home-page' LIMIT 1
    made by WP_Fatal_Error_Handler->handle,
    WP_Fatal_Error_Handler->display_error_template,
    WP_Fatal_Error_Handler->display_default_error_template, wp_die,
    _default_wp_die_handler, wp_robots, apply_filters('wp_robots'),
    WP_Hook->apply_filters,
    Yoast\\WP\\SEO\\Integrations\\Front_End\\WP_Robots_Integration->add_robots,
    Yoast\\WP\\SEO\\Integrations\\Front_End\\WP_Robots_Integration->get_robots_value,
    Yoast\\WP\\SEO\\Memoizers\\Meta_Tags_Context_Memoizer->for_current_page,
    Yoast\\WP\\SEO\\Repositories\\Indexable_Repository->for_current_page,
    Yoast\\WP\\SEO\\Repositories\\Indexable_Repository->find_for_home_page,
    Yoast\\WP\\Lib\\ORM->find_one, Yoast\\WP\\Lib\\ORM->run,
Yoast\\WP\\Lib\\ORM::executePHP message: WordPress database error
Commands out of sync; you can't run this command now for query
\n\t\t\tSELECT MAX(p.post_modified_gmt) AS last_modified,
MIN(p.post_date_gmt) AS published_at\n\t\t\tFROM aiheg_posts AS
p\n\t\t\tWHERE p.post_status IN ('publish')\n\t\t\t\tAND p.post_password
= ''\n\t\t\t\tAND p.post_type = 'post'\n\t\t made by
WP_Fatal_Error_Handler->handle,
WP_Fatal_Error_Handler->display_error_template,
WP_Fatal_Error_Handler->display_default_error_template, wp_die,
_default_wp_die_handler, wp_robots, apply_filters('wp_robots'),
WP_Hook->apply_filters,
Yoast\\WP\\SEO\\Integrations\\Front_End\\WP_Robots_Integration->add_robots,
Yoast\\WP\\SEO\\Integrations\\Front_End\\WP_Robots_Integration->get_robots_value,
Yoast\\WP\\SEO\\Memoizers\\Meta_Tags_Context_Memoizer->for_current_page,
Yoast\\WP\\SEO\\Repositories\\Indexable_Repository->for_current_page,
Yoast\\WP\\SEO\\Repositories\\Indexable_Repository->find_for_home_page,
Yoast\\WP\\SEO\\Builders\\Indexable_Builder->build_for_home_page,
Yoast\\WP\\SEO\\Builders\\Indexable_Builder->bu...PHP message: WordPress
database error Commands out of sync; you can't run this command now for
query INSERT INTO aiheg_yoast_indexable (object_type, title,
breadcrumb_title, permalink, blog_id, description,
is_robots_noindex, open_graph_title, open_graph_image,
open_graph_image_id, open_graph_description,
open_graph_image_source, open_graph_image_meta,
object_published_at, object_last_modified, version,
permalink_hash, created_at, updated_at) VALUES ('home-page',
'Eventos y Conciertos en Costa Rica - adondeirhoy.com', 'Home',
'https://adondeirhoy.com/', '1', 'Sitio web #1 de conciertos en Costa
Rica. Informacion oficial de entretenimiento, eventos y conciertos en
Costa Rica', '0', '%%sitename%%', '', '0', '', NULL, NULL, NULL, NULL,
'2', '24:ed77d7bb502e15c255f471ce6a59927f', '2023-04-11 23:02:27',
'2023-04-11 23:02:27') made by WP_Fatal_Error_Handler->handle,
WP_Fatal_Error_Handler->display_error_template,
WP_Fatal_Error_Handler->display_default_error_templ...'

The Yoast table appears to be corrupted, which is causing the critical
error when the plugin is active. This is something you would need to look
into with the Plugin developers

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

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

    (@rickyprice)

    Currently also https://adondeirhoy.com/page-sitemap.xml is not working

    Plugin Support devnihil

    (@devnihil)

    @rickyprice We’re sorry to hear you are experiencing these issues on your site.

    Regarding the database errors you received, we have seen unexpected issues where the previously optimized data is invalid or incomplete. To resolve this we’d recommend to start with a reset of the optimization to ensure we’ve removed any invalid data. Let’s cover a few important things to be aware of beforehand.

    First, we would understand if you are hesitant to reset the optimized data, but we can assure you that none of your work or settings will be lost as the default WordPress tables also contain the SEO data. This process will only reset the custom Yoast tables with the combined data pulled from those default tables.

    Second, we recommend creating regular backups of your site and database for your site’s health and safety. Backups are especially important before making substantial changes to your website. It provides you with a safety net if something were to go wrong. Learn more about the benefits of regular backups.

    Thirdly, we highly recommend using a staging or testing site to reduce the impact on your live site. Some popular web hosts offer quick setups for a staging site, so please contact your web host for assistance. They will probably be able to help you out. If your web host does not offer staging sites, the WordPress plugin repository offers staging plugins, or you can create your own staging site.

    Now, back to the issue at hand. We know that resetting the data may sound intimidating, but our How to reset the Yoast indexables guide will walk you through the process step by step. We’ve also summarized 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 the specific reset was successful.
    4. Go to SEO > Tools, and under SEO data, click the “Start SEO data optimization” button to allow Yoast to rescan your content.

    Please let us know if the reported issue remains after resetting the optimized data.

    As for the 500 errors on the page and post sitemaps, this is typically caused by that the resources required to generate the sitemap are not available or the request is timing out due to the resource restrictions of the server environment. We would first recommend ensuring that the PHP settings for both max_execution_time and memory_limit are set to a high enough value in the PHP environment. This setting is typically controlled by editing the values in a php.ini file such as in the following example:

    max_execution_time = 300
memory_limit = 256M

    If you aren’t sure how to change these settings in php.ini, we would recommend contacting your hosting provider for additional assistance.

    If you are still receiving a 500 error after increasing the PHP memory and execution time, the issue may be caused by that the PHP script run time restriction on the server is being reached.

    In order to reduce the amount of time necessary for the script to generate the sitemap, you can reduce the number of entries in the sitemap. By default, the number of entries in the sitemap is set to 1000 but by decreasing this value it will decrease the amount of resources required to generate the sitemap. To decrease the number of sitemap entries you can use the filter wpseo_sitemap_entries_per_page. We have more information on using this developer filter at the following link: Limit the number of sitemap entries.

    Can you please try the aforementioned suggestions and let us know whether this resolves your issue?

    Thread Starter Enrique Gonzalez

    (@rickyprice)

    Backups are set daily so there is no issue there, still we did not know when the error happened so it was a blind search there.

    Reset data and did data optimization. THAT FIXED IT. Thanks

    max_execution_time = 300 memory_limit = 256M that is correct in the site

    To decrease the number of sitemap entries you can use the filter?wpseo_sitemap_entries_per_page. We have more information on using this developer filter at the following link:?Limit the number of sitemap entries. Nowhere in there says where to place that script/filter so if you can help me explaining better how to do it I can set it up to 500, although it seems it is already set to 100.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Post sitemap broken’ is closed to new replies.