Error establishing database connection error

  • Resolved sammishra

    (@sammishra)


    11 months ago

    We have a website based on php, next js. But in recent days we are facing this issue which says ‘ error establishing database connection’ and hence we could not access our cmspanel. While checking the causes of this error we found an unusual activity in yoast_seo_indexable table, in which about 4000-5000 new rows are getting added each day, among which most of them are of null values. Could you please help us to know the importance of this table and effect it is causing on the wordpress.

    • This topic was modified 11 months ago by sammishra.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support Rohan Sadanandan

    (@rohans123)

    Hi @sammishra,

    Thanks for reaching out.

    The Indexable table contains all your SEO data.

    First, let’s see what the Yoast SEO plugin is doing when you start the SEO Data Optimization process under Yoast SEO > Tools:

    1. The plugin performs what we call the indexables process, which moves data from one table in your database to another table (wp_yoast_indexable) for each object on your site (posts, pages or anything else that has a URL). This is a one-time process that will help improve the plugin’s performance.
    2. Then, it analysis each of your posts, looking for links inside the content. It uses this information to give you information about how your posts are interlinked. This is used in the text link counter feature.
    3. Finally, it will figure out what the prominent words in your content are. This is used for the internal linking suggestions feature.

    You can reset the indexables by following the steps in this guide: How to reset the Yoast indexables. ?I can assure you that your hard work will not be lost as the default WordPress tables also contain SEO data.?

    By default, as per the?technical specification, Yoast SEO will continuously create indexables for all the content that can be optimized on a site. This includes posts, pages, custom post types, and archives for taxonomies (categories, tags, and custom types), users, and so on.

    We understand you want to optimize the wp_yoast_indexable table considering its table size. We provide a range of filters to alter the default behavior or interact with the table; you might choose the suitable one.

    We hope this will help you in the right direction. Let us know if you’ve any further questions.

    Thread Starter sammishra

    (@sammishra)

    Sir, do you think that the error ‘Error establishing database connection’ was triggered because of this plugin?. Please provide us some insights on this.

    (1539057, NULL, NULL, NULL, ‘user’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, ‘https://secure.gravatar.com/avatar/?s=500&d=mm&r=g’, NULL, NULL, ‘gravatar-image’, NULL, NULL, ‘https://secure.gravatar.com/avatar/?s=500&d=mm&r=g’, NULL, ‘gravatar-image’, NULL, NULL, NULL, NULL, ‘2021-12-29 06:11:15’, ‘2022-01-31 17:45:21’, 1, NULL, NULL, NULL, NULL, 0),

    (1539058, ”, NULL, NULL, ‘post’, NULL, NULL, NULL, NULL, NULL, NULL, ‘unindexed’, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘2021-12-29 06:11:15’, ‘2021-12-29 06:11:15’, 1, NULL, NULL, NULL, NULL, 0),

    (1533386, ”, NULL, NULL, ‘post’, NULL, NULL, NULL, NULL, NULL, NULL, ‘unindexed’, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘2021-12-27 06:02:53’, ‘2021-12-27 06:02:53’, 1, NULL, NULL, NULL, NULL, 0),

    Please refer the above rows, these kind of values are getting stored in yoast_seo_indexable table, There is about 43 lakh rows in yoast_seo_indexable table and each day about 4-5 thousand rows are getting added but the rows are more or less like the ones that i provided above, containing just the null values.

    • This reply was modified 11 months ago by sammishra.
    Thread Starter sammishra

    (@sammishra)

    (1539057, NULL, NULL, NULL, ‘user’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, ‘https://secure.gravatar.com/avatar/?s=500&d=mm&r=g’, NULL, NULL, ‘gravatar-image’, NULL, NULL, ‘https://secure.gravatar.com/avatar/?s=500&d=mm&r=g’, NULL, ‘gravatar-image’, NULL, NULL, NULL, NULL, ‘2021-12-29 06:11:15’, ‘2022-01-31 17:45:21’, 1, NULL, NULL, NULL, NULL, 0),

    (1539058, ”, NULL, NULL, ‘post’, NULL, NULL, NULL, NULL, NULL, NULL, ‘unindexed’, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘2021-12-29 06:11:15’, ‘2021-12-29 06:11:15’, 1, NULL, NULL, NULL, NULL, 0),

    (1533386, ”, NULL, NULL, ‘post’, NULL, NULL, NULL, NULL, NULL, NULL, ‘unindexed’, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘2021-12-27 06:02:53’, ‘2021-12-27 06:02:53’, 1, NULL, NULL, NULL, NULL, 0),

    Please refer the above rows, these kind of values are getting stored in yoast_seo_indexable table, There is about 43 lakh rows in yoast_seo_indexable table and each day about 4-5 thousand rows are getting added but the rows are more or less like the ones that i provided above, containing just the null values.

    Plugin Support Rohan Sadanandan

    (@rohans123)

    Hi @sammishra,

    Can you please try the following steps and let us know the results?

    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.

    Do let me know how it goes.

    Thread Starter sammishra

    (@sammishra)

    I need to confirm this once, I have deactivated yoast seo plugin and the backend has not gone down from past 20 hrs. But we have lost all seo settings. I wanted to try the yoast test helper plugin that you mentioned once, but could you please specify the versions and configurations required inorder to install it and the issue that i might face after its installation.

    Please let us know if there is any alternative method to optimize that yoast_indexable table.

    Plugin Support Rohan Sadanandan

    (@rohans123)

    Hi @sammishra,

    Before installing the Yoast Test Helper plugin, please make sure that you’re running the latest version of the Yoast SEO plugin (v21.7), and we recommend creating regular backups of your site and database for your site’s health and safety. A backup is crucial before installing, updating, or removing plugins?and provides you with a safety net if something were to go wrong. Learn more about the benefits of regular backups.

    Thread Starter sammishra

    (@sammishra)

    I have deactivated the yoast seo plugin, and the site as well as the wordpress is working fine now. Thank you for your help.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Error establishing database connection error’ is closed to new replies.