WordPress.org

Forums

[resolved] Let me first admit I'm a new WordPress user (3 posts)

  1. CCAN
    Member
    Posted 4 years ago #

    I tried to update to 3.0.1 yesterday and that was obviously a poor choice. This extra code appears on the top of each of our posts:

    <= '2010-08-12 14:51:10' and post_password ='' and post_type = 'post' group by id having score >= 5.00 and count(blockterm.term_id) = 0 order by score desc limit 5) union (SELECT 3563, ID, (0+ (MATCH (post_content) AGAINST ('')) * 1+ (MATCH (post_title) AGAINST ('')) * 1+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score from wp_posts left join wp_term_relationships as blockrel on (wp_posts.ID = blockrel.object_id) left join wp_term_taxonomy as blocktax using (term_taxonomy_id) left join wp_terms as blockterm on (blocktax.term_id = blockterm.term_id and blockterm.term_id in (94,107,257,363,358,255,95,310,359,93,256,362,357,96,248,249)) left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 3563 ) left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id AND tagrel.object_id = wp_posts.ID) left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id AND tagtax.taxonomy = 'post_tag') left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 3563 ) left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id AND catrel.object_id = wp_posts.ID) left JOIN wp_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 != '3563') and post_date <= '2010-08-12 14:51:10' and post_password ='' and post_type = 'page' group by id having score >= 5.00 and count(blockterm.term_id) = 0 order by score desc limit 5) on duplicate key update date = now() made by require, require_once, include, the_content, apply_filters, call_user_func_array, yarpp_default, yarpp_related, yarpp_cache_enforce WordPress database error Table 'ccanblog.wp_yarpp_related_cache' doesn't exist for query insert into wp_yarpp_related_cache (reference_ID,ID,score) values (3563,0,0) on duplicate key update date = now() made by require, require_once, include, the_content, apply_filters, call_user_func_array, yarpp_default, yarpp_related, yarpp_cache_enforce WordPress database error Table 'ccanblog.wp_yarpp_relaate.org/blog' />

    See example: http://www.chesapeakeclimate.org/blog/?p=3563

    How do I fix this? We don't have a tech person on staff so it's up to me.

  2. Jason
    Member
    Posted 4 years ago #

    Do you have a backup of your database by chance?

    Try deactivating the "Yet Another Related Posts" Plugin to see if some or all of the error goes away.

  3. CCAN
    Member
    Posted 4 years ago #

    All fixed. Thank you. :)

    I don't have it backed up. I need to do that, but that's a project for a day when I have the time to figure it out. I'm public relations director, so this stuff is a bit outside of my daily realm.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags