Column not found: 1054 Unknown column 'at_visibility_default.value'

[sandervall]

Preconditions

1. Magento 2.2.5 Community
2. PHP 7.2
3. Enable developer mode(bin/magento deploy:mode:set developer).
4. Rename magento_root_dir/pub/errors/local.xml.sample to magento_root_dir/pub/errors/local.xml

Steps to reproduce

1. Navigate to admin area Catalog > Products.
2. Create simple product SKU = 'simple', price = '3', quantity = '100', visibility = 'Catalog, Search'. Categories = 'cat1'(subcategory of default category).
3. Create Products List widget with criteria "Visibility is Catalog, Search".
4. Add widget to Main CMS page.
5. Navigate to storefront home page.

Expected result

1. The widget should display only products with visibility Catalog, Search

Actual result

1. Error
2. Generated SQL in plain text for debugging 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='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(e.entity_id, 0) IN (SELECT catalog_category_product.product_id FROM catalog_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')) ))

[magento-engcom-team]

Hi @sandervall. Thank you for your report. To help us process this issue please make sure that you provided the following information:

• [ ] Summary of the issue
• [ ] Information on your environment
• [ ] Steps to reproduce
• [ ] Expected and actual results

Please make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce. To deploy vanilla Magento instance on our environment, please, add a comment to the issue:

@magento-engcom-team give me {$VERSION} instance

where {$VERSION} is version tags (starting from 2.2.0+) or develop branches (2.2-develop +). For more details, please, review the Magento Contributor Assistant documentation.

@sandervall do you confirm that you was able to reproduce the issue on vanilla Magento instance following steps to reproduce?

• [ ] yes
• [ ] no

[engcom-backlog-nickolas]

Hello @sandervall, thank you for your report. We've acknowledged the issue and added to our backlog.

[cjj25]

This is a quick fix that worked for me: https://github.com/magento/magento2/issues/13881

[bonsoni]

We are having the similar issue

[github-jira-sync-bot]

:white_check_mark: Jira issue https://jira.corp.magento.com/browse/AC-1037 is successfully created for this GitHub issue.

[m2-assistant[bot]]

:white_check_mark: Confirmed by @engcom-Echo. Thank you for verifying the issue.
Issue Available: @engcom-Echo, You will be automatically unassigned. Contributors/Maintainers can claim this issue to continue. To reclaim and continue work, reassign the ticket to yourself.

[engcom-Bravo]

Hi @sandervall,

Thanks for your reporting and collaboration.

we have verified the issue in Latest 2.4-develop instance and the issue is no more reproducible.Kindly refer the screenshots.

Widget displaying products with visibility Catalog, Search

Hence we are closing this issue.

Thanks.