Magento Module that finds redundant entries in mysql table core_config_data.
If you have different config settings for default, website or store scope in Magento backend, maybe after some time you will end up in having obsolete and redundant settings for website and store scope that have the same value as the default scope. This module finds the duplicate entries and adds the ability to remove them through a cronjob or a script.
This module could be useful to improve data quality in table core_config_data when you are monitoring your Magento instances (test, dev, prod) through an external tool.
- Install the extension via GitHub, Composer, modman or a similar method. The extension is listed on packages.firegento.com.
- Clear the cache, logout from the admin panel and then login again.
- Enable/Disable automatic deletion of obsolete settings under System > Configuration > Developer > JH_RemoveRedundantConfig Settings.
- First, test which entries are obsolete with the php script under shell directory in your magento directory:
cd shell
php redundant_settings.php --action findSettings
The command lists all paths and config_ids which are redundant. If the output is correct, you can enable the cronjob (runs once per hour) under System -> Configuration > Developer > JH_RemoveRedundantConfig Settings or run the command:
cd shell
php redundant_settings.php --action removeSettings
In the log file var/log/removed_obsolete_config_ids.log, you can find all config_id values that were removed by the module.
Feel free to make a pull request when you have ideas for improving. Further improvement could be an extended log file were the whole entry that was removed is stored, not only the config_id.
- Fia FTP: Remove all extension files from your Magento installation
- Via modman:
modman remove JH_RemoveRedundantConfig - Via composer, remove the line of your composer.json related to
jh_removeredundantconfig - Optional: Remove entry with path "dev/jh_removeredundantconfig/status" from table core_config_data