Wow, you guys have a great support team. When my layered navigation suddenly developed a bug, you guys found it and fixed it for me in less than 24 ho ... Read more

Jan 25, 2017 Mr. Don President

Certified Magento Enterprise developer Certified Magento developer Certified Magento theme developer Certified Magento specialist

Manadev is certified extension and theme
developer for Magento

"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.

We Accept: PayPal Visa MasterCard American Express Discover