[v1.0.6] How to fix incompatible issue with M2.4.3 EE?

Issue: 

We are using the module on M2.4.3 EE. When adding to the cart, we face the issue 

[2022-02-14 02:51:43] report.CRITICAL: Exception message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'salesrule_website.rule_id' in 'field list', query was: SELECT `main_table`.*, NULL AS `code` FROM `salesrule` AS `main_table`
 INNER JOIN (SELECT DISTINCT  `salesrule_website`.`rule_id` FROM `salesrule_website` WHERE (website_id IN (2))) AS `website` ON main_table.rule_id = website.rule_id ...

Solution:

The current version 1.0.6 is not compatible with M2.4.3 EE at this time.

To solve this issue, we have changed the file app/code/Bss/ShoppingCartRulePerStoreView/Model/ResourceModel/Rule/Collection.php

Please apply this hot-fix to your site and flush the cache.

If you have any issues, please feel free to contact us.

We'd like to help.

Get to know us: 

BSS Commerce is a full-service ecommerce agency with 14+ years of experience, supporting 75,000+ customers worldwide. As an Adobe Commerce Solution Bronze Partner and Select Magento Extensions Builder, we deliver trusted end-to-end solutions.

Our core strength is Magento, with 150+ extensions designed to enhance store performance and drive growth. With deep expertise from years of working on Magento websites, we deliver scalable, high-impact solutions backed by strong client trust.

Explore our most powerful extensions:

• Magento 2 B2B Extension by BSS Commerce enhances B2B performance with streamlined workflows and tailored pricing strategies.
• Magento 2 SEO Extension by BSS Commerce improves rankings and maximizes organic growth through advanced SEO automation.