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 FROM catalog_product_entity AS e INNER JOIN catalog_product_website AS website ON website.product_id = e.entity_id AND website.website_id = '1' WHERE (e.entity_id > 0) ORDER BY e.entity_id ASC LIMIT 100

Does anyone have the solution for this? Thanks in Advance.

  • Please see, category_ids is not in catalog_product_entity. Commented Mar 30, 2018 at 11:00
  • Yes I have also checked in database before posting, can you please help me for resolving thins issue. Commented Mar 30, 2018 at 11:03
  • First, execute php bin/magento indexer:reset. After that execute php bin/magento indexer:reindex. I hope this is work for you. Commented Mar 30, 2018 at 11:08

2 Answers 2


Please set product attribute category_ids to searchable No.

I hope this will help you.

  • It is working now or not. @bansal Commented Mar 31, 2018 at 4:06
  • Yes it's working fine Commented Mar 31, 2018 at 12:19
  • I have already post my answer Commented Mar 31, 2018 at 12:20

I have resolve my issue at my end. I make category_ids product attribute searchable no. It's work for me.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.