Hopefully, I could get access to the page source code… BTW I get the following chars first ??????????, if title contains accents, it gets deleted (it’s kept if no accents) and on 2nd save, chars become “????”.
Here’s the Query
Sincerely
DJM
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘duplicate key update date = now()’ at line 18 for query insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 1794, ID, (0+ (MATCH (post_content) AGAINST (‘ ‘)) * 3+ (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 (68))
left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 1794 )
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 = 1794 )
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 != ‘1794’) and post_password =” and post_type IN (‘post’, ‘page’)
group by id
having score >= 2.5 and count(blockterm.term_id) = 0 and COUNT( DISTINCT tagtax.term_taxonomy_id ) >= 1 order by score desc limit 5 on duplicate key update date = now() made by include, do_meta_boxes, call_user_func, yarpp_metabox, yarpp_related, yarpp_cache_enforce
