M2.4.2 EE, v1.0.5: error when click on add item

Created by Esther Nguyen, Modified on Fri, 5 Nov, 2021 at 3:01 PM by Esther Nguyen

ISSUE:

When we click on add item, it gives the error:

Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'at_name.entity_id' in 'on clause', query was: SELECT `e`.*, `at_name`.`value` AS `name` FROM `catalog_product_entity` AS `e`

 LEFT JOIN `catalog_product_entity_varchar` AS `at_name` ON (at_name.`entity_id`=e.entity_id) AND (at_name.attribute_id = '73') AND (at_name.store_id = '0') WHERE (e.created_in <= 1) AND (e.updated_in > 1) ORDER BY `e`.`entity_id` ASC

 LIMIT 20


SOLUTION:

There is a conflict issue between our FAQs module and Magento Commerce version (2.4.2). 


To resolve the issue, please edit the file: app/code/Bss/Faqs/Block/Adminhtml/Grid/Assign/Table/Product.php as below:


If you need any further assistance, please feel free to contact us. We'd be happy to support you!

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 at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article