Elasticsearch: web search does not match robo search

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hello

7.11.8 not upgraded to 10 yet due to Admin Search panel bug. Elasticsearch 5.6, php 7.3.1 with apache 2 running on ubuntu 19.10.

Searching a keyword on web search box returns no results, the same keyword on “robo elastic:search” or curl returns the expected results.

Nothing in the logs. Tried rebuilding the index a thousand times, nothing. I cannot get my head around this.

Any suggestion more than welcome to isolate the issue.

Thanks

2

I don’t know the answer, but from a quick look I think you could trace what’s happening in this function call

https://github.com/salesagility/SuiteCRM/search?utf8=✓&q=sql_like_string&type=

since that might be adding a wildcard character and changing the search string before it is sent to Elastic…

There are a couple of values in config.php (or config_override.php) that control this:


search_wildcard_infront
search_wildcard_char

although someone has reported a bug: https://github.com/salesagility/SuiteCRM/issues/5648

3

Thank you, I will have a look. In the meantime I have restricted the issue.

Background, I have built two custom modules. I have noticed that

  1. if the search returns items from any of those modules, then the results page is empty.
  2. if the search DOES NOT return items from the custom modules, the result page is correctly populated

No errors in the logs as far as I can see. I will try standard and advanced search to understand if that has any impact on them.

Cheers
S

4

Ok. Consider opening a new issue reporting this, if you conclude it is a bug (as it seems).

https://github.com/salesagility/SuiteCRM/issues/

Search first, to see if it’s already there.

Thanks for reporting.