Hello,
I'm having an issue when updating from 2.4.4 to 2.4.5. Base install w/o any extensions other than Yotpo enabled. Home page opens fine, as do categories that do not contain products. When selecting a product page it throws an exception:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'frogsnth_dev_wvza1.eav_attribute' doesn't exist in /home/frogsnth/dev.frogsnthings.com/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:90
Next Zend_Db_Statement_Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'frogsnth_dev_wvza1.eav_attribute' doesn't exist, query was: SELECT `e`.`entity_id`, `stockItem`.`stock_status` AS `is_salable`, `cat_index`.`position`, `product_var`.`value` AS `name` FROM `####_catalog_product_entity` AS `e` INNER JOIN `####_cataloginventory_stock_status` AS `stockItem` ON stockItem.product_id = e.entity_id AND stockItem.website_id = 0 AND stockItem.stock_id = 1 INNER JOIN `####_catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id = e.entity_id AND cat_index.category_id = 5 AND cat_index.store_id = 1 LEFT JOIN `####_catalog_product_entity_varchar` AS `product_var` ON product_var.entity_id = e.entity_id AND product_var.attribute_id = (SELECT attribute_id FROM eav_attribute WHERE entity_type_id=4 AND attribute_code='name') ORDER BY is_salable DESC, name ASC, entity_id DESC LIMIT 30 in /home/frogsnth/dev.frogsnthings.com/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:109
and so on.....
The '####_eav_attribute' table exists (I relaced the actual prefix with #### for this post). I noticed the queries above do not contain the prefix for eav_attribute. Not sure if that is an issue.
I'd appreciate your suggestions on how to resolve,
Thanks!
Forgot to mention it’s running on php 7.4
Linking to my correct Adobe ID (Posted from wrong account, sorry). I would appreciate any suggestions for this. Been searching to no avail. Thanks! Keith
Finally found this on Github. It is a known issue.
Magento 245 - Elasticsearch error caused by prefix-table · Issue #35970 · magento/magento2 · GitHub
The fix by mitaldeveloper at gitub post above worked for me.