Title: Getting errors in error_log file Last modified: May 21, 2021 --- # Getting errors in error_log file * Resolved [crush0aj](https://wordpress.org/support/users/crush0aj/) * (@crush0aj) * [5 years ago](https://wordpress.org/support/topic/getting-errors-in-error_log-file/) * I’ve changed the actual post title with POST_TITLE and actual post content with POST_CONTENT. * [21-May-2021 08:41:16 UTC] WordPress database error Can’t find FULLTEXT index matching the column list for query insert into wp_yarpp_related_cache (reference_ID, ID,score) SELECT 2922 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST(‘ POST_CONTENT’)) * 1 + (MATCH (post_title) AGAINST (‘POST_TITLE’)) * 1 + count( distinct if( terms.term_taxonomy_id in (105,112), terms.term_taxonomy_id, null))* 3 + (1 = 0) * 1,4) as score from wp_posts left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID ) where post_status in ( ‘publish’, ‘ static’ ) and post_password =” and post_type IN (‘post’) AND wp_posts.ID NOT IN (2922) group by ID having score >= 4.000000 and ID != 0 order by score desc limit 10 on duplicate key update date = now() made by require(‘wp-blog-header. php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/generatepress/ single.php’), generate_do_template_part, get_template_part, locate_template, load_template, require(‘/themes/generatepress/content-single.php’), the_content, apply_filters(‘the_content’), WP_Hook->apply_filters, ezTOC::the_content, ezTOC:: get, ezTOC_Post::get, ezTOC_Post->__construct, ezTOC_Post->applyContentFilter, apply_filters(‘the_content’), WP_Hook->apply_filters, YARPP->the_content, YARPP- >display_basic, YARPP->display_related, YARPP_Cache->enforce, YARPP_Cache_Tables- >update, YARPP_Cache->query_safely * [21-May-2021 08:41:16 UTC] WordPress database error Can’t find FULLTEXT index matching the column list for query insert into wp_yarpp_related_cache (reference_ID, ID,score) SELECT 2922 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST(‘ POST_CONTENT’)) * 1 + (MATCH (post_title) AGAINST (‘POST_TITLE’)) * 1 + count( distinct if( terms.term_taxonomy_id in (105,112), terms.term_taxonomy_id, null))* 3 + (1 = 0) * 1,4) as score from wp_posts left join wp_term_relationships as terms on ( terms.object_id = wp_posts.ID ) where post_status in ( ‘publish’, ‘ static’ ) and post_password =” and post_type IN (‘post’) AND wp_posts.ID NOT IN (2922) group by ID having score >= 4.000000 and ID != 0 order by score desc limit 10 on duplicate key update date = now() made by require(‘wp-blog-header. php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/generatepress/ single.php’), generate_do_template_part, get_template_part, locate_template, load_template, require(‘/themes/generatepress/content-single.php’), the_content, apply_filters(‘the_content’), WP_Hook->apply_filters, YARPP->the_content, YARPP- >display_basic, YARPP->display_related, YARPP_Cache->enforce, YARPP_Cache_Tables- >update, YARPP_Cache->query_safely Viewing 4 replies - 1 through 4 (of 4 total) * Thread Starter [crush0aj](https://wordpress.org/support/users/crush0aj/) * (@crush0aj) * [5 years ago](https://wordpress.org/support/topic/getting-errors-in-error_log-file/#post-14466691) * I’ve disabled the plugin and the plugin is not generating any more errors in the error_log file. * Plugin Author [YARPP](https://wordpress.org/support/users/jeffparker/) * (@jeffparker) * [5 years ago](https://wordpress.org/support/topic/getting-errors-in-error_log-file/#post-14478035) * Hi [@crush0aj](https://wordpress.org/support/users/crush0aj/) it looks like a full-text index that YARPP needs may be missing. The YARPP Admin UI should have warned you that you need to create these indexes. * Do you have access to your DB to be able to run queries to add the indexes? * ``` ALTER TABLE wp_posts ADD FULLTEXT yarpp_title (post_title); ALTER TABLE wp_posts ADD FULLTEXT yarpp_content (post_content); ``` * Plugin Author [YARPP](https://wordpress.org/support/users/jeffparker/) * (@jeffparker) * [4 years, 11 months ago](https://wordpress.org/support/topic/getting-errors-in-error_log-file/#post-14538844) * Hi [@crush0aj](https://wordpress.org/support/users/crush0aj/) following up on my last note. Were you able to resolve the errors? * Plugin Author [YARPP](https://wordpress.org/support/users/jeffparker/) * (@jeffparker) * [4 years, 11 months ago](https://wordpress.org/support/topic/getting-errors-in-error_log-file/#post-14581844) * We are going ahead and marking this issue as resolved due to inactivity. In our testing the issue is resolved. If you require any further assistance please create a new issue or re-open this one! Viewing 4 replies - 1 through 4 (of 4 total) The topic ‘Getting errors in error_log file’ is closed to new replies. * ![](https://ps.w.org/yet-another-related-posts-plugin/assets/icon-256x256.png? rev=2549977) * [YARPP - Yet Another Related Posts Plugin](https://wordpress.org/plugins/yet-another-related-posts-plugin/) * [Frequently Asked Questions](https://wordpress.org/plugins/yet-another-related-posts-plugin/#faq) * [Support Threads](https://wordpress.org/support/plugin/yet-another-related-posts-plugin/) * [Active Topics](https://wordpress.org/support/plugin/yet-another-related-posts-plugin/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/yet-another-related-posts-plugin/unresolved/) * [Reviews](https://wordpress.org/support/plugin/yet-another-related-posts-plugin/reviews/) ## Tags * [yarrp](https://wordpress.org/support/topic-tag/yarrp/) * 4 replies * 2 participants * Last reply from: [YARPP](https://wordpress.org/support/users/jeffparker/) * Last activity: [4 years, 11 months ago](https://wordpress.org/support/topic/getting-errors-in-error_log-file/#post-14581844) * Status: resolved