WordPress.org

Ready to get started?Download WordPress

Forums

Yet Another Related Posts Plugin Bug (3 posts)

  1. OzPoker
    Member
    Posted 5 years ago #

    Found a bug in YARRP

    Have been looking for the plugin in responsible for crashing my server all the time and came acorss this error :

    [code]0.2320 SELECT ID, post_title, post_date, post_content, (MATCH (post_title) AGAINST ('warrnambool's new greyhound track officially opened')) as titlescore, COUNT( DISTINCT tagtax.term_taxonomy_id ) as tagscore, COUNT( DISTINCT cattax.term_taxonomy_id ) as catscore, (0+ (MATCH (post_title) AGAINST ('warrnambool's new greyhound track officially opened')) * 3+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score from wpsires_posts left JOIN wpsires_term_relationships AS thistag ON (thistag.object_id = 5529 ) left JOIN wpsires_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id AND tagrel.object_id = wpsires_posts.ID) left JOIN wpsires_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id AND tagtax.taxonomy = 'post_tag') left JOIN wpsires_term_relationships AS thiscat ON (thiscat.object_id = 5529 ) left JOIN wpsires_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id AND catrel.object_id = wpsires_posts.ID) left JOIN wpsires_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id AND cattax.taxonomy = 'category') where (post_status IN ( 'publish', 'static' ) and ID != '5529') and post_password ='' and post_type IN ('post', 'page') group by id having score >= 0 and tagscore >= 2 order by score DESC limit 10
    [wp-content/plugins/yet-another-related-posts-plugin/related-functions.php(8)->yarpp_related()]

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's new greyhound track officially opened')) as titlescore, COUNT( DISTINCT tagtax' at line 1[code]

  2. Hi @OzPoker - this is a known bug in 2.1.3 which does not properly create keywords from the post content--it will be fixed in 2.1.4, to be released in a day or so. If you'd like, you can try downloading the development version.

  3. That "development version" was just released as version 2.1.4.

Topic Closed

This topic has been closed to new replies.

About this Topic