Major issues… Absolutely major.
After 3-4 days of problems with the database. My webhost finally shut us down with the following email:
We have disabled your database to return the server to normal usage. To re-enable your database, you will need to correct the following query:
INSERT INTO fgt_yarpp_related_cache (reference_ID,ID,score)
(SELECT 842, ID, (0+ (MATCH (post_content) AGAINST (‘enjoy share ‘)) *
1+ (MATCH (post_title) AGAINST (‘stones chimaera ‘)) * 1+ COUNT(
DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT
cattax.term_taxonomy_id ) * 1) as score from fgt_posts
LEFT join fgt_term_relationships as blockrel on (fgt_posts.ID = blockrel.object_id)
LEFT join fgt_term_taxonomy as blocktax using (term_taxonomy_id)
LEFT join fgt_terms as blockterm on (blocktax.term_id = blockterm.term_id and blockterm.term_id in (1))
LEFT JOIN fgt_term_relationships AS thistag ON (thistag.object_id = 842 )
LEFT JOIN fgt_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
AND tagrel.object_id = fgt_posts.ID)
LEFT JOIN fgt_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
AND tagtax.taxonomy = ‘post_tag’)
LEFT JOIN fgt_term_relationships AS thiscat ON (thiscat.object_id = 842 )
LEFT JOIN fgt_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
AND catrel.object_id = fgt_posts.ID)
LEFT JOIN fgt_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 != ‘842’) and post_password =”
GROUP BY id
HAVING score >= 1.00 and count(blockterm.term_id) = 0 order by score
desc limit 5) union (SELECT 842, ID, (0+ (MATCH (post_content) AGAINST
(‘enjoy share ‘)) * 1+ (MATCH (post_title) AGAINST (‘stones chimaera
‘)) * 1+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT
cattax.term_taxonomy_id ) * 1) AS score FROM fgt_posts
LEFT join fgt_term_relationships as blockrel on (fgt_posts.ID = blockrel.object_id)
LEFT join fgt_term_taxonomy as blocktax using (term_taxonomy_id)
LEFT join fgt_terms as blockterm on (blocktax.term_id = blockterm.term_id and blockterm.term_id in (1))
LEFT JOIN fgt_term_relationships AS thistag ON (thistag.object_id = 842 )
LEFT JOIN fgt_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
AND tagrel.object_id = fgt_posts.ID)
LEFT JOIN fgt_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
AND tagtax.taxonomy = ‘post_tag’)
LEFT JOIN fgt_term_relationships AS thiscat ON (thiscat.object_id = 842 )
LEFT JOIN fgt_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
AND catrel.object_id = fgt_posts.ID)
LEFT JOIN fgt_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 != ‘842’) and post_password =”
GROUP BY id
HAVING score >= 1.00 and count(blockterm.term_id) = 0 order by score desc limit 5) on duplicate key update date = now()
Disabling the YARPP plugin will resolve this issue.
