{"id":3130,"date":"2022-02-04T21:27:27","date_gmt":"2022-02-04T21:27:27","guid":{"rendered":"https:\/\/scriptfeeds.com\/blog\/?p=3130"},"modified":"2022-12-06T22:02:41","modified_gmt":"2022-12-06T22:02:41","slug":"fix-wordpress-databasefout-unknown-column-error","status":"publish","type":"post","link":"https:\/\/scriptfeeds.com\/blog\/wordpress\/fix-wordpress-databasefout-unknown-column-error\/","title":{"rendered":"FIX : WordPress databasefout Unknown column error"},"content":{"rendered":"\n<p>WordPress can be tricky sometimes when it comes to error. However WordPress has good built-in error debugging functionality. Our team continuously work on lots of WordPress projects which makes us also working on latest and sometimes rare WordPress errors.<\/p>\n\n\n\n<p>Recently we got a <strong>&#8220;WordPress critical error on page list&#8221;<\/strong> on WordPress page list. So whenever customer click on pages in WordPress backend, list didn&#8217;t load and gives &#8220;WordPress critical error&#8221;. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"checked-error-log\" style=\"font-size:22px\">Checked Error Log<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>We logged in cpanel and checked error log file in WordPress installation. Error log file has following error.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>WordPress database error Unknown column \u2018estimated_reading_time_minutes\u2019 in \u2018field list\u2019 for query INSERT INTO wp_yoast_indexable\u2026<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>As per error log, there is some database column error of <strong>Yoast SEO plugin<\/strong>. So to make sure, we just deactivated the plugin. <\/li>\n\n\n\n<li>After Deactivating the plugin, WordPress pages loaded successfully without any error.<\/li>\n\n\n\n<li>After researching on Yoast SEO Plugin Support forum, we came to know about the error and some possible solutions like &nbsp;<strong>Reset indexables tables &amp; migrations<\/strong><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"solutions\" style=\"font-size:22px\">Solutions<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>We installed and activated&nbsp;<a href=\"https:\/\/wordpress.org\/plugins\/yoast-test-helper\/\" target=\"_blank\" rel=\"noopener\"><strong>Yoast Test Helper<\/strong>&nbsp;plugin<\/a>.<\/li>\n\n\n\n<li>Click on Tools on left side menu and then select &#8220;Yoast Test&#8221;<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"900\" height=\"828\" src=\"https:\/\/scriptfeeds.com\/blog\/wp-content\/uploads\/2022\/02\/yoast-test-helper-scriptfeeds.jpg\" alt=\"\" class=\"wp-image-3379\" title=\"Yoast Test Plugin\" srcset=\"https:\/\/scriptfeeds.com\/blog\/wp-content\/uploads\/2022\/02\/yoast-test-helper-scriptfeeds.jpg 900w, https:\/\/scriptfeeds.com\/blog\/wp-content\/uploads\/2022\/02\/yoast-test-helper-scriptfeeds-399x367.jpg 399w, https:\/\/scriptfeeds.com\/blog\/wp-content\/uploads\/2022\/02\/yoast-test-helper-scriptfeeds-800x736.jpg 800w, https:\/\/scriptfeeds.com\/blog\/wp-content\/uploads\/2022\/02\/yoast-test-helper-scriptfeeds-175x161.jpg 175w, https:\/\/scriptfeeds.com\/blog\/wp-content\/uploads\/2022\/02\/yoast-test-helper-scriptfeeds-598x550.jpg 598w, https:\/\/scriptfeeds.com\/blog\/wp-content\/uploads\/2022\/02\/yoast-test-helper-scriptfeeds-88x81.jpg 88w, https:\/\/scriptfeeds.com\/blog\/wp-content\/uploads\/2022\/02\/yoast-test-helper-scriptfeeds-768x707.jpg 768w, https:\/\/scriptfeeds.com\/blog\/wp-content\/uploads\/2022\/02\/yoast-test-helper-scriptfeeds-750x690.jpg 750w, https:\/\/scriptfeeds.com\/blog\/wp-content\/uploads\/2022\/02\/yoast-test-helper-scriptfeeds-300x276.jpg 300w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In Yoast Test option, click on <strong>&#8220;Reset Indexable tables &amp; migrations&#8221;<\/strong> (check red mark on above image).<\/li>\n\n\n\n<li>Once done, refresh the page. Issue fixed.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"summary\" style=\"font-size:22px\">Summary<\/h2>\n\n\n\n<p>Here we have WordPress critical error because of <strong>&#8220;Yoast SEO plugin&#8221;<\/strong>. Such error can be due to many reason. We recommend to check the error logs and troubleshoot accordingly. Let us know if you face such error. We will surely help you to fix the same.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>WordPress can be tricky sometimes when it comes to error. However WordPress has good built-in error debugging functionality. Our team continuously work on lots of WordPress projects which makes us also working on latest and sometimes rare WordPress errors. Recently we got a &#8220;WordPress critical error on page list&#8221; on WordPress page list. So whenever [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3412,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jnews-multi-image_gallery":[],"jnews_single_post":{"subtitle":"","format":"standard","video":"","gallery":"","source_name":"","source_url":"","via_name":"","via_url":"","override_template":"0","override":[{"template":"1","single_blog_custom":"","parallax":"1","fullscreen":"1","layout":"right-sidebar","sidebar":"default-sidebar","second_sidebar":"default-sidebar","sticky_sidebar":"1","share_position":"top","share_float_style":"share-monocrhome","show_share_counter":"1","show_view_counter":"1","show_featured":"1","show_post_meta":"1","show_post_author":"1","show_post_author_image":"1","show_post_date":"1","post_date_format":"default","post_date_format_custom":"Y\/m\/d","show_post_category":"1","show_post_reading_time":"0","post_reading_time_wpm":"300","show_zoom_button":"0","zoom_button_out_step":"2","zoom_button_in_step":"3","show_post_tag":"1","show_prev_next_post":"1","show_popup_post":"1","number_popup_post":"1","show_author_box":"0","show_post_related":"0","show_inline_post_related":"0"}],"override_image_size":"0","image_override":[{"single_post_thumbnail_size":"crop-500","single_post_gallery_size":"crop-500"}],"trending_post":"0","trending_post_position":"meta","trending_post_label":"Trending","sponsored_post":"0","sponsored_post_label":"Sponsored by","sponsored_post_name":"","sponsored_post_url":"","sponsored_post_logo_enable":"0","sponsored_post_logo":"","sponsored_post_desc":"","disable_ad":"0"},"jnews_primary_category":{"id":"","hide":""},"footnotes":""},"categories":[75,89],"tags":[131,132],"class_list":["post-3130","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress","category-errors","tag-wordpress-critical-error","tag-wordpress-page-404-error"],"_links":{"self":[{"href":"https:\/\/scriptfeeds.com\/blog\/wp-json\/wp\/v2\/posts\/3130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/scriptfeeds.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scriptfeeds.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scriptfeeds.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/scriptfeeds.com\/blog\/wp-json\/wp\/v2\/comments?post=3130"}],"version-history":[{"count":0,"href":"https:\/\/scriptfeeds.com\/blog\/wp-json\/wp\/v2\/posts\/3130\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/scriptfeeds.com\/blog\/wp-json\/wp\/v2\/media\/3412"}],"wp:attachment":[{"href":"https:\/\/scriptfeeds.com\/blog\/wp-json\/wp\/v2\/media?parent=3130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scriptfeeds.com\/blog\/wp-json\/wp\/v2\/categories?post=3130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scriptfeeds.com\/blog\/wp-json\/wp\/v2\/tags?post=3130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}