1.6.1.12 Having trouble with searching some words, is there a word size limit?

[Black RL]

Hi,

 

I'm running some tests, and the only explanation that seems plausible, is that search has a limit for word size, here are some search tests:

pingente, returns c/pingente and pingente, OK

sapelly, returns mogno/sapelly and sapelly, OK

 

But working with 61623ABF0113/6162379091/61623CR017 I get mixed results:

61623ABF0113/6162379091/61623CR017, returns correctly, OK

61623ABF0113, returns correctly, OK

6162379091, no results, NOT OK

61623CR017, no results, NOT OK

 

You could say it's because the word is at the middle/end, but it worked for the first examples, so something different is happening here, word size limit? Other?

 

Note:

Search within word: OFF

Search exact end match: OFF

 

Can someone shed some light on this? Thanks!

[musicmaster]

Search looks also in your description, at the manufacturer, etc. So it may not have been the name that resulted in the finding.

[Black RL]

That's not the problem, the search weight of all that is set to zero.

 

Anyway, I've done multiple SQL queries to the database and I've come to some conclusions, they aren't has robust as I would like them to be, but they make some sense, so for this example:

 

61623ABF0113/6162379091/61623CR017

 

All words are in the spp_search_word database but not in the spp_search_index database (only the first one 61623ABF0113), the fix is changing them too:

 

61623ABF0113 /6162379091 /61623CR017

Or

61623ABF0113, 6162379091, 61623CR017

 

It seems PrestaShop indexing doesn't like big words, that's the only explanation I have for this, it works now, that's what matters to me.

 

Edited December 27, 2021 by Black RL (see edit history)