Skip to content

Catalog Products List widget is not displayed on Storefront #12717

Closed
@alena-marchenko

Description

@alena-marchenko

Preconditions

  1. Magento is installed from 2.2-develop branch

Steps to reproduce

  1. Go to Stores > Attributes > Product and open "Color" attribute
  2. Create 2 options red and black
  3. Add this attribute to attribute set
  4. Create 2 simple products with red and black attributes
  5. Go to Stores> Configuration > CATALOG > Catalog > Storefront
  6. Set "Use Flat Catalog Category" = Yes and "Use Flat Catalog Product" = "Yes"
  7. Go to Content > Widgets and create new widget with:
    Storefront Properties
  • Widget Title = Test widget
  • Assign to Store Views = All Store Views
  • Layout Updates:
    -- Display on = All Pages
    -- Container = Main Content Area

Widget Options

  • Title = test
  • Number of Products to Display = 10
  • Conditions: Color is red
  1. run
    rm -rf var/* pub/static/* generated/*
    php bin/magento indexer:reindex
    php bin/magento setup:static-content:deploy
  2. Go to Storefront

Expected result

Widget is visible on Storefront

Actual result

Widget is not visible on Storefront, following error persists in support_report.log:
report.CRITICAL: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'at_color.value' in 'where clause', query was: SELECT COUNT(DISTINCT e.entity_id) FROM catalog_product_flat_1 AS e
INNER JOIN catalog_category_product_index 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='2'
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(at_color.value, 0) = '13') ))

Metadata

Metadata

Assignees

No one assigned

    Labels

    Component: CatalogFixed in 2.3.xThe issue has been fixed in 2.3 release lineIssue: Clear DescriptionGate 2 Passed. Manual verification of the issue description passedIssue: ConfirmedGate 3 Passed. Manual verification of the issue completed. Issue is confirmedIssue: Format is validGate 1 Passed. Automatic verification of issue format passedReproduced on 2.2.xThe issue has been reproduced on latest 2.2 release

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions