PDOException Object ( [message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mfbouwadmin_assert' already exists [string:Exception:private] => [code:protected] => 42S01 [file:protected] => /home/p2390/domains/mfbouw.nl/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php [line:protected] => 277 [trace:Exception:private] => Array ( [0] => Array ( [file] => /home/p2390/domains/mfbouw.nl/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php [line] => 277 [function] => query [class] => PDO [type] => -> [args] => Array ( [0] => -- DROP TABLE IF EXISTS mfbouwadmin_assert; CREATE TABLE mfbouwadmin_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] => /home/p2390/domains/mfbouw.nl/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php [line] => 401 [function] => raw_query [class] => Varien_Db_Adapter_Pdo_Mysql [type] => -> [args] => Array ( [0] => -- DROP TABLE IF EXISTS mfbouwadmin_assert; CREATE TABLE mfbouwadmin_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] => /home/p2390/domains/mfbouw.nl/public_html/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 mfbouwadmin_assert; CREATE TABLE mfbouwadmin_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 mfbouwadmin_role; CREATE TABLE mfbouwadmin_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 mfbouwadmin_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 mfbouwadmin_rule; CREATE TABLE mfbouwadmin_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 mfbouwadmin_role (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ACL Rules'; insert into mfbouwadmin_rule(`rule_id`, `role_id`, `resource_id`, `privileges`, `assert_id`, `role_type`, `permission`) values (1,1,'all','',0,'G','allow'); -- DROP TABLE IF EXISTS mfbouwadmin_user; CREATE TABLE mfbouwadmin_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] => /home/p2390/domains/mfbouw.nl/public_html/app/code/core/Mage/Admin/sql/admin_setup/mysql4-install-0.7.0.php [line] => 91 [function] => run [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( [0] => -- DROP TABLE IF EXISTS mfbouwadmin_assert; CREATE TABLE mfbouwadmin_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 mfbouwadmin_role; CREATE TABLE mfbouwadmin_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 mfbouwadmin_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 mfbouwadmin_rule; CREATE TABLE mfbouwadmin_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 mfbouwadmin_role (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ACL Rules'; insert into mfbouwadmin_rule(`rule_id`, `role_id`, `resource_id`, `privileges`, `assert_id`, `role_type`, `permission`) values (1,1,'all','',0,'G','allow'); -- DROP TABLE IF EXISTS mfbouwadmin_user; CREATE TABLE mfbouwadmin_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] => /home/p2390/domains/mfbouw.nl/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 376 [args] => Array ( [0] => /home/p2390/domains/mfbouw.nl/public_html/app/code/core/Mage/Admin/sql/admin_setup/mysql4-install-0.7.0.php ) [function] => include ) [5] => Array ( [file] => /home/p2390/domains/mfbouw.nl/public_html/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] => /home/p2390/domains/mfbouw.nl/public_html/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] => /home/p2390/domains/mfbouw.nl/public_html/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] => /home/p2390/domains/mfbouw.nl/public_html/app/code/core/Mage/Core/Model/App.php [line] => 399 [function] => applyAllUpdates [class] => Mage_Core_Model_Resource_Setup [type] => :: [args] => Array ( ) ) [9] => Array ( [file] => /home/p2390/domains/mfbouw.nl/public_html/app/code/core/Mage/Core/Model/App.php [line] => 329 [function] => _initModules [class] => Mage_Core_Model_App [type] => -> [args] => Array ( ) ) [10] => Array ( [file] => /home/p2390/domains/mfbouw.nl/public_html/app/Mage.php [line] => 627 [function] => run [class] => Mage_Core_Model_App [type] => -> [args] => Array ( [0] => Array ( [scope_code] => [scope_type] => store [options] => Array ( ) ) ) ) [11] => Array ( [file] => /home/p2390/domains/mfbouw.nl/public_html/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 'mfbouwadmin_assert' already exists ) )