ACSD-53925: Cannot save CMS block with Product Carousel

The ACSD-53925 patch fixes the issue where the admin is unable to save a CMS block with Product Carousel when dimensions mode for catalog_product_price is set to website. This patch is available when the Quality Patches Tool (QPT) 1.1.43 is installed. The patch ID is ACSD-53925. Please note that the issue is scheduled to be fixed in Adobe Commerce 2.4.7.

Affected products and versions

The patch is created for Adobe Commerce version:

  • Adobe Commerce (all deployment methods) 2.4.5-p3

Compatible with Adobe Commerce versions:

  • Adobe Commerce (all deployment methods) 2.4.2 - 2.4.6-p3
NOTE
The patch might become applicable to other versions with new Quality Patches Tool releases. To check if the patch is compatible with your Adobe Commerce version, update the magento/quality-patches package to the latest version and check the compatibility on the Quality Patches Tool: Search for patches page. Use the patch ID as a search keyword to locate the patch.

Issue

Admin is unable to save a CMS block with Product Carousel when dimensions mode for catalog_product_price is set to website.

Steps to reproduce:

  1. Create two simple products:

    • simple1 - $10
    • simple2 - $20
  2. Create a bundle product ‘bundle1-dyn’ with two options based on simple product SKUs.

  3. Set dimensions mode for the product price indexer:

    bin/magento indexer:set-dimensions-mode catalog_product_price website

  4. Go to Content > Blocks, and create a new CMS block.

  5. Edit the content using Page Builder:

    • Add a Row element
    • Add a Products element
    • Select Product Carousel
    • Enter product SKU - bundle1-dyn
  6. Save the CMS block.

Expected results:

User is able to add a product carousel without errors.

Actual results:

  • A message is thrown in the UI: We’re sorry, an error has occurred while generating this content

  • var/log/exception.log contains the following error:

    code language-none
    [2023-08-18T20:58:14.533374+00:00] report.CRITICAL: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'username_dev.catalog_product_index_price_ws0' doesn't exist in /test/lib/internal/Magento/Framework/DB/Statement/Pdo/Mysql.php:90
    

Apply the patch

To apply individual patches, use the following links depending on your deployment method:

To learn more about Quality Patches Tool, refer to:

For info about other patches available in QPT, refer to Quality Patches Tool: Search for patches in the Quality Patches Tool guide.

recommendation-more-help
c2d96e17-5179-455c-ad3a-e1697bb4e8c3