Some words in a node are not found, others are

Created on 8 December 2024, 4 months ago

Hi,
I have installed SearchAPI for the first time and have it up and running.
It returns search results but the strange thing is that from the same node with text it finds the node with some keywords from the text but not with other keywords from the same text.
I have attached a screen shot also but this is the text:

Vanaf de Vinkeveense plassen vaar je met de wijzers van de klok mee over de Angstel via Baambrugge naar Abcoude.

It finds this node if I use the words: klok, wijzers, Vinkeveense, plassen, Abcoude
But it does not find this node if I use the words: Angstel, Baambrugge

The Processor settings are configured to ignore case so that's not it. I also find words with uppercase letters when searching in lower case.

The text here is just an example, it is plain text, no special characters or code. I have copied and pasted it from the node source directly as you see it here.

I have no idea where to start searching for this behavior. I did search for this and found all kinds of articles that learned me a lot about Search API but not what could cause this behavior.

I am using Database Server by the way.

Hope someone can help me with this

💬 Support request
Status

Active

Version

1.37

Component

General code

Created by

🇳🇱Netherlands RobBNL

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @RobBNL
  • 🇦🇹Austria drunken monkey Vienna, Austria

    Huh, that is indeed very strange behavior and I don’t have any quick suggestions here for you.
    (Unless you maybe have the “Stopwords” processor enabled and “angstel“ and “baambrugge” are in there?)

    It’s unfortunately not very convenient to inspect the contents of a Database Search index, but here is how to do it:

    1. Go into your database.
    2. There should be a table search_api_db_[INDEX_NAME]_text.
    3. Filter that table by the item in question, something like WHERE item_id = 'entity:node/[NID]:nl'.
    4. The result will list all indexed words for that item in the word column. Look for “angstel” or something similar there. If it isn’t there, then something removes that word from indexing for some reason. If it is there but maybe looks a bit off that’s another thing to worry about, but in this case the problem is probably at search time.
  • 🇳🇱Netherlands RobBNL

    Hi,
    Thansk for the tip to look into the database. I will do that in the upcoming days. I had to move on with the website so I reverted back to the default Search module and used the Content Exclude module to disable some content types from being indexed.

    The words I mentioned are not in the stopwords list so I will check if they are in the database when I am going to do maintenance and try to implement search API again.

Production build 0.71.5 2024