Really incredible support from the team at MANAdev. I was having some issues getting the Layered Navigation SEO Plus set up as my theme was causing a ... Read more

Jan 10, 2017 Chanette Kennedy

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