M2.4.5 EE, v1.4.0: Fix the incompatibility with Magento Enterprise Edition

Created by Esther Nguyen, Modified on Wed, 01 Mar 2023 at 03:21 PM by Esther Nguyen

ISSUE:

We have purchased the bsscommerce/simple-detail-configurable extension of the enterprise edition. After installing the extension in a new fresh Magento , we are facing issues while applying the visibility filter on the product grid at admin. 


After that, we have also checked the log file. There is an error related to this module.

 

Next Zend_Db_Statement_Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sdcp_only_display_product_page.entity_id' in 'on clause', query was: SELECT `e`.*, `sdcp_only_display_product_page`.`value` AS `sdcp_only_display_product_page_value`, `at_visibility`.`value` AS `visibility`, `at_qty`.`qty` FROM `catalog_product_entity` AS `e`

 LEFT JOIN `catalog_product_entity_int` AS `sdcp_only_display_product_page` ON (`sdcp_only_display_product_page`.`entity_id` = `e`.`entity_id`)

                     AND (`sdcp_only_display_product_page`.`attribute_id` = 202)

                      AND (`sdcp_only_display_product_page`.`store_id` = 0

 LEFT JOIN `catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`row_id` = `e`.`row_id`) AND (`at_visibility`.`attribute_id` = '99') AND (`at_visibility`.`store_id` = 0)

 LEFT JOIN `cataloginventory_stock_item` AS `at_qty` ON (at_qty.`product_id`=e.entity_id) AND (at_qty.stock_id=1) WHERE ((sdcp_only_display_product_page.value IS NULL OR sdcp_only_display_product_page.value = 0) AND (at_visibility.value = '4')) AND (e.created_in <= '1671557429') AND (e.updated_in > '1671557429') ORDER BY `e`.`entity_id` DESC

 LIMIT 20 in /var/www/html/magento245/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:109



SOLUTION:

Unfortunately, our module has not worked properly with Magento Enterprise Edition


To resolve the issue, please edit the following files:

app/code/Bss/Simpledetailconfigurable/Helper/ModuleConfig.php

app/code/Bss/Simpledetailconfigurable/Plugin/Ui/DataProvider/AbstractDataProvider.php


If you need any further assistance, please feel free to contact us. We'd be happy to support you!

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article