WordPress.org

Support

Support » Plugins and Hacks » Yet Another Related Posts Plugin Bug

Yet Another Related Posts Plugin Bug

  • OzPoker

    @ozpoker

    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]

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Yet Another Related Posts Plugin Bug’ is closed to new replies.
Skip to toolbar