Support Forums

Support Forums Forums Search & Filter Pro Blog post is not showing

This topic is: not resolved
Viewing 7 posts - 21 through 27 (of 27 total)
  • Ross Moderator
    #264263
    This reply has been marked as private.
    reflexologycanada-org
    #264795
    This reply has been marked as private.
    Ross Moderator
    #264963
    This reply has been marked as private.
    reflexologycanada-org
    #265480
    This reply has been marked as private.
    Ross Moderator
    #266175
    This reply has been marked as private.
    reflexologycanada-org
    #267415

    Hey Ross,
    This is the host speaking. I have an entry from the error log that shows the possible cause:
    [Fri Nov 20 00:39:43.031216 2020] [proxy_fcgi:error] [pid 11439] [client 209.225.141.228:60831] AH01071: Got error ‘PHP message: WordPress database error Not uniqu
    e table/alias: ‘PMWPAC3’ for query SELECT rac_posts.* FROM rac_posts LEFT JOIN rac_term_relationships ON (rac_posts.ID = rac_term_relationships.object_id) LEFT
    JOIN rac_postmeta PMWPAC3 ON PMWPAC3.post_id = rac_posts.ID AND PMWPAC3.meta_key = ‘_wpac_show_in_search’ LEFT JOIN rac_postmeta PMWPAC ON PMWPAC.post_id = rac_pos
    ts.ID AND PMWPAC.meta_key = ‘_wpac_is_members_only’ LEFT JOIN rac_postmeta PMWPAC2 ON PMWPAC2.post_id = rac_posts.ID AND PMWPAC2.meta_key = ‘_wpac_is_nonmembers_on
    ly’ LEFT JOIN rac_postmeta PMWPAC3 ON PMWPAC3.post_id = rac_posts.ID AND PMWPAC3.meta_key = ‘_wpac_show_in_search’ LEFT JOIN rac_postmeta PMWPAC ON PMWPAC.post_id
    = rac_posts.ID AND PMWPAC.meta_key = ‘_wpac_is_members_only’ LEFT JOIN rac_postmeta PMWPAC2 ON PMWPAC2.post_id = rac_posts.ID AND PMWPAC2.meta_key = ‘_wpac_is_non
    members_only’ WHERE 1=1 AND ( \n rac_term_relationships.term_taxonomy_id IN (48)\n) AND rac_posts.post_type = ‘search-filter-widget’ AND ((rac_posts.post_sta…
    \nPHP message: WordPress database error Not unique table/alias: ‘PMWPAC3’ for query SELECT rac_posts.* FROM rac_posts LEFT JOIN rac_term_relationships ON (rac_p
    osts.ID = rac_term_relationships.object_id) LEFT JOIN rac_postmeta PMWPAC3 ON PMWPAC3.post_id = rac_posts.ID AND PMWPAC3.meta_key = ‘_wpac_show_in_search’ LEFT JOI
    N rac_postmeta PMWPAC ON PMWPAC.post_id = rac_posts.ID AND PMWPAC.meta_key = ‘_wpac_is_members_only’ LEFT JOIN rac_postmeta PMWPAC2 ON PMWPAC2.post_id = rac_posts.
    ID AND PMWPAC2.meta_key = ‘_wpac_is_nonmembers_only’ LEFT JOIN rac_postmeta PMWPAC3 ON PMWPAC3.post_id = rac_posts.ID AND PMWPAC3.meta_key = ‘_wpac_show_in_search
    ‘ LEFT JOIN rac_postmeta PMWPAC ON PMWPAC.post_id = rac_posts.ID AND PMWPAC.meta_key = ‘_wpac_is_members_only’ LEFT JOIN rac_postmeta PMWPAC2 ON PMWPAC2.post_id =
    rac_posts.ID AND PMWPAC2.meta_key = ‘_wpac_is_nonmembers_only’ WHERE 1=1 AND ( \n rac_term_relationships.term_taxonomy_id IN (48)\n) AND rac_posts.post_type = ‘
    search-filter-widget’ AND ((rac_posts.post_sta…\nPHP message: WordPress database error Not unique table/alias: ‘PMWPAC3’ for query SELECT rac_posts.ID FROM rac
    _posts LEFT JOIN rac_term_relationships ON (rac_posts.ID = rac_term_relationships.object_id) LEFT JOIN rac_postmeta PMWPAC3 ON PMWPAC3.post_id = rac_posts.ID AND
    PMWPAC3.meta_key = ‘_wpac_show_in_search’ LEFT JOIN rac_postmeta PMWPAC ON PMWPAC.post_id = rac_posts.ID AND PMWPAC.meta_key = ‘_wpac_is_members_only’ LEFT JOIN ra
    c_postmeta PMWPAC2 ON PMWPAC2.post_id = rac_posts.ID AND PMWPAC2.meta_key = ‘_wpac_is_nonmembers_only’ LEFT JOIN rac_postmeta PMWPAC3 ON PMWPAC3.post_id = rac_pos
    ts.ID AND PMWPAC3.meta_key = ‘_wpac_show_in_search’ LEFT JOIN rac_postmeta PMWPAC ON PMWPAC.post_id = rac_posts.ID AND PMWPAC.meta_key = ‘_wpac_is_members_only’ LE
    FT JOIN rac_postmeta PMWPAC2 ON PMWPAC2.post_id = rac_posts.ID AND PMWPAC2.meta_key = ‘_wpac_is_nonmembers_only’ WHERE 1=1 AND ( \n rac_term_relationships.term_
    taxonomy_id IN (48)\n) AND rac_posts.post_type = ‘search-filter-widget’ AND ((rac_posts.post_st…\nPHP message: WordPress database error Not unique table/alias: ‘
    PMWPAC3’ for query SELECT rac_posts.ID FROM rac_posts LEFT JOIN rac_term_relationships ON (rac_posts.ID = rac_term_relationships.object_id) LEFT JOIN rac_term_
    relationships AS tt1 ON (rac_posts.ID = tt1.object_id) LEFT JOIN rac_postmeta PMWPAC3 ON PMWPAC3.post_id = rac_posts.ID AND PMWPAC3.meta_key = ‘_wpac_show_in_searc
    h’ LEFT JOIN rac_postmeta PMWPAC ON PMWPAC.post_id = rac_posts.ID AND PMWPAC.meta_key = ‘_wpac_is_members_only’ LEFT JOIN rac_postmeta PMWPAC2 ON PMWPAC2.post_id =
    rac_posts.ID AND PMWPAC2.meta_key = ‘_wpac_is_nonmembers_only’ LEFT JOIN rac_postmeta PMWPAC3 ON PMWPAC3.post_id = rac_posts.ID AND PMWPAC3.meta_key = ‘_wpac_sho
    w_in_search’ LEFT JOIN rac_postmeta PMWPAC ON PMWPAC.post_id = rac_posts.ID AND PMWPAC.meta_key = ‘_wpac_is_members_only’ LEFT JOIN rac_postmeta PMWPAC2 ON PMWPAC2
    .post_id = rac_posts.ID AND PMWPAC2.meta_key = ‘_wpac_is_nonmembers_only’ WHERE 1=1 AND ( \n rac_term_relationships.term_taxonomy_id IN (48)…\n’, referer: htt
    ps://www.reflexologycanada.org/en/webinars/

    This suggests that there is an error in the query. Please advise.

    reflexologycanada-org
    #267417

    I also see other errors that seem to include PHP errors in the theme. Searching for this error on google suggests a PHP version issue. This site is running PHP 7.2 at this time.

Viewing 7 posts - 21 through 27 (of 27 total)

You must be logged in to reply to this topic.