
Overview
Back to topMigrating from Magento 1 to its modern counterpart Magento 2 might not be flawless and is highly dependent on the M1 setup. And you realize something is not right when a migrated Magento 2 fills the var/log/system.log file with an endless number of rows containing the same error: main.WARNING: Attempt to load value of nonexistent EAV attribute '94' for entity type 'Magento\Catalog\Api\Data\ProductInterface'. Instead of 94, you could see any other ID.
We, at SafeMage, have looked into the issue and found the cause for it. Various values in the EAV tables contain redundant data, in particular, 'null'.
The extension provides risk-free optimization of the EAV tables of all entity types (custom ones included) and clean-up for system.log. Upon successful optimization, the EAV tables will include fewer records (down to 5-10%). We have thoroughly tested and can guarantee the post-optimization integrity and working capacity of a Magento environment.
It is important to mention that regular processes that happen all the time in Magento, e.g., saving categories, products, and other entity types, are the reason why new 'null' values appear in the EAV tables. It is the case when non-required fields are empty. For that reason, we recommend optimizing the EAV tables regularly. The module makes it easy to maintain EAV tables and conduct clean-ups by providing three optimization options. You, as an admin user, can choose between a one-time manual or automatic clean-up solutions. The latter includes scheduled optimization relying on a cron job and optimization run on the fly. If you decide to enable scheduled clean-ups, monthly terms are recommended.
Features
- Fixes errors in system.log: Attempt to load value of nonexistent EAV attribute 'N' for entity type 'Magento\Catalog\Api\Data\ProductInterface'
- Safely removes useless data from EAV tables and makes them smaller in size
- Monitors and controls unwanted data in attribute tables with the help of scheduled and on-the-fly post-optimization options
- A nice bonus of a website's subtle performance increase
- Maintain EAV tables and conduct clean-ups
- Choose between a one-time manual or automatic clean-up solution
Demo
Technical Specifications
Back to topSeller profile
Seller contact
Current Version
2.0.5
Adobe Commerce platform compatibility
Open Source (CE): 2.4 (current), 2.2 (obsolete), 2.3 (obsolete)
Type
Stable Build
Updated
07 July, 2022
Categories
Extensions, Site Optimization, Site Monitoring, Performance
Quality Report
Back to topAll tests were conducted on the latest versions of Adobe Commerce that existed for the compatible release lines at the moment of the extension submission. Latest versions of all other software were used, as applicable.
Release Notes
Back to top2.0.5:
- Compatible with Open Source (CE) : 2.2 2.3 2.4
- Stability: Stable Build
-
Description:
• Support for Magento 2.4.4 and PHP 8.1.
2.0.4:
- Compatible with Open Source (CE) : 2.2 2.3 2.4
- Stability: Stable Build
-
Description:
• Minor code refactoring.
2.0.3:
- Compatible with Open Source (CE) : 2.2 2.3 2.4
- Stability: Stable Build
-
Description:
• Added support for 2.4.0.
2.0.1:
- Compatible with Open Source (CE) : 2.2 2.3
- Stability: Stable Build
-
Description:
• Improved logging.
Support
Back to topThe best place to start if you need help with a specific extension is to contact the developer. All Adobe Commerce developers have both a contact email and a support email listed.
Contact Vendor