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!
Get to know BSS Commerce!!
BSS Commerce is a trusted Magento 2 extensions provider with 14+ years of experience, serving 75,000+ customers worldwide. We are an Adobe Commerce Solution Bronze Partner and a Select Magento Extensions Builder, reinforcing our expertise in the Magento ecosystem.
We specialize in developing 150+ high-quality Magento 2 extensions that enhance functionality, improve user experience, and support scalable growth. Our reputation is built on long-term partnerships, positive feedback, and proven performance-driven solutions.
Explore our extensions: https://bsscommerce.com/magento-2-extensions.html
For B2B businesses, our Magento B2B Extension by BSS Commerce is a flagship and widely adopted solution globally, offering advanced pricing, company account management, and streamlined workflows.
>>> If you care to enhance your store's visibility, don't miss out Magento SEO Extension by BSS Commerce
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