cancel
Showing results for 
Search instead for 
Did you mean: 

Error on Search

SOLVED

Error on Search

When I try to search for anything on my website it gives me:

 

"There has been an error processing your request

Exception printing is disabled by default for security reasons.

Error log record number: 745d6763d5596a728af4eb3ef2c89335933308a98f368a3679be5a01d95909ce"

 

How can I fix it?

Please advise. Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Error on Search

Hi @paulph227g84cf ,

 

Please run the command as suggested by @shikha1193 . 

Also please cross-check while reindexing you will not get any error.

 

Thanks!

 

Problem Solved! Click Kudos & Accept as Solution!

View solution in original post

5 REPLIES 5

Re: Error on Search

Hi @paulph227g84cf ,

 

Can you please switch to developer mode using below command. 

php bin/magento deploy:mode:set developer

Through this we will be able to get the exact error on the screen. 

 

Thanks!

Problem solved! Click kudos & Accept as solution. 

Re: Error on Search

Thanks for reply. I switched to developer's mode. That's is what I got:

2 exception(s):
Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento2.catalogsearch_fulltext_scope1' doesn't exist, query was: INSERT INTO `search_tmp_5eb592164ff260_69624311` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT  `eav_index`.`entity_id`, (((0)) * 1 + LEAST((MATCH (data_index) AGAINST ('test*' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `catalog_product_index_eav` AS `eav_index`
 INNER JOIN `catalogsearch_fulltext_scope1` AS `search_index` ON eav_index.entity_id = search_index.entity_id
 INNER JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id
 INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = eav_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_status` = 1 AND `stock_index`.`stock_id` = 1 WHERE (eav_index.store_id = '1') AND (`eav_index`.`attribute_id` = 99 AND `eav_index`.`value` in ('3', '4') AND `eav_index`.`store_id` = '1') AND (MATCH (data_index) AGAINST ('test*' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC
 LIMIT 10000

Re: Error on Search

Hi @paulph227g84cf 
you can fix this issue by runing reindex command i.e

php bin/magento indexer:reindex

you can check this issue on gitHub

https://github.com/magento/magento2/issues/26520

If issue fixed click Kudos & Accept as Solution

 

Thanks

Re: Error on Search

Hi @paulph227g84cf ,

 

Please run the command as suggested by @shikha1193 . 

Also please cross-check while reindexing you will not get any error.

 

Thanks!

 

Problem Solved! Click Kudos & Accept as Solution!

Re: Error on Search

Thanks a lot!!!!