• Hello,
    I expected this post:
    https://mealcomparison.com/green-chef-vs-hello-fresh/
    To show up on this page:
    https://mealcomparison.com/how-long-does-hellofresh-last/

    I’m having 2 taxonomies used for filtering: category, brand
    I’ve checked and both posts have overlapping taxonomy terms in both taxonomies. I imagine there’s something I’m not understanding about this.

    Here’s a Query Monitor output:

    SELECT wp_posts.*, MATCH (wp_posts.post_title) AGAINST ('How long does HelloFresh last?') as score
    FROM wp_posts
    LEFT JOIN wp_term_relationships
    ON (wp_posts.ID = wp_term_relationships.object_id)
    WHERE 1=1
    AND ( wp_posts.post_date <= '2021-11-01 07:10:06' )
    AND wp_posts.ID NOT IN (438)
    AND ( wp_term_relationships.term_taxonomy_id IN (10,35) )
    AND wp_posts.post_type = 'post'
    AND ((wp_posts.post_status = 'publish'
    OR wp_posts.post_status = 'inherit'))
    AND MATCH (wp_posts.post_title) AGAINST ('How long does HelloFresh last?')
    GROUP BY wp_posts.ID
    ORDER BY score DESC
    LIMIT 0, 5

    Could you let me know what else you might need from me?

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Ajay

    (@ajay)

    The query seems to be fine. What is query monitor showing you in terms of number of results found. Also, are you in a position to run this in phpMyAdmin in your server to see what it throws up?

    Assume both these are posts – i.e. not pages or another post type?

    You say you have a brand custom taxonomy? Does the second post fall into either 10 or 35 in terms of category number?

    Thread Starter spost

    (@spost)

    # of results found: Is that the # under the “rows” column? if yes, it’s displaying “1”

    I think I did phpMyAdmin correctly – it seems to display the same post as is being displayed on the front end.

    Yes these are posts.
    Yes the post falls in both 10 and 35 category terms.

    Plugin Author Ajay

    (@ajay)

    Thanks. This appears to be that MySQL FULLTEXT can’t figure out that HelloFresh as a term is available – issue is that it isn’t really a word.

    Does it help if you also turning on matching for content in the settings page.

    Another way would be to use the manual posts option in the meta box at the bottom of the edit post screen and include the post ID explicitly.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Expected post not showing’ is closed to new replies.