2.4.5 Upgrade Issue: eav_attribute doesn't exist

[keithfrogs8405]

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!

[keithfrogs8405]

Forgot to mention it’s running on php 7.4

[kqt377]

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

[kqt377]

Finally found this on Github. It is a known issue.

Magento 245 - Elasticsearch error caused by prefix-table · Issue #35970 · magento/magento2 · GitHub

[kqt377]

The fix by mitaldeveloper at gitub post above worked for me.