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

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!