cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade from 2.2 to 2.5 Brings unknown column error

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?