Column not found: 1054 Unknown column 'at_visibility_default.value' #16471
Labels
Area: Catalog
Area: Product
Component: CatalogWidget
help wanted
Issue: Confirmed
Gate 3 Passed. Manual verification of the issue completed. Issue is confirmed
Priority: P2
A defect with this priority could have functionality issues which are not to expectations.
Progress: ready for dev
Reproduced on 2.2.x
The issue has been reproduced on latest 2.2 release
Reproduced on 2.3.x
The issue has been reproduced on latest 2.3 release
Reproduced on 2.4.x
The issue has been reproduced on latest 2.4-develop branch
Severity: S2
Major restrictions or short-term circumventions are required until a fix is available.
Triage: Dev.Experience
Issue related to Developer Experience and needs help with Triage to Confirm or Reject it
Projects
Preconditions
Steps to reproduce
Expected result
Actual result
SELECT DISTINCT COUNT(DISTINCT e.entity_id) FROM
catalog_product_entity
ASe
INNER JOIN
catalog_category_product_index_store1
AScat_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='2'INNER JOIN
catalog_product_index_price
ASprice_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
, 0) IN (SELECTcatalog_category_product
.product_id
FROMcatalog_category_product
WHERE (category_id IN ('3')))) AND(IFNULL(e
.entity_id
,at_visibility_default
.value
) IN ('5', '6', '20', '21', '22', '23', '26', '33', '34', '35', '36', '37', '56', '57', '59', '60', '62', '63', '64', '65', '87', '109', '117', '136', '143', '150', '151', '152', '153', '155', '156', '157', '158', '159', '185')) ))The text was updated successfully, but these errors were encountered: