I am using magento 2.2.2. I am working on it last 3 months. But suddenly It giving me this error while I run command for re-indexing the site.
commend for re-indexing,
php bin/magento cache:clean;
php bin/magento cache:flush;
php bin/magento indexer:reindex;
Catalog Search indexer process unknown error,
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.category_ids' in 'field list', query was: SELECT
e
.entity_id
,e
.type_id
,e
.category_ids
,e
.sku
FROMcatalog_product_entity
ASe
INNER JOINcatalog_product_website
ASwebsite
ON website.product_id = e.entity_id AND website.website_id = '1' WHERE (e.entity_id > 0) ORDER BYe
.entity_id
ASC
LIMIT 100
Does anyone have the solution for this? Thanks in Advance.
Best Answer
Please set product attribute category_ids to searchable
No
.I hope this will help you.