Showing posts from August, 2011

Integrity constraint violation when enabling/disabling Magento modules

Once i had one task which gave following error when enabled/disabled any module (System >> Configuration >> Advanced)

Exception message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'default-0-advanced/modules_disable_output/_' for key 'config_scope'

First i think it may be because of dublicate entry of that module; so i was checked in "core_config_data", but i found nothing over there... there is no entry of that module in "core_config_data" table.

So i execute the following query into mysql browser:

INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', 0, 'advanced/modules_disable_output/Companyname_Modulename', 0);

but it still through that error. then i checked into "config.xml" file of that module and what i found:

There is problem of naming conversion. it is

<modules> <<companyname>_<modulename>> …