PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'admin_assert' already exists
[string:private] =>
[code:protected] => 42S01
[file:protected] => /var/www/winesandmakers.com/live/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line:protected] => 109
[trace:private] => Array
(
[0] => Array
(
[file] => /var/www/winesandmakers.com/live/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 109
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] => -- DROP TABLE IF EXISTS admin_assert;
CREATE TABLE admin_assert (
`assert_id` int(10) unsigned NOT NULL auto_increment,
`assert_type` varchar(20) character set utf8 NOT NULL default '',
`assert_data` text character set utf8,
PRIMARY KEY (`assert_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ACL Asserts'
)
)
[1] => Array
(
[file] => /var/www/winesandmakers.com/live/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 147
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => -- DROP TABLE IF EXISTS admin_assert;
CREATE TABLE admin_assert (
`assert_id` int(10) unsigned NOT NULL auto_increment,
`assert_type` varchar(20) character set utf8 NOT NULL default '',
`assert_data` text character set utf8,
PRIMARY KEY (`assert_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ACL Asserts'
)
)
[2] => Array
(
[file] => /var/www/winesandmakers.com/live/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 484
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
-- DROP TABLE IF EXISTS admin_assert;
CREATE TABLE admin_assert (
`assert_id` int(10) unsigned NOT NULL auto_increment,
`assert_type` varchar(20) character set utf8 NOT NULL default '',
`assert_data` text character set utf8,
PRIMARY KEY (`assert_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ACL Asserts';
-- DROP TABLE IF EXISTS admin_role;
CREATE TABLE admin_role (
`role_id` int(10) unsigned NOT NULL auto_increment,
`parent_id` int(10) unsigned NOT NULL default '0',
`tree_level` tinyint(3) unsigned NOT NULL default '0',
`sort_order` tinyint(3) unsigned NOT NULL default '0',
`role_type` char(1) character set utf8 NOT NULL default '0',
`user_id` int(11) unsigned NOT NULL default '0',
`role_name` varchar(50) character set utf8 NOT NULL default '',
PRIMARY KEY (`role_id`),
KEY `parent_id` (`parent_id`,`sort_order`),
KEY `tree_level` (`tree_level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ACL Roles';
insert into admin_role(`role_id`,`parent_id`,`tree_level`,`sort_order`,`role_type`,`user_id`,`role_name`) values (1,0,1,1,'G',0,'Administrators'),(2,1,2,1,'U',1,'Administrator');
-- DROP TABLE IF EXISTS admin_rule;
CREATE TABLE admin_rule (
`rule_id` int(10) unsigned NOT NULL auto_increment,
`role_id` int(10) unsigned NOT NULL default '0',
`resource_id` varchar(255) character set utf8 NOT NULL default '',
`privileges` varchar(20) character set utf8 NOT NULL default '',
`assert_id` int(10) unsigned NOT NULL default '0',
`role_type` char(1) default NULL,
`permission` varchar(10) default NULL,
PRIMARY KEY (`rule_id`),
KEY `resource` (`resource_id`,`role_id`),
KEY `role_id` (`role_id`,`resource_id`),
CONSTRAINT `FK_admin_rule` FOREIGN KEY (`role_id`) REFERENCES admin_role (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ACL Rules';
insert into admin_rule(`rule_id`, `role_id`, `resource_id`, `privileges`, `assert_id`, `role_type`, `permission`) values (1,1,'all','',0,'G','allow');
-- DROP TABLE IF EXISTS admin_user;
CREATE TABLE admin_user (
`user_id` mediumint(9) unsigned NOT NULL auto_increment,
`firstname` varchar(32) character set utf8 NOT NULL default '',
`lastname` varchar(32) character set utf8 NOT NULL default '',
`email` varchar(128) character set utf8 NOT NULL default '',
`username` varchar(40) character set utf8 NOT NULL default '',
`password` varchar(40) character set utf8 NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime default NULL,
`logdate` datetime default NULL,
`lognum` smallint(5) unsigned NOT NULL default '0',
`reload_acl_flag` tinyint(1) NOT NULL default '0',
`is_active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Users';
insert into admin_user(`user_id`,`firstname`,`lastname`,`email`,`username`,`password`,`created`,`modified`,`logdate`,`lognum`,`reload_acl_flag`,`is_active`) values (1,'admin','admin','admin@your_domain.com','admin','4297f44b13955235245b2497399d7a93',NOW(),NOW(),NOW(),1,0,1);
)
)
[3] => Array
(
[file] => /var/www/winesandmakers.com/live/app/code/core/Mage/Admin/sql/admin_setup/mysql4-install-0.7.0.php
[line] => 88
[function] => run
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] =>
-- DROP TABLE IF EXISTS admin_assert;
CREATE TABLE admin_assert (
`assert_id` int(10) unsigned NOT NULL auto_increment,
`assert_type` varchar(20) character set utf8 NOT NULL default '',
`assert_data` text character set utf8,
PRIMARY KEY (`assert_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ACL Asserts';
-- DROP TABLE IF EXISTS admin_role;
CREATE TABLE admin_role (
`role_id` int(10) unsigned NOT NULL auto_increment,
`parent_id` int(10) unsigned NOT NULL default '0',
`tree_level` tinyint(3) unsigned NOT NULL default '0',
`sort_order` tinyint(3) unsigned NOT NULL default '0',
`role_type` char(1) character set utf8 NOT NULL default '0',
`user_id` int(11) unsigned NOT NULL default '0',
`role_name` varchar(50) character set utf8 NOT NULL default '',
PRIMARY KEY (`role_id`),
KEY `parent_id` (`parent_id`,`sort_order`),
KEY `tree_level` (`tree_level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ACL Roles';
insert into admin_role(`role_id`,`parent_id`,`tree_level`,`sort_order`,`role_type`,`user_id`,`role_name`) values (1,0,1,1,'G',0,'Administrators'),(2,1,2,1,'U',1,'Administrator');
-- DROP TABLE IF EXISTS admin_rule;
CREATE TABLE admin_rule (
`rule_id` int(10) unsigned NOT NULL auto_increment,
`role_id` int(10) unsigned NOT NULL default '0',
`resource_id` varchar(255) character set utf8 NOT NULL default '',
`privileges` varchar(20) character set utf8 NOT NULL default '',
`assert_id` int(10) unsigned NOT NULL default '0',
`role_type` char(1) default NULL,
`permission` varchar(10) default NULL,
PRIMARY KEY (`rule_id`),
KEY `resource` (`resource_id`,`role_id`),
KEY `role_id` (`role_id`,`resource_id`),
CONSTRAINT `FK_admin_rule` FOREIGN KEY (`role_id`) REFERENCES admin_role (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ACL Rules';
insert into admin_rule(`rule_id`, `role_id`, `resource_id`, `privileges`, `assert_id`, `role_type`, `permission`) values (1,1,'all','',0,'G','allow');
-- DROP TABLE IF EXISTS admin_user;
CREATE TABLE admin_user (
`user_id` mediumint(9) unsigned NOT NULL auto_increment,
`firstname` varchar(32) character set utf8 NOT NULL default '',
`lastname` varchar(32) character set utf8 NOT NULL default '',
`email` varchar(128) character set utf8 NOT NULL default '',
`username` varchar(40) character set utf8 NOT NULL default '',
`password` varchar(40) character set utf8 NOT NULL default '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime default NULL,
`logdate` datetime default NULL,
`lognum` smallint(5) unsigned NOT NULL default '0',
`reload_acl_flag` tinyint(1) NOT NULL default '0',
`is_active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Users';
insert into admin_user(`user_id`,`firstname`,`lastname`,`email`,`username`,`password`,`created`,`modified`,`logdate`,`lognum`,`reload_acl_flag`,`is_active`) values (1,'admin','admin','admin@your_domain.com','admin','4297f44b13955235245b2497399d7a93',NOW(),NOW(),NOW(),1,0,1);
)
)
[4] => Array
(
[file] => /var/www/winesandmakers.com/live/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 260
[args] => Array
(
[0] => /var/www/winesandmakers.com/live/app/code/core/Mage/Admin/sql/admin_setup/mysql4-install-0.7.0.php
)
[function] => include
)
[5] => Array
(
[file] => /var/www/winesandmakers.com/live/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 158
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => install
[1] =>
[2] => 0.7.1
)
)
[6] => Array
(
[file] => /var/www/winesandmakers.com/live/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 144
[function] => _installResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 0.7.1
)
)
[7] => Array
(
[file] => /var/www/winesandmakers.com/live/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 111
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)
)
[8] => Array
(
[file] => /var/www/winesandmakers.com/live/app/code/core/Mage/Core/Model/Config.php
[line] => 195
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[9] => Array
(
[file] => /var/www/winesandmakers.com/live/app/code/core/Mage/Core/Model/App.php
[line] => 208
[function] => init
[class] => Mage_Core_Model_Config
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[10] => Array
(
[file] => /var/www/winesandmakers.com/live/app/Mage.php
[line] => 404
[function] => init
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] =>
[1] => store
[2] => Array
(
)
)
)
[11] => Array
(
[file] => /var/www/winesandmakers.com/live/app/Mage.php
[line] => 423
[function] => app
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
[2] => Array
(
)
)
)
[12] => Array
(
[file] => /var/www/winesandmakers.com/live/index.php
[line] => 46
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
)
)
)
[errorInfo] => Array
(
[0] => 42S01
[1] => 1050
[2] => Table 'admin_assert' already exists
)
)
Error in file: "/var/www/winesandmakers.com/live/app/code/core/Mage/Admin/sql/admin_setup/mysql4-install-0.7.0.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'admin_assert' already exists
#0 /var/www/winesandmakers.com/live/app/code/core/Mage/Core/Model/Resource/Setup.php(278): Mage::exception('Mage_Core', 'Error in file: ...')
#1 /var/www/winesandmakers.com/live/app/code/core/Mage/Core/Model/Resource/Setup.php(158): Mage_Core_Model_Resource_Setup->_modifyResourceDb('install', '', '0.7.1')
#2 /var/www/winesandmakers.com/live/app/code/core/Mage/Core/Model/Resource/Setup.php(144): Mage_Core_Model_Resource_Setup->_installResourceDb('0.7.1')
#3 /var/www/winesandmakers.com/live/app/code/core/Mage/Core/Model/Resource/Setup.php(111): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /var/www/winesandmakers.com/live/app/code/core/Mage/Core/Model/Config.php(195): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /var/www/winesandmakers.com/live/app/code/core/Mage/Core/Model/App.php(208): Mage_Core_Model_Config->init(Array)
#6 /var/www/winesandmakers.com/live/app/Mage.php(404): Mage_Core_Model_App->init('', 'store', Array)
#7 /var/www/winesandmakers.com/live/app/Mage.php(423): Mage::app('', 'store', Array)
#8 /var/www/winesandmakers.com/live/index.php(46): Mage::run()
#9 {main}