Related Posts stopped working

  • Resolved indyparker

    (@indyparker)


    2 years, 6 months ago

    Hi Ajay,

    I’ve been using your plugin for a very long time in our theme and it’s never not worked. But recently after upgrading our PHP to 8.1 and updating to WP 6.2.2. the Related Posts have completely stopped working.

    Example post:

    https://shorturl.at/biGKZ

    We use code in our single.php to display the ‘Related Reads’. Currently nothing displays below the title for the Related posts.

    Here is the output from Query Monitor

    QueryCallerComponent

    Error Message

    Error CodeSELECT wp_posts.ID
    FROM wp_posts
    INNER JOIN wp_term_relationships AS crp_tr
    ON (wp_posts.ID = crp_tr.object_id)
    INNER JOIN wp_term_taxonomy AS crp_tt
    ON (crp_tr.term_taxonomy_id = crp_tt.term_taxonomy_id)
    WHERE 1=1
    AND ( wp_posts.post_date <= '2023-07-26 23:12:09' )
    AND wp_posts.ID NOT IN (379924)
    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 ('7 Indian Foods which High Bad Fats')
    ORDER BY score DESC
    LIMIT 0, 3    +

    1. WP_Query->get_posts()

    Plugin: contextual-related-postsUnknown column ‘score’ in ‘order clause’1054

    The same database error appears on all posts

    SELECT wp_posts.ID
    FROM wp_posts
    INNER JOIN wp_term_relationships AS crp_tr
    ON (wp_posts.ID = crp_tr.object_id)
    INNER JOIN wp_term_taxonomy AS crp_tt
    ON (crp_tr.term_taxonomy_id = crp_tt.term_taxonomy_id)
    WHERE 1=1
    AND ( wp_posts.post_date <= '2023-07-26 23:16:15' )
    AND wp_posts.ID NOT IN (380664)
    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 ('MS Dhoni Venture into Acting?')
    ORDER BY score DESC
    LIMIT 0, 3    +

    1. WP_Query->get_posts()

    Plugin: contextual-related-postsUnknown column ‘score’ in ‘order clause’1054

    Please advise on how to fix this.

    Regards Indy Parker

    • This topic was modified 2 years, 6 months ago by indyparker.

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

Viewing 10 replies - 1 through 10 (of 10 total)
Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘Related Posts stopped working’ is closed to new replies.