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

Created by Aiden Hua, Modified on Fri, 02 Jun 2023 at 10:00 AM by Aiden Hua

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

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article