Catalog Search indexer process unknown error

Im getting the below error when i reinderx after the migration process.
Catalog Search indexer process unknown error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.media_gallery’ in ‘field list’, query was: SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`media_gallery`, `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
Please help out.

1 answer

Profile photo of Mall Staff 184060.00 $tone May 5, 2018
Public

Hi there,

Im getting the below error when i reinderx after the migration process.
Catalog Search indexer process unknown error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.media_gallery’ in ‘field list’, query was: SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`media_gallery`, `e`.`sku` FROM `catalog_product_entity` AS `e`

That is strange. Please answer my questions as followings:
What is version of your Magento2 instance?
Where did you download the Magento2 core?
And how did you install your Magento2 instance?
And provide me information about your instance as followings:
+ Admin credentials and back-end URL
+ SSH credentials and path to Magento2 folder.
I will help to check further and get back you soon.
Regards,
Mall.

#1

Please login or Register to Submit Answer

Written By

Comments