WordPress.org

Ready to get started?Download WordPress

Forums

Yet Another Related Posts Plugin (YARPP)
[Plugin: Yet Another Related Posts Plugin] some hardcoded database prefix bug (2 posts)

  1. Richard Vencu
    Member
    Posted 2 years ago #

    I get an error message for an unknown column wp_posts.ID because my tables are prefixed with yi_ not wp_

    Here it is:

    Eroare bază de date WordPress Unknown column 'wp_posts.ID' in 'on clause' pentru interogarea insert into yi_yarpp_related_cache (reference_ID,ID,score) (SELECT 1401 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('?i s? în de mai c? pentru cu trebuie le v? pe ce cel numai cuvinte negative cuvintelor prin pot ')) * 1 + (MATCH (post_title) AGAINST ('sentimente ?i gânduri cuvinte ')) * 1 + count(distinct if( termtax.taxonomy = 'post_tag', refterms.term_taxonomy_id, null )),1) as score
     from yi_posts
    left join yi_term_relationships as terms on ( terms.object_id = wp_posts.ID )
    left join yi_term_taxonomy as termtax on ( terms.term_taxonomy_id = termtax.term_taxonomy_id )
    left join yi_term_relationships as refterms on ( terms.term_taxonomy_id = refterms.term_taxonomy_id and refterms.object_id = 1401 )
     where post_status in ( 'publish', 'static' ) and ID != '1401' and post_date <= '2010-12-25 15:12:19'  and post_password =''  and post_type = 'post'
     group by ID
     having score >= 5.00 and bit_or(termtax.term_id in (0)) = 0 order by score desc limit 5) union (SELECT 1401 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('?i s? în de mai c? pentru cu trebuie le v? pe ce cel numai cuvinte negative cuvintelor prin pot ')) * 1 + (MATCH (post_title) AGAINST ('sentimente ?i gânduri cuvinte ')) * 1 + count(distinct if( termtax.taxonomy = 'post_tag', refterms.term_taxonomy_id, null )),1) as score
     from yi_posts
    left join yi_term_relationships as terms on ( terms.object_id = wp_posts.ID )
    left join yi_term_taxonomy as termtax on ( terms.term_taxonomy_id = termtax.term_taxonomy_id )
    left join yi_term_relationships as refterms on ( terms.term_taxonomy_id = refterms.term_taxonomy_id and refterms.object_id = 1401 )
     where post_status in ( 'publish', 'static' ) and ID != '1401' and post_date <= '2010-12-25 15:12:19'  and post_password =''  and post_type = 'page'
     group by ID
     having score >= 5.00 and bit_or(termtax.term_id in (0)) = 0 order by score desc limit 5) on duplicate key update date = now() efectuată de require, require_once, include, the_content, apply_filters, call_user_func_array, YARPP->the_content, YARPP->display_related, YARPP_Cache->enforce, YARPP_Cache_Tables->update, W3_Db->query

    http://wordpress.org/extend/plugins/yet-another-related-posts-plugin/

  2. mitcho (Michael Yoshitaka Erlewine)
    Member
    Plugin Author

    Posted 2 years ago #

    This was a bug in YARPP 3.4.2, if I recall... it is fixed in the latest version of YARPP. Please upgrade to 3.4.3.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic