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
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article