Magento Forum

   
site now down after trying to make change in “manage stores”
 
nade93
Jr. Member
 
Total Posts:  6
Joined:  2009-08-14
 

Hi All

I am now getting a 404 on both admin and frontend for the site.

I went in and tried to change the Manage stores section. I added another stroe but did not make it default and now its just not working

I went to the core_website table in my database and the main website reads as follows

Full Texts website_id code name sort_order default_group_id is_default
Edit Delete 1 base Main Website 1 1 1

can anyone help please??

 
Magento Community Magento Community
Magento Community
Magento Community
 
nade93
Jr. Member
 
Total Posts:  6
Joined:  2009-08-14
 

i have had a play around to know luck on the database

can anyone figure out whats going on please??
-- Table structure for table `core_store`

CREATE TABLE IF NOT EXISTS `core_store` (
`store_id` smallint(5) unsigned NOT NULL auto_increment,
`code` varchar(32) NOT NULL default ‘’,
`website_id` smallint(5) unsigned default ‘0’,
`group_id` smallint(5) unsigned NOT NULL default ‘0’,
`name` varchar(255) NOT NULL,
`sort_order` smallint(5) unsigned NOT NULL default ‘0’,
`is_active` tinyint(1) unsigned NOT NULL default ‘0’,
PRIMARY KEY (`store_id`),
UNIQUE KEY `code` (`code`),
KEY `FK_STORE_WEBSITE` (`website_id`),
KEY `is_active` (`is_active`,`sort_order`),
KEY `FK_STORE_GROUP` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Stores’ AUTO_INCREMENT=2 ;

--
-- Dumping data for table `core_store`
--

INSERT INTO `core_store` (`store_id`, `code`, `website_id`, `group_id`, `name`, `sort_order`, `is_active`) VALUES
(1, ‘default’, 1, 1, ‘Default Store View’, 0, 1);

-- Table structure for table `core_store_group`

CREATE TABLE IF NOT EXISTS `core_store_group` (
`group_id` smallint(5) unsigned NOT NULL auto_increment,
`website_id` smallint(5) unsigned NOT NULL default ‘0’,
`name` varchar(255) NOT NULL,
`root_category_id` int(10) unsigned NOT NULL default ‘0’,
`default_store_id` smallint(5) unsigned NOT NULL default ‘0’,
PRIMARY KEY (`group_id`),
KEY `FK_STORE_GROUP_WEBSITE` (`website_id`),
KEY `default_store_id` (`default_store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `core_store_group`
--

INSERT INTO `core_store_group` (`group_id`, `website_id`, `name`, `root_category_id`, `default_store_id`) VALUES
(1, 1, ‘Main Website Store’, 2, 1);

--
-- Table structure for table `core_translate`
--

CREATE TABLE IF NOT EXISTS `core_translate` (
`key_id` int(10) unsigned NOT NULL auto_increment,
`string` varchar(255) NOT NULL default ‘’,
`store_id` smallint(5) unsigned NOT NULL default ‘0’,
`translate` varchar(255) NOT NULL default ‘’,
`locale` varchar(20) NOT NULL default ‘en_US’,
PRIMARY KEY (`key_id`),
UNIQUE KEY `IDX_CODE` (`store_id`,`locale`,`string`),
KEY `FK_CORE_TRANSLATE_STORE` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Translation data’ AUTO_INCREMENT=1 ;

--
-- Dumping data for table `core_translate`
--

-- --------------------------------------------------------

--
-- Table structure for table `core_url_rewrite`
--

CREATE TABLE IF NOT EXISTS `core_url_rewrite` (
`url_rewrite_id` int(10) unsigned NOT NULL auto_increment,
`store_id` smallint(5) unsigned NOT NULL default ‘0’,
`category_id` int(10) unsigned default NULL,
`product_id` int(10) unsigned default NULL,
`id_path` varchar(255) NOT NULL default ‘’,
`request_path` varchar(255) NOT NULL default ‘’,
`target_path` varchar(255) NOT NULL default ‘’,
`is_system` tinyint(1) unsigned default ‘1’,
`options` varchar(255) NOT NULL default ‘’,
`description` varchar(255) default NULL,
PRIMARY KEY (`url_rewrite_id`),
UNIQUE KEY `UNQ_REQUEST_PATH` (`store_id`,`request_path`),
UNIQUE KEY `UNQ_PATH` (`store_id`,`id_path`,`is_system`),
KEY `FK_CORE_URL_REWRITE_STORE` (`store_id`),
KEY `IDX_TARGET_PATH` (`store_id`,`target_path`),
KEY `IDX_ID_PATH` (`id_path`),
KEY `FK_CORE_URL_REWRITE_PRODUCT` (`product_id`),
KEY `IDX_CATEGORY_REWRITE` (`category_id`,`is_system`,`product_id`,`store_id`,`id_path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `core_url_rewrite`
--

INSERT INTO `core_url_rewrite` (`url_rewrite_id`, `store_id`, `category_id`, `product_id`, `id_path`, `request_path`, `target_path`, `is_system`, `options`, `description`) VALUES
(1, 1, NULL, 1, ‘product/1’, ‘scaffolding-product-one.html’, ‘catalog/product/view/id/1’, 1, ‘’, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `core_website`
--

CREATE TABLE IF NOT EXISTS `core_website` (
`website_id` smallint(5) unsigned NOT NULL auto_increment,
`code` varchar(32) NOT NULL default ‘’,
`name` varchar(64) NOT NULL default ‘’,
`sort_order` smallint(5) unsigned NOT NULL default ‘0’,
`default_group_id` smallint(5) unsigned NOT NULL default ‘0’,
`is_default` tinyint(1) unsigned default ‘0’,
PRIMARY KEY (`website_id`),
UNIQUE KEY `code` (`code`),
KEY `sort_order` (`sort_order`),
KEY `default_group_id` (`default_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Websites’ AUTO_INCREMENT=2 ;

--
-- Dumping data for table `core_website`
--

INSERT INTO `core_website` (`website_id`, `code`, `name`, `sort_order`, `default_group_id`, `is_default`) VALUES
(1, ‘base’, ‘Main Website’, 0, 1, 1);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `core_store`
--
ALTER TABLE `core_store`
ADD CONSTRAINT `FK_STORE_GROUP_STORE` FOREIGN KEY (`group_id`) REFERENCES `core_store_group` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_STORE_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `core_store_group`
--
ALTER TABLE `core_store_group`
ADD CONSTRAINT `FK_STORE_GROUP_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `core_translate`
--
ALTER TABLE `core_translate`
ADD CONSTRAINT `FK_CORE_TRANSLATE_STORE` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `core_url_rewrite`
--
ALTER TABLE `core_url_rewrite`
ADD CONSTRAINT `FK_CORE_URL_REWRITE_CATEGORY` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE C

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top