cancel
Showing results for 
Search instead for 
Did you mean: 

2.4.5 Upgrade Issue: eav_attribute doesn't exist

2.4.5 Upgrade Issue: eav_attribute doesn't exist

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!

4 REPLIES 4

Re: 2.4.5 Upgrade Issue: eav_attribute doesn't exist

Forgot to mention it’s running on php 7.4

Re: 2.4.5 Upgrade Issue: eav_attribute doesn't exist

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

Re: 2.4.5 Upgrade Issue: eav_attribute doesn't exist

Re: 2.4.5 Upgrade Issue: eav_attribute doesn't exist

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