Long Query Error
-
Hi there,
I use WPEngine to host my wordpress site and use Related Post By Zemanta.
I am getting the error messages complaining about Long Queries:
Example:
[error] [client 198.71.117.152] LONG QUERY: LONG QUERY: \n\t\tSELECT\n\t\t\ttarget.post_id, sum(target.weight * log(361 / least(361, freqs.freq))) as score\n\t\tFROM\n\t\t\twp_zem_rp_tags as target,\n\t\t\t(SELECT label, count(1) as freq FROM wp_zem_rp_tags\n\t\t\t\tWHERE label IN (‘P_camping table’, ‘P_functional design’, ‘P_innovative design’, ‘P_kitchen table’, ‘P_table’, ‘P_well-made’, ‘C_ippinka blog’, ‘C_product stories’, ‘A_tabl’, ‘A_melamin’, ‘A_kitchen’, ‘A_coleman’, ‘A_shelf’, ‘A_steel’, ‘A_lantern’, ‘A_aluminum’, ‘A_portabl’, ‘A_compact’, ‘A_outdoor’, ‘A_foldabl’, ‘A_frame’, ‘A_burner’, ‘A_hanger’)\n\t\t\t\tGROUP BY label\n\t\t\t) as freqs\n\t\tWHERE\n\t\t\ttarget.post_id NOT IN (‘3774’) AND\n\t\t\ttarget.post_date > DATE_SUB(CURDATE(), INTERVAL ‘365’ DAY) AND\n\t\t\ttarget.label=freqs.label AND\n\t\t\ttarget.label IN (‘P_camping table’, ‘P_functional design’, ‘P_innovative design’, ‘P_kitchen table’, ‘P_table’, ‘P_well-made’, ‘C_ippinka blog’, ‘C_product stories’, ‘A_tabl’, ‘A_melamin’, ‘A_kitchen’, ‘A_coleman’, ‘A_shelf’, ‘A_steel’, ‘A_lantern’, ‘A_aluminum’, ‘A_portabl’, ‘A_compact’, ‘A_outdoor’, ‘A_foldabl’, ‘A_frame’, ‘A_burner’, ‘A_hanger’)\n\t\tGROUP BY target.post_id\n\t\tORDER BY score desc, target.post_id desc\n\t\tLIMIT 16;
—-
Could you advise what this means and how we can fix this?
https://www.ads-software.com/plugins/related-posts-by-zemanta/
- The topic ‘Long Query Error’ is closed to new replies.