search

Symbiota / Symbiota-deprecated

This original code fork is considered deprecated and no longer maintained by the community. We recommend that you use one of the several actively developed forks.
GNU General Public License v2.0
23 stars 93 forks source link

Search results incomplete #105

Closed jbest closed 7 years ago

jbest commented 7 years ago

I just uploaded new records to the TORCH portal for the BRIT collection and I'm getting inconsistent search results.

When I search for "Collector's Last Name" = "Cory" http://portal.torcherbaria.org/portal/collections/list.php?collector=Cory&db=370;&page=1 I get the expected 3,191 records

But when I search for "Collector's Last Name" = "Best" http://portal.torcherbaria.org/portal/collections/list.php?collector=Best&db=370;&page=1 I get no results.

If I search for "Jason" (http://portal.torcherbaria.org/portal/collections/list.php?collector=Jason&db=370;&page=1), I get three results, two of my collections and one of Jason Schmucker which is what I expect (aside from the fact this is a first name and not last). So my records are being indexed or searched but I'm not getting a match on my last name.

I'm also not getting any matchs on "Jog" (http://portal.torcherbaria.org/portal/collections/list.php?collector=Jog&db=370;&page=1) which should get 4 matches. But I am getting 3 matches for "Suneeti" (http://portal.torcherbaria.org/portal/collections/list.php?collector=Suneeti&db=370;&page=1). There is an S. Jog which probably is the same person, but obviously not matching this search.

egbot commented 7 years ago

This is because name searches are being done through FULLTEXT index, which is significantly faster. However, "best" and "jog" are stop words, which are excluded. I'll see if I can work out a solution.

egbot commented 7 years ago

Should work better now. If a collector name search includes a FULLTEXT stopword, then the FULLTEXT index is not included.