- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2018
12:39 PM
08-08-2018
12:39 PM
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')) )) [] []
Labels:
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-31-2018
02:47 PM
08-31-2018
02:47 PM
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?