Category Not Filtering Properly

  • Resolved Ultimate Electricians Guide

    (@mjones1625)


    6 days, 7 hours ago

    Hey Paul, I’m having an issue with the Site Reviews category filter on a custom testimonials page in my staging site.

    I recorded a quick video showing the full issue, so that will probably explain it better than I can here. Basically, the reviews show when no filter is selected, but when I choose a category from the dropdown, it says “No reviews found,” even though the reviews are assigned to those categories in the backend.

    Could you take a look at the video and let me know if I’m missing something obvious in the block settings or category setup?

    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Paul

    (@pryley)

    6 days, 5 hours ago

    Go to the Categories page, open the Screen Options and enable the TID and TTID columns.

    Are the TID and TTID values identical for each category or different?

    Thread Starter Ultimate Electricians Guide

    (@mjones1625)

    6 days, 4 hours ago

    They are different. For the IBEW Aptitude Test Specifically, its showing 1,334 reviews, 480 TID and 617 TTID.

    Plugin Contributor Paul

    (@pryley)

    6 days, 3 hours ago

    The problem is happening because the Term Taxonomy IDs and Term IDs are not identical. This can happen if your website has been around since before WordPress 4.2 (2015). See: https://salferrarello.com/term_taxonomy_id-vs-term_id/

    Here is a code snippet that should fix the problem:

    Please make a backup of your database that can be restored in case something goes wrong.
    Do this before using the code snippet!

    You can use the Code Snippets plugin to run this snippet on your website: https://wordpress.org/plugins/code-snippets/

    Once you have activated the snippet, RELOAD the page and then DEACTIVATE IT and remove it from your website.

    Also, make sure that the Site Reviews plugin is installed and activated.

    This code snippet does the following:

    1. Queries the database for all entries in the wp_term_relationships and wp_term_taxonomy tables.
    2. Removes all entries from the wp_term_relationships and wp_term_taxonomy tables.
    3. Repopulates the the wp_term_relationships and wp_term_taxonomy tables with the fixed term_taxonomy_id column values.

    Code snippet: https://pastebin.com/vr2eTfzS

    Thread Starter Ultimate Electricians Guide

    (@mjones1625)

    6 days ago

    This fixed it, thank you!

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

You must be logged in to reply to this topic.