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

  • 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/

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘[Plugin: Yet Another Related Posts Plugin] some hardcoded database prefix bug’ is closed to new replies.