0

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. – Dhaduk Mitesh Mar 30 '18 at 11:00
  • Yes I have also checked in database before posting, can you please help me for resolving thins issue. – bansal kapil Mar 30 '18 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. – Dhaduk Mitesh Mar 30 '18 at 11:08
1

Please set product attribute category_ids to searchable No.

I hope this will help you.

|improve this answer|||||
  • It is working now or not. @bansal – Dhaduk Mitesh Mar 31 '18 at 4:06
  • Yes it's working fine – bansal kapil Mar 31 '18 at 12:19
  • I have already post my answer – bansal kapil Mar 31 '18 at 12:20
0

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

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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