issue with index building and search

[devhero-tech]

Hi, after instal and few tries of reindex on search. It looks like reindex can't create tables. Reindexing on 2000 products takes less than 1s ;)
I've got error like this:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento.catalogsearch_fulltext_scope1' doesn't exist, query was: INSERT INTOsearch_tmp_632cc6ff9ef500_89290962SELECTmain_select.entity_id, SUM(score) AS relevanceFROM (SELECT DISTINCT eav_index.entity_id, (((0)) * 1 + LEAST((MATCH (data_index) AGAINST ('age*' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS scoreFROMcatalog_product_index_eavASeav_indexINNER JOINcatalogsearch_fulltext_scope1ASsearch_indexON eav_index.entity_id = search_index.entity_id INNER JOINcatalog_eav_attributeASceaON search_index.attribute_id = cea.attribute_id INNER JOINcataloginventory_stock_statusASstock_indexON stock_index.product_id = eav_index.entity_id ANDstock_index.website_id= 0 ANDstock_index.stock_status= 1 ANDstock_index.stock_id = 1 WHERE (eav_index.store_id = '1') AND (eav_index.attribute_id= 99 ANDeav_index.valuein ('3', '4') ANDeav_index.store_id= '1') AND (MATCH (data_index) AGAINST ('age*' IN BOOLEAN MODE))) ASmain_selectGROUP BYentity_idException #1 (Zend_Db_Statement_Exception): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento.catalogsearch_fulltext_scope1' doesn't exist, query was: INSERT INTOsearch_tmp_632cc6ff9ef500_89290962SELECTmain_select.entity_id, SUM(score) AS relevanceFROM (SELECT DISTINCT eav_index.entity_id, (((0)) * 1 + LEAST((MATCH (data_index) AGAINST ('age*' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS scoreFROMcatalog_product_index_eavASeav_indexINNER JOINcatalogsearch_fulltext_scope1ASsearch_indexON eav_index.entity_id = search_index.entity_id INNER JOINcatalog_eav_attributeASceaON search_index.attribute_id = cea.attribute_id INNER JOINcataloginventory_stock_statusASstock_indexON stock_index.product_id = eav_index.entity_id ANDstock_index.website_id= 0 ANDstock_index.stock_status= 1 ANDstock_index.stock_id = 1 WHERE (eav_index.store_id = '1') AND (eav_index.attribute_id= 99 ANDeav_index.valuein ('3', '4') ANDeav_index.store_id= '1') AND (MATCH (data_index) AGAINST ('age*' IN BOOLEAN MODE))) ASmain_selectGROUP BYentity_id Exception #2 (PDOException): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento.catalogsearch_fulltext_scope1' doesn't exist

[0m3r]

what is your Magento version?
what are the config options?

bin/magento config:show catalog/search/enable_eav_indexer 
bin/magento config:show catalog/search/engine             

I've got an error like this:

Where is your get/find the error?
at some log file(s), frontend, indexing processes, etc.

[0m3r]

related #9

[0m3r]

Possible solution

magento/magento2#26520
https://github.com/magento/magento2/pull/26803/files

[0m3r]

try this release

https://github.com/swissup/module-search-mysql-legacy/releases/tag/1.1.4

composer update swissup/module-search-mysql-legacy

p.s. If doesn't help reopen the issue and give me more information plz