Yoast creating a database connection error

  • Resolved thetravelgal

    (@thetravelgal)


    4 years, 10 months ago

    Just updated Yoast and now every time I go to view a post while logged in as an admin and opening a page from the admin panel or edit screen, I get “Error establishing a database connection”

    When I refresh the page, the post comes right up. But it is doing this for EVERY SINGLE POST/PAGE I open while logged in.

    It doesn’t do this if I’m not logged in, nor could my host get it to do this. Nor could my host identify an error on their end related to this.

    I believe the problem is Yoast because the problem goes away as soon as I disable Yoast and returns as soon as I reactivate it.

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • devnihil

    (@devnihil)

    4 years, 10 months ago

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

    In my past experience I’ve found that semi-sporadic issues with receiving ‘Error establishing a database connection’ are most commonly caused by two things:

      1) If the database or MySQL on the server are under significant strain so having trouble allocating the resources for whatever the database request was.
      2) Crashed tables in the database. This can be caused by a number of issues/plugins, but essentially results in tables not being closed or written to correctly.

    In this case since you said it seems related to Yoast SEO so I would doubt that it was the first possible cause I listed above. If this is due to crashed tables, a simple database check/repair will typically fix the problem. Normally there is a feature to do this from the database area of a host’s control panel area. If it isn’t, it can certainly be requested from your hosting provider.

    If a check/repair doesn’t correct the issue, we’d next recommend you to try the following steps?:

      1. Install & activate the Yoast Test Helper plugin
      2. Go to Tools -> Yoast Test
      3. Hit the “Reset Indexables & Migrations” button
      4. Under SEO → Tools, click the “Start SEO Data Optimization” button.
    Thread Starter thetravelgal

    (@thetravelgal)

    4 years, 10 months ago

    I think I was too quick to blame Yoast. It was Yoast, but I think Yoast wasn’t working because of a REST API issue caused by WP External links. So not Yoast’s fault. I’m still testing now that I deleted that plug-in. And I will follow up and check the database. I haven’t done that for awhile anyway. Thanks for the quick response.

    You can consider this closed. If it still occurs, I’ll have to dive in deeper.

    devnihil

    (@devnihil)

    4 years, 10 months ago

    @thetravelgal Thanks for confirming you were able to resolve the issue by removign the WP External Links plugin. We are going ahead and marking this issue as resolved but please let us know if you require any further assistance.

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

The topic ‘Yoast creating a database connection error’ is closed to new replies.