cancel
Showing results for 
Search instead for 
Did you mean: 

SQLSTATE[42S02] error in Magento 2.1.7

SQLSTATE[42S02] error in Magento 2.1.7

I receive the follow error: 

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'public.catalogsearch_fulltext_cl' doesn't exist, query was: UPDATE `catalog_product_entity` SET `attribute_set_id` = ?, `type_id` = ?, `sku` = ?, `has_options` = ?, `required_options` = ?, `search_weight` = ? WHERE (entity_id = '1239')

 

Can anybody tell me what is wrong. Please in simple english language as I'm not a technical person.

 

Thanks

JW

2 REPLIES 2

Re: SQLSTATE[42S02] error in Magento 2.1.7

Hi @AWFF,

 

That error message means that the databse table catalogsearch_fulltext_cl (used by Magento) doesn't exists into your database.

I guess this thread will help you to understand a little bit more about those tables (if you want to understand why those tables exists): https://magento.stackexchange.com/questions/164315/magento-2-tables-being-created-ending-in-cl

 

Where did you get the error? I mean, which action where you executing?

Re: SQLSTATE[42S02] error in Magento 2.1.7

Thanks for your reply. I changed products from zero stock to 2 in stock.

The following items in index management are also red:

Category products: processing

Product price: processing

Product EAV: processing

Catalog Rule product: reindex required

Update by schedule doesn't work for these items.

 

Regards

Jeanette