Yoast SEO mySQL process freezing when I go to an admin page

  • Resolved salvia49

    (@salvia49)


    2 years ago

    Hello,

    Please, I need know how resolve this bug please.

    Every time I access /wp-admin/, Yoast SEO spawns this mySQL process:

    SELECT P.ID FROM wp_posts AS P WHERE P.post_type IN ('post', 'page', 'attachment', 'wpi_invoice', 'gd_producteur', 'gd_artisan', 'gd_place', 'gd_evenement', 'gd_event', 'product') AND P.post_status NOT IN ('auto-draft') AND P.ID not in ( SELECT I.object_id from wp_yoast_indexable as I WHERE I.object_type = 'post' AND I.version = 2 ) LIMIT 26

    From there, my whole website becomes inaccessible (infinite loading), as long as I don’t kill this process from phpMyAdmin.

    As soon as this process is killed, all my site becomes accessible again, except if I load a page in WP admin, then in this case the site becomes inaccessible again.

    Everything is resolved when I deactivate the Yoast SEO plugin.

    Please note that I have also attempted a database optimization via: Yoast SEO => Tools, and that does not resolve this issue.

    Please help…

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

    (@salvia49)

    I’m the only person who seems to have a problem like this, if I search on the Web, this topic comes up every time.

    Please I really need help, because this problem seems serious, it’s the first time that a plugin makes me crash mySQL, and currently I have to deactivate the Yoast SEO plugin to be able to use my site as admin.

    Thank you in advance for your precious help.

    My settings:

    PHP v8.1
    Wordpress v6.1.1
    Yoast SEO v19.10

    Plugin Support devnihil

    (@devnihil)

    @salvia49 We’re sorry to hear you are experiencing this issue on your site.

    We have seen unexpected issues where the previously optimized data is invalid or incomplete. We’ll 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 were hesitant to reset the optimized data. We can assure you that your hard work will not 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.

    Regarding the issue, 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 Yoast 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.

    Plugin Support Maybellyne

    (@maybellyne)

    This thread was marked resolved due to a lack of activity, but you’re always welcome to re-open the topic. Please read this post before opening a new request.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Yoast SEO mySQL process freezing when I go to an admin page’ is closed to new replies.