ACSD-63574: When adding Bundle Product to a block using Page Builder…

Categories

Content, Admin

Components

magento/module-bundle

Origin

adobe-commerce-support

Since QPT

1.1.59

Issue

When adding Bundle Product to a block using Page Builder, the product widget preview breaks and shows the error message We're sorry, an error has occurred while generating this content. This issue occurs specifically when the bundle product includes Checkbox or Multi Select option types and indexer dimension mode is set to website_and_customer_group. The exception log shows the following error: report.CRITICAL: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db_name.catalog_product_index_price_cg0_ws0' doesn't exist in /home/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:90

Steps to reproduce

1. Go to Stores > Settings > Configuration. 1. In the left panel, expand Catalog and select Catalog from the options below. 1. Scroll down to the Price section and set Catalog Price Scope to Global. 1. Set Indexer dimension mode to website_and_customer_group using below command: bin/magento indexer:set-dimensions-mode catalog_product_price website_and_customer_group 1. Create a Bundle Product with a bundle option type Checkbox or Multi Select, and assign the product to a category. 1. Go to Content > Blocks > Edit Content with Page Builder. 1. Select the category to which the created product is assigned and try to Save.

Adobe's page lists 2.4.4 - 2.4.4-p11 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.

Adobe scheduled the permanent fix for 2.4.8.

Install

Install the Quality Patches Tool with composer require magento/quality-patches, apply the prerequisites listed for all files applicable to your distribution and version first, then run vendor/bin/magento-patches apply ACSD-63574. On Cloud, add ACSD-63574 under stage.build.QUALITY_PATCHES in .magento.env.yaml.

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACSD-63574/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Bundle prerequisites the same way and list them first. Paths are relative to each package root, using the default -p1 level. Prefer local files when configuring composer-patches; a remote URL can change.

Patch files and compatible versions

Sources

• Adobe documentation for ACSD-63574
• JSON API: /api/v1/patches/ACSD-63574