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

Created by Rosa Truong, Modified on Wed, 23 Feb 2022 at 03:07 PM by Rosa Truong


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 ...


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.

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