"SEO Layered Navigation Plus" ir "Shop By Brand Attribute Splash Pages" Database Reset Script
Sometimes when installing extension Shop By Brand Attribute Splash Pages having SEO Layered Navigation Plus extension already installed, installation error can be raised.
Error can be fixed by running the script, provided below:
DELETE FROM `m_option_page_store`;
DELETE FROM `m_attribute_page_store`;
DROP TABLE IF EXISTS `m_seo_url_history`;
DROP TABLE IF EXISTS `m_seo_url`;
DROP TABLE IF EXISTS `m_option_page_store`;
DROP TABLE IF EXISTS `m_option_page_store_custom_settings`;
DROP TABLE IF EXISTS `m_option_page_global`;
DROP TABLE IF EXISTS `m_option_page_global_custom_settings`;
DROP TABLE IF EXISTS `m_attribute_page_store`;
DROP TABLE IF EXISTS `m_attribute_page_store_custom_settings`;
DROP TABLE IF EXISTS `m_attribute_page_global`;
DROP TABLE IF EXISTS `m_attribute_page_global_custom_settings`;
DELETE FROM `core_resource` WHERE `code` = 'mana_attributepage_setup';
DELETE FROM `eav_entity_type` WHERE `entity_type_code` = 'm_filter';
DROP TABLE IF EXISTS `m_filter_int`;
DROP TABLE IF EXISTS `m_filter_varchar`;
DROP TABLE IF EXISTS `m_filter_datetime`;
DROP TABLE IF EXISTS `m_filter_decimal`;
DROP TABLE IF EXISTS `m_filter_text`;
DROP TABLE IF EXISTS `m_filter`;
DROP TABLE IF EXISTS `m_attribute`;
DROP TABLE IF EXISTS `m_db`;
DROP TABLE IF EXISTS `m_db_log`;
DROP TABLE IF EXISTS `m_filter2_value_store`;
DROP TABLE IF EXISTS `m_filter2_value`;
DROP TABLE IF EXISTS `m_filter2_store`;
DROP TABLE IF EXISTS `m_filter2`;
DROP TABLE IF EXISTS `m_seo_url_conflict`;
DROP TABLE IF EXISTS `m_seo_schema_store_flat`;
DROP TABLE IF EXISTS `m_seo_schema_store`;
DROP TABLE IF EXISTS `m_seo_schema_flat`;
DROP TABLE IF EXISTS `m_seo_schema`;
DROP TABLE IF EXISTS `m_edit_session`;
DELETE FROM `core_resource` WHERE `code` = 'mana_core_setup';
DELETE FROM `core_resource` WHERE `code` = 'mana_db_setup';
DELETE FROM `core_resource` WHERE `code` = 'mana_seo_setup';
DELETE FROM `core_resource` WHERE `code` = 'mana_filters_setup';
DELETE FROM `core_resource` WHERE `code` = 'manapro_filtershowmore_setup';
DELETE FROM `core_resource` WHERE `code` = 'manapro_filtersuperslider_setup';
DELETE FROM `core_resource` WHERE `code` = 'manapro_filtercolors_setup';
DELETE FROM `core_resource` WHERE `code` = 'manapro_filterexpandcollapse_setup';
DELETE FROM `core_resource` WHERE `code` = 'manapro_filterhelp_setup';
DELETE FROM `core_resource` WHERE `code` = 'manapro_filterpositioning_setup';
DELETE FROM `core_resource` WHERE `code` = 'manapro_filterseolinks_setup';
After running the script, installation should be continued.