cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 2.3.4: SQLSTATE[42S02]: Base table or view not found: 1146 Table

Magento 2.3.4: SQLSTATE[42S02]: Base table or view not found: 1146 Table

When I did a categories search in my website I got this error:

There has been an error processing your request

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'buygold_magen59.mg4s_catalogsearch_fulltext_scope1' doesn't exist, query was: INSERT INTO `mg4s_search_tmp_5e8be6de1f3a26_30241606` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT  `eav_index`.`entity_id`, (((0)) * 1 + LEAST((MATCH (data_index) AGAINST ('100g*' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `mg4s_catalog_product_index_eav` AS `eav_index`
 INNER JOIN `mg4s_catalogsearch_fulltext_scope1` AS `search_index` ON eav_index.entity_id = search_index.entity_id
 INNER JOIN `mg4s_catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id
 INNER JOIN `mg4s_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 ('100g*' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC, `entity_id` DESC
 LIMIT 10000

Error log record number: ed2909b8cf7eda67b02bf68b9ffddbc41a863368ed386337972c82b2bde3f139

When I login to my Magento 2.3.4 admin backend, I saw error at the top:

One or more indexers are invalid. Make sure your Magento cron job is running.

Appreciate your help on the resolution. I tried everything but just could not get it resolve. Hope the expert could assist on the resolution. Greatly appreciated. Thank you.

1 REPLY 1

Re: Magento 2.3.4: SQLSTATE[42S02]: Base table or view not found: 1146 Table

Hello @billychiam81 

 

I think this will help you:

https://magento.stackexchange.com/a/294395/24801

 

Be careful about the operations you carry out and take the backup before implementing.

 

I hope it helps you.

Problem solved? Click Kudos and "Accept as Solution".
200+ Magento 2 Extensions for Enhanced Shopping Experience.