• WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ordering AS (SELECT ROW_NUMBER() OVER (ORDER BY post_modified_gmt) AS n, pos' at line 1 for query
    WITH ordering AS (SELECT ROW_NUMBER() OVER (ORDER BY post_modified_gmt) AS n, post_modified_gmt
    FROM yg3yh_posts USE INDEX ( type_status_date )
    WHERE post_status IN ('publish')
    AND post_type = 'post'
    ORDER BY post_modified_gmt)
    SELECT post_modified_gmt
    FROM ordering
    WHERE MOD(n, 1000) = 0;
    made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array('pre_get_posts'), WP_Hook->do_action, WP_Hook->apply_filters, WPSEO_Sitemaps->redirect, WPSEO_Sitemaps->build_sitemap, WPSEO_Sitemaps->build_root_map, WPSEO_Post_Type_Sitemap_Provider->get_index_links, WPSEO_Post_Type_Sitemap_Provider->get_all_dates_using_with_clause

    • This topic was modified 5 days, 16 hours ago by zecompadre.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Mushrit Shabnam

    (@611shabnam)

    Hi @zecompadre

    We need more information. Can you kindly let us know the following:

    1. Does your site meet the plugin requirements?
    2. Does the error stop if you temporarily disable sitemaps?
    3. Can you kindly check if the error occurs when Yoast SEO is the only activated plugin on a default theme?
      Often, we see problems occur in combination with another plugin or theme. The fastest way to rule out any conflict is to?deactivate all non-Yoast plugins and switch to a standard theme?like?Twenty Twenty-Two.
      Please test this on your development or staging site, if you have one. If not, we recommend using the?Health Check & Troubleshooting?plugin. This plugin has a troubleshooting mode, which does not affect normal visitors to your site.
      If you’re unfamiliar with checking for conflicts, we’d like to point you to a step-by-step guide that will walk you through the process:?How to check for plugin conflicts.
    Thread Starter zecompadre

    (@zecompadre)

    the problem is the construction of the query on your code, just take a look on the report

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.