Database optimization never completes

  • Resolved shannonentin

    (@shannonentin)


    2 years ago

    I have attempted to run the Yoast database optimization a few times. It seems to finish – the bar fills to the end -but it never says complete. When I exit out of the page I briefly get a json error popping up, but then everything goes back to normal.

    Then I checked the system error log and the Yoast plugin is firing on almost everything several times a day. Example:

    [Wed Feb 22 16:57:19 2023] [proxy_fcgi:error] [pid 26182:tid 140323409016576] [client 162.247.55.209:36288] AH01071: Got error ‘s_robots_noimageindex= NULL,is_robots_noarchive= NULL,is_robots_nosnippet= NULL,open_graph_image= 'https://thetvtraveler.com/wp-content/uploads/2012/12/010.jpg',open_graph_image_id= '223',open_graph_image_source= 'attachment-image',open_graph_image_meta= '{\\"width\\":1691,\\"height\\":1691,\\"url\\":\\"https://thetvtraveler.com/wp-content/uploads/2012/12/010.jpg\\",\\"path\\":\\"/chroot/home/thetvtra/thetvtraveler.com/html/wp-content/uploads/2012/12/010.jpg\\",\\"size\\":\\"full\\",\\"id\\":223,\\"alt\\":\\"La Salette Shrine Christmas Lights\\",\\"pixels...PHP message: WordPress database error Unknown column 'estimated_reading_time_minutes' in 'field list' for query UPDATEwp_yoast_indexableSETobject_id= '227',object_type= 'post',object_sub_type= 'attachment',permalink= 'https://thetvtraveler.com/wp-content/uploads/2012/12/006.jpg',primary_focus_keyword_score= NULL,readability_score= '0',is_cornerstone= '0',is_robots_noindex= NULL,is_robots_nofollow= '0',is_robots_noimageindex= NULL,is_robots_noarchive= NULL,is_robots_nosnippet= NULL,open_graph_image= 'https://thetvtraveler.com/wp-content/uploads/2012/12/006.jpg',open_graph_image_id= '227',open_graph_image_source= 'attachment-image',open_graph_image_meta= '{\\"width\\":2577,\\"height\\":3435,\\"url\\":\\"https://thetvtraveler.com/wp-content/uploads/2012/12/006.jpg\\",\\"path\\":\\"/chroot/home/thetvtra/thetvtraveler.com/html/wp-content/uploads/2012/12/006.jpg\\",\\"size\\":\\"full\\",\\"id\\":227,\\"alt\\":\\"La Salette Shrine\\",\\"pixels\\":8851995,\\"type...PHP message: WordPress database error Unknown column 'estimated_reading_time_minutes' in 'field list' for query UPDATEwp_yoast_indexableSETobject_id= '238',object_type= 'post',object_sub_type= 'attachment',permalink= 'https://thetvtraveler.com/wp-content/uploads/2013/01/asheville.jpg',primary_focus_keyword_score= NULL,readability_score= '0',is_cornerstone= '0',is_robots_noindex= NULL,is_robots_nofollow= '0',is_robots_noimageindex= NULL,is_robots_noarchive= NULL,is_robots_nosnippet= NULL,open_graph_image= 'https://thetvtraveler.com/wp-content/uploads/2013/01/asheville.jpg',open_graph_image_id= '238',open_graph_image_source= 'attachment-image',open_graph_image_meta= '{\\"width\\":500,\\"height\\":500,\\"url\\":\\"https://thetvtraveler.com/wp-content/uploads/2013/01/asheville.jpg\\",\\"path\\":\\"/chroot/home/thetvtra/thetvtraveler.com/html/wp-content/uploads/2013/01/asheville.jpg\\",\\"size\\":\\"full\\",\\"id\\":238,\\"alt\\":\\"\\",\\"pixels\\":250000,\\"...PHP message: WordPress database error Unknown column 'estimated_reading_time_minutes' in 'field list' for query UPDATEwp_yoast_indexableSETobject_id= '240',object_type= 'post',object_sub_type= 'attachment',permalink= 'https://thetvtraveler.com/wp-content/uploads/2013/01/capemay.jpg',primary_focus_keyword_score= NULL,readability_score= '0',is_cornerstone= '0',is_robots_noindex= NULL,is_robots_nofollow= '0',is_robots_noimageindex= NULL,is_robots_noarchive= NULL,is_robots_nosnippet= NULL,open_graph_image= 'https://thetvtraveler.com/wp-content/uploads/2013/01/capemay.jpg',open_graph_image_id= '240',open_graph_image_source= 'attachment-image',open_graph_image_meta` = ‘{\\”width\\”:500,\\”height\\”:500,\\”url\\”:\\”https://thetvtraveler.com/wp-content/uploads/2013/01/capemay.jpg\\”,\\”path\\”:\\”/chroot/home/thetvtra/thetvtraveler.com/html/wp-content/uploads/2013/01/capemay.jpg\\”,\\”size\\”:\\”full\\”,\\”id\\”:240,\\”alt\\”:\\”Cape May, NJ\\”,\\”pixels\\”:25000…PHP message: WordPress database error Unknown column ‘estimated_reading_time_minutes’ in ‘field list’ for query UPDATE

    ETC – on and on. Please advise.

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    Hello @shannonentin

    I’m sorry about your experience with the SEO data optimization analysis. We have seen unexpected issues where the previously optimized data is invalid or incomplete. We’ll start with resetting the optimization to ensure we remove 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.

    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.

    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 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database optimization never completes’ is closed to new replies.