Important. We are closed. Due to decreased amount of time available, we don't accept new orders and we don't provide support for existing ones.

Your support is so fast it’s stunning. You guys obviously know your stuff, including the knowledge of your clients who make mistakes during installati ... Read more

Apr 21, 2017 Haleen Hoes

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