Support archive

Low Search not updating kbk_low_search_indexes for matrix field type

Trent 4 Apr 2018 02:04 question, complete

I am using:
EE 2.11.6
Low Search 4.4.5
Matrix 2.6.1

I am using Matrix field type to add custom search terms to a channel entry.

The issue/scenario is:
1) when new data (eg: kubik) is added to the matrix field Low Search returns the result if you search "kubik".
2) Now if I remove "kubik" from the matrix field and search Low Search still returns results for "kubik"

I have tried rebuilding Index, and Lexicon but still Low Search is not updating it's data.

I decided to look in the database and sure enough "kubik" is still appearing under "kbk_low_search_indexes".

What can be done to fix this?

Replies

1. Low 4 Apr 2018 06:09

   And the keywords 'kubik' is in the index for that specific entry? Does it appear somewhere else than the Matrix field? What about in the channel_data table for the Matrix field; is the keyword 'kubik' present there? That's where Matrix saves its searchable data that LS uses for its index.
   
   You can also try and alt-click the rebuild index link for the collection, which will 'hard reset' the index (delete it before rebuilding instead of updating existing rows).

2. Trent 4 Apr 2018 07:00

   Hey Lo.
   
   My db prefix is kbk.
   
   It looks like it still appears in kbk_channel_data but is removing itself from kbk_matrix_data
   
   So does that mean it's a matrix issue?
   And if it remains in channel_data how come it doesn't display, or is there a dependancy for kbk_matrix_data there?
   Is this an issue you can help with?
   
   Here is all the places it is appearing.
   
   When in entry
   
   kbk_channel_data
   kbk_low_search_indexes (twice)
   kbk_low_search_log
   kbk_low_search_words
   kbk_matrix_data
   
   After deleted from entry
   
   kbk_channel_data
   kbk_low_search_indexes (twice)
   kbk_low_search_log
   kbk_low_search_words

3. Low 4 Apr 2018 14:20

   If it's still in the channel_data table, then it will still be in the search index, too. Note that LS will not look at/read the matrix_data table, just the channel_data table. If the keyword still is present there, then yes, it'll be a Matrix issue.

4. Trent 4 Apr 2018 16:38

   Understood.
   
   I did some more testing and matrix definitely leaves it’s data in the channel_data table.
   
   I will let the matrix guys know about this issue.
   
   I did some additional testing using the grid fieldtype and can confirm this fieldtype works as expected.
   
   So I will switch from matrix to grid to solve this one for me.
   
   Thanks for your help Lo.