PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'magento1core_resource' already exists
[string:Exception:private] =>
[code:protected] => 42S01
[file:protected] => /var/www/vhosts/galeriej7.com/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line:protected] => 150
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /var/www/vhosts/galeriej7.com/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 150
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `magento1core_resource` (
`code` varchar(50) NOT NULL default '',
`version` varchar(50) NOT NULL default '',
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Resource version registry'
)
)
[1] => Array
(
[file] => /var/www/vhosts/galeriej7.com/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 212
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `magento1core_resource` (
`code` varchar(50) NOT NULL default '',
`version` varchar(50) NOT NULL default '',
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Resource version registry'
)
)
[2] => Array
(
[file] => /var/www/vhosts/galeriej7.com/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 487
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
CREATE TABLE `magento1core_resource` (
`code` varchar(50) NOT NULL default '',
`version` varchar(50) NOT NULL default '',
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Resource version registry';
CREATE TABLE `magento1core_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',
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';
INSERT INTO `magento1core_website` VALUES
(0, 'admin', 'Admin', 0, 0),
(1, 'base', 'Main Website', 0, 1);
-- DROP TABLE IF EXISTS `magento1core_store_group`;
CREATE TABLE `magento1core_store_group` (
`group_id` smallint(5) unsigned NOT NULL auto_increment,
`website_id` smallint(5) unsigned NOT NULL default '0',
`name` varchar(32) NOT NULL default '',
`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;
INSERT INTO `magento1core_store_group` VALUES
(0, 0, 'Default', 0, 0),
(1, 1, 'Main Website Store', 2, 1);
-- DROP TABLE IF EXISTS `magento1core_store`;
CREATE TABLE `magento1core_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(32) NOT NULL default '',
`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';
INSERT INTO `magento1core_store` VALUES
(0, 'admin', 0, 0, 'Admin', 0, 1),
(1, 'default', 1, 1, 'Default Store View', 0, 1);
CREATE TABLE `magento1core_config_data` (
`config_id` int(10) unsigned NOT NULL auto_increment,
`scope` enum('default','websites','stores','config') NOT NULL default 'default',
`scope_id` int(11) NOT NULL default '0',
`path` varchar(255) NOT NULL default 'general',
`value` text NOT NULL,
PRIMARY KEY (`config_id`),
UNIQUE KEY `config_scope` (`scope`,`scope_id`,`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `magento1core_email_template` (
`template_id` int(7) unsigned NOT NULL auto_increment,
`template_code` varchar(150) default NULL,
`template_text` text,
`template_type` int(3) unsigned default NULL,
`template_subject` varchar(200) default NULL,
`template_sender_name` varchar(200) default NULL,
`template_sender_email` varchar(200) character set latin1 collate latin1_general_ci default NULL,
`added_at` datetime default NULL,
`modified_at` datetime default NULL,
PRIMARY KEY (`template_id`),
UNIQUE KEY `template_code` (`template_code`),
KEY `added_at` (`added_at`),
KEY `modified_at` (`modified_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Email templates';
CREATE TABLE `magento1core_layout_update` (
`layout_update_id` int(10) unsigned NOT NULL auto_increment,
`handle` varchar(255) default NULL,
`xml` text,
PRIMARY KEY (`layout_update_id`),
KEY `handle` (`handle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `magento1core_layout_link` (
`layout_link_id` int(10) unsigned NOT NULL auto_increment,
`store_id` smallint(5) unsigned NOT NULL default '0',
`package` varchar(64) NOT NULL default '',
`theme` varchar(64) NOT NULL default '',
`layout_update_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`layout_link_id`),
UNIQUE KEY `store_id` (`store_id`,`package`,`theme`,`layout_update_id`),
KEY `FK_core_layout_link_update` (`layout_update_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `magento1core_session` (
`session_id` varchar(255) NOT NULL default '',
`website_id` smallint(5) unsigned default NULL,
`session_expires` int(10) unsigned NOT NULL default '0',
`session_data` text NOT NULL,
PRIMARY KEY (`session_id`),
KEY `FK_SESSION_WEBSITE` (`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Session data store';
CREATE TABLE `magento1core_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';
CREATE TABLE `magento1core_url_rewrite` (
`url_rewrite_id` int(10) unsigned NOT NULL auto_increment,
`store_id` smallint(5) unsigned NOT NULL default '0',
`id_path` varchar(255) NOT NULL default '',
`request_path` varchar(255) NOT NULL default '',
`target_path` varchar(255) NOT NULL default '',
`options` varchar(255) NOT NULL default '',
`type` int(1) NOT NULL default '0',
`description` varchar(255) default NULL,
PRIMARY KEY (`url_rewrite_id`),
UNIQUE KEY `id_path` (`id_path`,`store_id`),
UNIQUE KEY `request_path` (`request_path`,`store_id`),
KEY `target_path` (`target_path`,`store_id`),
KEY `store_id` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `magento1core_url_rewrite_tag` (
`url_rewrite_tag_id` int(10) unsigned NOT NULL auto_increment,
`url_rewrite_id` int(10) unsigned NOT NULL default '0',
`tag` varchar(255) default NULL,
PRIMARY KEY (`url_rewrite_tag_id`),
UNIQUE KEY `tag` (`tag`,`url_rewrite_id`),
KEY `url_rewrite_id` (`url_rewrite_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `magento1design_change` (
`design_change_id` int(11) NOT NULL auto_increment,
`store_id` smallint(5) unsigned NOT NULL default '0',
`design` varchar(255) NOT NULL default '',
`date_from` date NOT NULL default '0000-00-00',
`date_to` date NOT NULL default '0000-00-00',
PRIMARY KEY (`design_change_id`),
KEY `FK_DESIGN_CHANGE_STORE` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)
)
[3] => Array
(
[file] => /var/www/vhosts/galeriej7.com/httpdocs/app/code/core/Mage/Core/sql/core_setup/mysql4-install-0.8.0.php
[line] => 184
[function] => run
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] =>
CREATE TABLE `magento1core_resource` (
`code` varchar(50) NOT NULL default '',
`version` varchar(50) NOT NULL default '',
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Resource version registry';
CREATE TABLE `magento1core_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',
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';
INSERT INTO `magento1core_website` VALUES
(0, 'admin', 'Admin', 0, 0),
(1, 'base', 'Main Website', 0, 1);
-- DROP TABLE IF EXISTS `magento1core_store_group`;
CREATE TABLE `magento1core_store_group` (
`group_id` smallint(5) unsigned NOT NULL auto_increment,
`website_id` smallint(5) unsigned NOT NULL default '0',
`name` varchar(32) NOT NULL default '',
`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;
INSERT INTO `magento1core_store_group` VALUES
(0, 0, 'Default', 0, 0),
(1, 1, 'Main Website Store', 2, 1);
-- DROP TABLE IF EXISTS `magento1core_store`;
CREATE TABLE `magento1core_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(32) NOT NULL default '',
`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';
INSERT INTO `magento1core_store` VALUES
(0, 'admin', 0, 0, 'Admin', 0, 1),
(1, 'default', 1, 1, 'Default Store View', 0, 1);
CREATE TABLE `magento1core_config_data` (
`config_id` int(10) unsigned NOT NULL auto_increment,
`scope` enum('default','websites','stores','config') NOT NULL default 'default',
`scope_id` int(11) NOT NULL default '0',
`path` varchar(255) NOT NULL default 'general',
`value` text NOT NULL,
PRIMARY KEY (`config_id`),
UNIQUE KEY `config_scope` (`scope`,`scope_id`,`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `magento1core_email_template` (
`template_id` int(7) unsigned NOT NULL auto_increment,
`template_code` varchar(150) default NULL,
`template_text` text,
`template_type` int(3) unsigned default NULL,
`template_subject` varchar(200) default NULL,
`template_sender_name` varchar(200) default NULL,
`template_sender_email` varchar(200) character set latin1 collate latin1_general_ci default NULL,
`added_at` datetime default NULL,
`modified_at` datetime default NULL,
PRIMARY KEY (`template_id`),
UNIQUE KEY `template_code` (`template_code`),
KEY `added_at` (`added_at`),
KEY `modified_at` (`modified_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Email templates';
CREATE TABLE `magento1core_layout_update` (
`layout_update_id` int(10) unsigned NOT NULL auto_increment,
`handle` varchar(255) default NULL,
`xml` text,
PRIMARY KEY (`layout_update_id`),
KEY `handle` (`handle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `magento1core_layout_link` (
`layout_link_id` int(10) unsigned NOT NULL auto_increment,
`store_id` smallint(5) unsigned NOT NULL default '0',
`package` varchar(64) NOT NULL default '',
`theme` varchar(64) NOT NULL default '',
`layout_update_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`layout_link_id`),
UNIQUE KEY `store_id` (`store_id`,`package`,`theme`,`layout_update_id`),
KEY `FK_core_layout_link_update` (`layout_update_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `magento1core_session` (
`session_id` varchar(255) NOT NULL default '',
`website_id` smallint(5) unsigned default NULL,
`session_expires` int(10) unsigned NOT NULL default '0',
`session_data` text NOT NULL,
PRIMARY KEY (`session_id`),
KEY `FK_SESSION_WEBSITE` (`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Session data store';
CREATE TABLE `magento1core_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';
CREATE TABLE `magento1core_url_rewrite` (
`url_rewrite_id` int(10) unsigned NOT NULL auto_increment,
`store_id` smallint(5) unsigned NOT NULL default '0',
`id_path` varchar(255) NOT NULL default '',
`request_path` varchar(255) NOT NULL default '',
`target_path` varchar(255) NOT NULL default '',
`options` varchar(255) NOT NULL default '',
`type` int(1) NOT NULL default '0',
`description` varchar(255) default NULL,
PRIMARY KEY (`url_rewrite_id`),
UNIQUE KEY `id_path` (`id_path`,`store_id`),
UNIQUE KEY `request_path` (`request_path`,`store_id`),
KEY `target_path` (`target_path`,`store_id`),
KEY `store_id` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `magento1core_url_rewrite_tag` (
`url_rewrite_tag_id` int(10) unsigned NOT NULL auto_increment,
`url_rewrite_id` int(10) unsigned NOT NULL default '0',
`tag` varchar(255) default NULL,
PRIMARY KEY (`url_rewrite_tag_id`),
UNIQUE KEY `tag` (`tag`,`url_rewrite_id`),
KEY `url_rewrite_id` (`url_rewrite_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `magento1design_change` (
`design_change_id` int(11) NOT NULL auto_increment,
`store_id` smallint(5) unsigned NOT NULL default '0',
`design` varchar(255) NOT NULL default '',
`date_from` date NOT NULL default '0000-00-00',
`date_to` date NOT NULL default '0000-00-00',
PRIMARY KEY (`design_change_id`),
KEY `FK_DESIGN_CHANGE_STORE` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)
)
[4] => Array
(
[file] => /var/www/vhosts/galeriej7.com/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 262
[args] => Array
(
[0] => /var/www/vhosts/galeriej7.com/httpdocs/app/code/core/Mage/Core/sql/core_setup/mysql4-install-0.8.0.php
)
[function] => include
)
[5] => Array
(
[file] => /var/www/vhosts/galeriej7.com/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 160
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => install
[1] =>
[2] => 0.8.8
)
)
[6] => Array
(
[file] => /var/www/vhosts/galeriej7.com/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 148
[function] => _installResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 0.8.8
)
)
[7] => Array
(
[file] => /var/www/vhosts/galeriej7.com/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 114
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)
)
[8] => Array
(
[file] => /var/www/vhosts/galeriej7.com/httpdocs/app/code/core/Mage/Core/Model/Config.php
[line] => 209
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[9] => Array
(
[file] => /var/www/vhosts/galeriej7.com/httpdocs/app/code/core/Mage/Core/Model/App.php
[line] => 230
[function] => init
[class] => Mage_Core_Model_Config
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[10] => Array
(
[file] => /var/www/vhosts/galeriej7.com/httpdocs/app/Mage.php
[line] => 397
[function] => init
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] =>
[1] => store
[2] => Array
(
)
)
)
[11] => Array
(
[file] => /var/www/vhosts/galeriej7.com/httpdocs/app/Mage.php
[line] => 416
[function] => app
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
[2] => Array
(
)
)
)
[12] => Array
(
[file] => /var/www/vhosts/galeriej7.com/httpdocs/index.php
[line] => 46
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
)
)
)
[previous:Exception:private] =>
[errorInfo] => Array
(
[0] => 42S01
[1] => 1050
[2] => Table 'magento1core_resource' already exists
)
)
Error in file: "/var/www/vhosts/galeriej7.com/httpdocs/app/code/core/Mage/Core/sql/core_setup/mysql4-install-0.8.0.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'magento1core_resource' already exists
#0 /var/www/vhosts/galeriej7.com/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(280): Mage::exception('Mage_Core', 'Error in file: ...')
#1 /var/www/vhosts/galeriej7.com/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(160): Mage_Core_Model_Resource_Setup->_modifyResourceDb('install', '', '0.8.8')
#2 /var/www/vhosts/galeriej7.com/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(148): Mage_Core_Model_Resource_Setup->_installResourceDb('0.8.8')
#3 /var/www/vhosts/galeriej7.com/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(114): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /var/www/vhosts/galeriej7.com/httpdocs/app/code/core/Mage/Core/Model/Config.php(209): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /var/www/vhosts/galeriej7.com/httpdocs/app/code/core/Mage/Core/Model/App.php(230): Mage_Core_Model_Config->init(Array)
#6 /var/www/vhosts/galeriej7.com/httpdocs/app/Mage.php(397): Mage_Core_Model_App->init('', 'store', Array)
#7 /var/www/vhosts/galeriej7.com/httpdocs/app/Mage.php(416): Mage::app('', 'store', Array)
#8 /var/www/vhosts/galeriej7.com/httpdocs/index.php(46): Mage::run()
#9 {main}