• Resolved crush0aj

    (@crush0aj)


    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

    (@crush0aj)

    I’ve disabled the plugin and the plugin is not generating any more errors in the error_log file.

    Plugin Author YARPP

    (@jeffparker)

    Hi @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

    (@jeffparker)

    Hi @crush0aj following up on my last note. Were you able to resolve the errors?

    Plugin Author YARPP

    (@jeffparker)

    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.