PDOException Object ( [message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'admin_assert' already exists [string:Exception:private] => [code:protected] => 42S01 [file:protected] => /var/www/vhosts/ledsdoitnow.nl/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php [line:protected] => 276 [trace:Exception:private] => Array ( [0] => Array ( [file] => /var/www/vhosts/ledsdoitnow.nl/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php [line] => 276 [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/vhosts/ledsdoitnow.nl/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php [line] => 397 [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/vhosts/ledsdoitnow.nl/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 636 [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'; ) ) [3] => Array ( [file] => /var/www/vhosts/ledsdoitnow.nl/httpdocs/app/code/core/Mage/Admin/sql/admin_setup/mysql4-install-0.7.0.php [line] => 76 [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'; ) ) [4] => Array ( [file] => /var/www/vhosts/ledsdoitnow.nl/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 376 [args] => Array ( [0] => /var/www/vhosts/ledsdoitnow.nl/httpdocs/app/code/core/Mage/Admin/sql/admin_setup/mysql4-install-0.7.0.php ) [function] => include ) [5] => Array ( [file] => /var/www/vhosts/ledsdoitnow.nl/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 276 [function] => _modifyResourceDb [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( [0] => install [1] => [2] => 0.7.2 ) ) [6] => Array ( [file] => /var/www/vhosts/ledsdoitnow.nl/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 240 [function] => _installResourceDb [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( [0] => 0.7.2 ) ) [7] => Array ( [file] => /var/www/vhosts/ledsdoitnow.nl/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 161 [function] => applyUpdates [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( ) ) [8] => Array ( [file] => /var/www/vhosts/ledsdoitnow.nl/httpdocs/app/code/core/Mage/Core/Model/App.php [line] => 399 [function] => applyAllUpdates [class] => Mage_Core_Model_Resource_Setup [type] => :: [args] => Array ( ) ) [9] => Array ( [file] => /var/www/vhosts/ledsdoitnow.nl/httpdocs/app/code/core/Mage/Core/Model/App.php [line] => 329 [function] => _initModules [class] => Mage_Core_Model_App [type] => -> [args] => Array ( ) ) [10] => Array ( [file] => /var/www/vhosts/ledsdoitnow.nl/httpdocs/app/Mage.php [line] => 626 [function] => run [class] => Mage_Core_Model_App [type] => -> [args] => Array ( [0] => Array ( [scope_code] => [scope_type] => store [options] => Array ( ) ) ) ) [11] => Array ( [file] => /var/www/vhosts/ledsdoitnow.nl/httpdocs/index.php [line] => 80 [function] => run [class] => Mage [type] => :: [args] => Array ( [0] => [1] => store ) ) ) [previous:Exception:private] => [errorInfo] => Array ( [0] => 42S01 [1] => 1050 [2] => Table 'admin_assert' already exists ) )