- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: 2.4.5 Upgrade Issue: eav_attribute doesn't exist
Forgot to mention it’s running on php 7.4
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: 2.4.5 Upgrade Issue: eav_attribute doesn't exist
Finally found this on Github. It is a known issue.
Magento 245 - Elasticsearch error caused by prefix-table · Issue #35970 · magento/magento2 · GitHub
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: 2.4.5 Upgrade Issue: eav_attribute doesn't exist
The fix by mitaldeveloper at gitub post above worked for me.