Skip to main content
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user

What is the solution to be able to search Magento 2 catalog with less than three characters.

This

This is what i have done so far from looking at Magento 1 info regarding this issue.

Setting "Max

Setting "Max Query Lengt"Lengt" in backend to 2
Changed2<br>
Changed the mysql setting ft_min_word_len=2 and restarted the server. reindex
reindex and clear cache.

I

I have also tried to move the following indexing tables to MyISAM and then run a REPAIR QUICK on them and update the indexes

catalogsearch_fulltext_scope1
cms_block
cms_page
customer_grid_flat
sales_creditmemo_grid
sales_invoice_grid
sales_order_grid
sales_shipment_grid
catalogsearch_fulltext

Theindexes

 catalogsearch_fulltext_scope1
 cms_block
 cms_page
 customer_grid_flat
 sales_creditmemo_grid
 sales_invoice_grid
 sales_order_grid
 sales_shipment_grid
 catalogsearch_fulltext

The tricky thing with this is that bin/magento indexer:reindex changes them back to InnoBD. Don'tDon't know if they are dropped and recreated or how that happens but that'sthat's my result after a magento reindex.
The<br>
The enginge change, repair, flushing and so on is done after magento reindex.

If

If anyone have an idea where to go from here i would be quite happy?

Thanks

Thanks in advance
Thomasadvance<br>
Thomas

What is the solution to be able to search Magento 2 catalog with less than three characters.

This is what i have done so far from looking at Magento 1 info regarding this issue.

Setting "Max Query Lengt" in backend to 2
Changed the mysql setting ft_min_word_len=2 and restarted the server. reindex and clear cache.

I have also tried to move the following indexing tables to MyISAM and then run a REPAIR QUICK on them and update the indexes

catalogsearch_fulltext_scope1
cms_block
cms_page
customer_grid_flat
sales_creditmemo_grid
sales_invoice_grid
sales_order_grid
sales_shipment_grid
catalogsearch_fulltext

The tricky thing with this is that bin/magento indexer:reindex changes them back to InnoBD. Don't know if they are dropped and recreated or how that happens but that's my result after a magento reindex.
The enginge change, repair, flushing and so on is done after magento reindex.

If anyone have an idea where to go from here i would be quite happy?

Thanks in advance
Thomas

What is the solution to be able to search Magento 2 catalog with less than three characters.

This is what i have done so far from looking at Magento 1 info regarding this issue.

Setting "Max Query Lengt" in backend to 2<br>
Changed the mysql setting ft_min_word_len=2 and restarted the server.
reindex and clear cache.

I have also tried to move the following indexing tables to MyISAM and then run a REPAIR QUICK on them and update the indexes

 catalogsearch_fulltext_scope1
 cms_block
 cms_page
 customer_grid_flat
 sales_creditmemo_grid
 sales_invoice_grid
 sales_order_grid
 sales_shipment_grid
 catalogsearch_fulltext

The tricky thing with this is that bin/magento indexer:reindex changes them back to InnoBD. Don't know if they are dropped and recreated or how that happens but that's my result after a magento reindex.<br>
The enginge change, repair, flushing and so on is done after magento reindex.

If anyone have an idea where to go from here i would be quite happy?

Thanks in advance<br>
Thomas

Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Tweeted twitter.com/StackMagento/status/1351001520200945667
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Source Link
TNordkvist
  • 425
  • 4
  • 17

Search catalog with less than 3 characters

What is the solution to be able to search Magento 2 catalog with less than three characters.

This is what i have done so far from looking at Magento 1 info regarding this issue.

Setting "Max Query Lengt" in backend to 2
Changed the mysql setting ft_min_word_len=2 and restarted the server. reindex and clear cache.

I have also tried to move the following indexing tables to MyISAM and then run a REPAIR QUICK on them and update the indexes

catalogsearch_fulltext_scope1
cms_block
cms_page
customer_grid_flat
sales_creditmemo_grid
sales_invoice_grid
sales_order_grid
sales_shipment_grid
catalogsearch_fulltext

The tricky thing with this is that bin/magento indexer:reindex changes them back to InnoBD. Don't know if they are dropped and recreated or how that happens but that's my result after a magento reindex.
The enginge change, repair, flushing and so on is done after magento reindex.

If anyone have an idea where to go from here i would be quite happy?

Thanks in advance
Thomas