M2.4.4(EE), v1.0.1: How to fix error SQLSTATE[42S22]: Column not found: 1054 Unknown column in EE site?

ISSUE:

We are getting this below error and as we know entity_id column does not exist on the enterprise version.

Please advise as soon as possible. Thank you!

Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'categoryEntity.entity_id' in 'field list', query was: SELECT `e`.`entity_id`, IF(`categoryEntityCurrent`.`value`, `categoryEntityCurrent`.`value`, `categoryEntity`.`value`) AS `name`, `categoryEntity`.`entity_id`, `categoryEntityCurrent`.`attribute_id` FROM `catalog_category_entity` AS `e`

LEFT JOIN `catalog_category_entity_varchar` AS `categoryEntity` ON e.entity_id = categoryEntity.entity_id AND categoryEntity.store_id = 0

LEFT JOIN `catalog_category_entity_varchar` AS `categoryEntityCurrent` ON e.entity_id = categoryEntityCurrent.entity_id AND categoryEntityCurrent.store_id =1 WHERE ((e.entity_id in (41456,41632,40148)) AND (categoryEntity.attribute_id = 45)) AND (e.created_in <= '1') AND (e.updated_in > '1')

SOLUTION:

This issue is due to the incompatibility of the module with the M2.4.4 Enterprise version.

To resolve the issue, please edit the file:

app/code/Bss/GA4/Helper/Data.php

app/code/Bss/GA4/Model/DataItem.php

Please download the files attached below to add and override the current file on your site

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.