cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade from 2.2 to 2.5 Brings unknown column error

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Upgrade from 2.2 to 2.5 Brings unknown column error

I Get the error below in my system.log after upgrading from 2.2 to 2.5  Before I restore from backup does anyone have any ideas how to approach this?  

 

This error only occurs when I try to display featured products.  


I search has found similar issues but nothing close enough for me to figure out a fix

 

[2018-08-08 17:51:12] main.CRITICAL: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'at_featured_default.value' in 'where clause', query was: SELECT DISTINCT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='3'
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 WHERE (((IFNULL(`e`.`entity_id`, `at_featured_default`.`value`) IN ('1029', '2170', '6441', '1478', '2177', '870', '2175', '6560', '6870', '6091')) )) [] []

 

 

 

1 REPLY 1

Re: Upgrade from 2.2 to 2.5 Brings unknown column error

I have the same problem after upgrading to 2.2.5.   It appears to be directly related to conditions set on widgets.  Have you found any solutions since posting?