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!