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
Feedback sent
We appreciate your effort and will try to fix the article