1

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.

Improve this question
3
  • Please see, category_ids is not in catalog_product_entity.
    – Dhaduk Mitesh
    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.
    – bansal kapil
    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.
    – Dhaduk Mitesh
    Commented Mar 30, 2018 at 11:08

2 Answers 2

Reset to default
3

Please set product attribute category_ids to searchable No.

I hope this will help you.

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

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

Improve this answer
0

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.