After upgrading to version 5.x-0.7 searches are returning incorrect result sets.

A search on the word security display 17 items when using 5.x-0.5. However, when using 5.x-0.7 there are zero results.

Please see attached PDF with screenshots.

I've tested multiple times by installing 5.x-0.7, searching, installing 5.x-0.5, and searching. Each search used the same keyword: security.

Thanks for your help.

CommentFileSizeAuthor
Faceted Search Issue.pdf406.15 KBianchan

Comments

David Lesieur’s picture

David Lesieur commented

I don't know how to reproduce this problem. There were no differences between 0.5 and 0.7 in my tests. Do you happen to have the Devel module installed? If so, it might help to check its query log and see if/how Faceted Search's queries are different between the versions.

ianchan’s picture

ianchan commented
Version: 5.x-0.7 » 5.x-0.8

I've tried the latest version. One search returns 7 items but at the top right of the search list it reads "2 results." Using the term security, as in the PDF I attached earlier, it still displays 0 results. I will keep looking at the Devel module information on my Drupal test instance. Any help would be appreciated.

David Lesieur’s picture

David Lesieur commented

Would be great if you could log the queries with Devel against Faceted Search 0.5, and then perform the same tests again with Faceted Search 0.8 and log the new queries. The differences we'll find in the queries between 0.5 and 0.8 should help us resolve the issue.

ianchan’s picture

ianchan commented
Status: Active » Closed (fixed)

This was not a problem with the faceted search module.

The issue was mismatched sequencing of category/term ids within the term_data and category tables.

ianchan’s picture

ianchan commented
Title: Some searches return incorrect results » Searches return incorrect results
Version: 5.x-0.8 » 5.x-0.10
Status: Closed (fixed) » Postponed (maintainer needs more info)

Sorry, this issue is back again.. with a little more information to add to the above.

When I use 5.x-0.10 to search the results set is zero but some facets (with results) are displayed.

Certain content type and taxonomy facet links lead to non-zero result sets while others lead to a zero results display (even though there is number within the parentheses for that facet). For example, the facet link for the content type of Category leads to zero results even though the facets list shows one result for that content type. In another instance of a broken facet link, a taxonomy term facet that displays as having 9 items displays a zero result set. However, when I click through to the subcategories (each with 6 and 3 items) I am able to see their results.

In 5.x-0.5, the main search results always work as do the faceted result links.

I still need to capture the Dev modules output for 5.x-0.10 and 5.x-0.5. However, can you tell me what were the major changes (between 0.5 and 0.7) with displaying the result set and checking against taxonomy?

Thanks!

David Lesieur’s picture

David Lesieur commented

The major change was a complete rewrite of the query building logic. Previously, facet modules where returning arrays of query parts which were assembled together later on. Now, facet modules add their query parts using methods defined by the faceted_search_query class. A mistake might have happened when converting all the queries, but I still haven't been able to reproduce your bugs.

David Lesieur’s picture

David Lesieur commented
Status: Postponed (maintainer needs more info) » Fixed

This should have been fixed in Faceted Search 5.x-0.11. Just re-open the issue if it's not. Thanks.

ianchan’s picture

ianchan commented
Status: Fixed » Closed (fixed)

Thank you. I especially appreciate your quick responses to my questions.