SQL Error Searching in Taxonomies

  • Resolved signor.rossi

    (@signorrossi)


    1 year, 8 months ago

    When I acrivate “Search Taxonomies” I get SQL Errors like these:

    WordPress Database Error: [Not unique table/alias: ‘bsq_tr’]

    SELECT DISTINCT wp_posts.ID,wp_posts.ID as ID,wp_posts.ID as ID FROM wp_posts LEFT JOIN wp_term_relationships AS bsq_tr ON (wp_posts.ID = bsq_tr.object_id) LEFT JOIN wp_term_taxonomy AS bsq_tt ON (bsq_tr.term_taxonomy_id = bsq_tt.term_taxonomy_id) LEFT JOIN wp_terms AS bsq_t ON (bsq_t.term_id = bsq_tt.term_id) LEFT JOIN wp_term_relationships AS bsq_tr ON (wp_posts.ID = bsq_tr.object_id) LEFT JOIN wp_term_taxonomy AS bsq_tt ON (bsq_tr.term_taxonomy_id = bsq_tt.term_taxonomy_id) LEFT JOIN wp_terms AS bsq_t ON (bsq_t.term_id = bsq_tt.term_id) WHERE 1=1 AND ( wp_posts.post_date <= '2023-03-15 18:35:20' ) AND (((wp_posts.post_title LIKE '%Staudamm%') OR (wp_posts.post_content LIKE '%Staudamm%')) OR ( ((bsq_t.name LIKE '%Staudamm%') OR (wp_posts.post_excerpt LIKE '%Staudamm%')) ) ) AND (wp_posts.post_password = '') AND wp_posts.post_type IN ('post', 'glossary') AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'inherit')) ORDER BY wp_posts.post_title LIKE '%Staudamm%' DESC, wp_posts.post_date DESC LIMIT 0, 10
    • This topic was modified 1 year, 8 months ago by signor.rossi.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Ajay

    (@ajay)

    @signorrossi

    Can you tell me what settings you changed to get to this?

    It might be a plugin bug that’s causing a duplicate set of joins.

    Thread Starter signor.rossi

    (@signorrossi)

    You’re right. It was another search plugin to use advanced filtering in the search:

    https://searchandfilter.com/

    I’ll only use Search & Filter pro without Better Search then, as it is double indexing else.

    BTW: S&F has a mode to work with relevansii.

    Plugin Author Ajay

    (@ajay)

    That would make sense to me. You wouldn’t need to double up. But, please do let me know what features do you see there that are useful to you that you haven’t found in Better Search.

    Unfortunately, that is a paid plugin and I’m unable to test it.

    Thread Starter signor.rossi

    (@signorrossi)

    Search&Filter is not just a search improvement plugin. It also offers the opportunity to create filter forms for each taxonomy / date ranges etc.

    The indexing algorithms in Better Search would seem to work better for me as I can finely adjust weights for relevance even for date.

    That stopped me from using Relevansii, as this plugin wasn’t bad in finding related content, but I couldn’t set more weight to current content. So very old content was displayed before current posts, what was not intended.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘SQL Error Searching in Taxonomies’ is closed to new replies.