Zend_Db_Statement_Exception Object ( [_previous:Zend_Exception:private] => [message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'nmc_supplierprices_matris' already exists, query was: CREATE TABLE `nmc_supplierprices_matris` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `price_from` decimal(12,2) NOT NULL default '0.00' COMMENT 'Price From' , `price_to` decimal(12,2) NOT NULL default '0.00' COMMENT 'Price To' , `contribution_margin` decimal(12,2) NOT NULL default '0.00' COMMENT 'Contribution Margin' , `coverage_ratio` int UNSIGNED NOT NULL default '0' COMMENT 'Coverage Ratio' , PRIMARY KEY (`entity_id`), UNIQUE `UNQ_NMC_SUPPLIERPRICES_MATRIS_PRICE_FROM_PRICE_TO` (`price_from`, `price_to`) ) COMMENT='nmc_supplierprices_matris' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci [string:Exception:private] => [code:protected] => 42 [file:protected] => /var/www/live.nordicmotorcenter.se/public/lib/Zend/Db/Statement/Pdo.php [line:protected] => 235 [trace:Exception:private] => Array ( [0] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/lib/Varien/Db/Statement/Pdo/Mysql.php [line] => 110 [function] => _execute [class] => Zend_Db_Statement_Pdo [type] => -> [args] => Array ( [0] => Array ( ) ) ) [1] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/code/core/Zend/Db/Statement.php [line] => 291 [function] => _execute [class] => Varien_Db_Statement_Pdo_Mysql [type] => -> [args] => Array ( [0] => Array ( ) ) ) [2] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/lib/Zend/Db/Adapter/Abstract.php [line] => 480 [function] => execute [class] => Zend_Db_Statement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [3] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/lib/Zend/Db/Adapter/Pdo/Abstract.php [line] => 238 [function] => query [class] => Zend_Db_Adapter_Abstract [type] => -> [args] => Array ( [0] => CREATE TABLE `nmc_supplierprices_matris` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `price_from` decimal(12,2) NOT NULL default '0.00' COMMENT 'Price From' , `price_to` decimal(12,2) NOT NULL default '0.00' COMMENT 'Price To' , `contribution_margin` decimal(12,2) NOT NULL default '0.00' COMMENT 'Contribution Margin' , `coverage_ratio` int UNSIGNED NOT NULL default '0' COMMENT 'Coverage Ratio' , PRIMARY KEY (`entity_id`), UNIQUE `UNQ_NMC_SUPPLIERPRICES_MATRIS_PRICE_FROM_PRICE_TO` (`price_from`, `price_to`) ) COMMENT='nmc_supplierprices_matris' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci [1] => Array ( ) ) ) [4] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/lib/Varien/Db/Adapter/Pdo/Mysql.php [line] => 428 [function] => query [class] => Zend_Db_Adapter_Pdo_Abstract [type] => -> [args] => Array ( [0] => CREATE TABLE `nmc_supplierprices_matris` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `price_from` decimal(12,2) NOT NULL default '0.00' COMMENT 'Price From' , `price_to` decimal(12,2) NOT NULL default '0.00' COMMENT 'Price To' , `contribution_margin` decimal(12,2) NOT NULL default '0.00' COMMENT 'Contribution Margin' , `coverage_ratio` int UNSIGNED NOT NULL default '0' COMMENT 'Coverage Ratio' , PRIMARY KEY (`entity_id`), UNIQUE `UNQ_NMC_SUPPLIERPRICES_MATRIS_PRICE_FROM_PRICE_TO` (`price_from`, `price_to`) ) COMMENT='nmc_supplierprices_matris' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci [1] => Array ( ) ) ) [5] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/lib/Varien/Db/Adapter/Pdo/Mysql.php [line] => 2117 [function] => query [class] => Varien_Db_Adapter_Pdo_Mysql [type] => -> [args] => Array ( [0] => CREATE TABLE `nmc_supplierprices_matris` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `price_from` decimal(12,2) NOT NULL default '0.00' COMMENT 'Price From' , `price_to` decimal(12,2) NOT NULL default '0.00' COMMENT 'Price To' , `contribution_margin` decimal(12,2) NOT NULL default '0.00' COMMENT 'Contribution Margin' , `coverage_ratio` int UNSIGNED NOT NULL default '0' COMMENT 'Coverage Ratio' , PRIMARY KEY (`entity_id`), UNIQUE `UNQ_NMC_SUPPLIERPRICES_MATRIS_PRICE_FROM_PRICE_TO` (`price_from`, `price_to`) ) COMMENT='nmc_supplierprices_matris' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci ) ) [6] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/code/community/Nmc/Supplierprices/sql/matris/mysql4-upgrade-1.0.5-1.0.6.php [line] => 34 [function] => createTable [class] => Varien_Db_Adapter_Pdo_Mysql [type] => -> [args] => Array ( [0] => Varien_Db_Ddl_Table Object ( [_tableName:protected] => nmc_supplierprices_matris [_schemaName:protected] => [_tableComment:protected] => nmc_supplierprices_matris [_columns:protected] => Array ( [ENTITY_ID] => Array ( [COLUMN_NAME] => entity_id [COLUMN_TYPE] => integer [COLUMN_POSITION] => 0 [DATA_TYPE] => integer [DEFAULT] => [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => 1 [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Entity ID ) [PRICE_FROM] => Array ( [COLUMN_NAME] => price_from [COLUMN_TYPE] => decimal [COLUMN_POSITION] => 1 [DATA_TYPE] => decimal [DEFAULT] => 0.00 [NULLABLE] => [LENGTH] => [SCALE] => 2 [PRECISION] => 12 [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Price From ) [PRICE_TO] => Array ( [COLUMN_NAME] => price_to [COLUMN_TYPE] => decimal [COLUMN_POSITION] => 2 [DATA_TYPE] => decimal [DEFAULT] => 0.00 [NULLABLE] => [LENGTH] => [SCALE] => 2 [PRECISION] => 12 [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Price To ) [CONTRIBUTION_MARGIN] => Array ( [COLUMN_NAME] => contribution_margin [COLUMN_TYPE] => decimal [COLUMN_POSITION] => 3 [DATA_TYPE] => decimal [DEFAULT] => 0.00 [NULLABLE] => [LENGTH] => [SCALE] => 2 [PRECISION] => 12 [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Contribution Margin ) [COVERAGE_RATIO] => Array ( [COLUMN_NAME] => coverage_ratio [COLUMN_TYPE] => integer [COLUMN_POSITION] => 4 [DATA_TYPE] => integer [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Coverage Ratio ) ) [_indexes:protected] => Array ( [UNQ_NMC_SUPPLIERPRICES_MATRIS_PRICE_FROM_PRICE_TO] => Array ( [INDEX_NAME] => UNQ_NMC_SUPPLIERPRICES_MATRIS_PRICE_FROM_PRICE_TO [COLUMNS] => Array ( [PRICE_FROM] => Array ( [NAME] => price_from [SIZE] => [POSITION] => 0 ) [PRICE_TO] => Array ( [NAME] => price_to [SIZE] => [POSITION] => 1 ) ) [TYPE] => unique ) ) [_foreignKeys:protected] => Array ( ) [_options:protected] => Array ( [type] => INNODB [charset] => utf8 [collate] => utf8_general_ci ) ) ) ) [7] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 624 [args] => Array ( [0] => /var/www/live.nordicmotorcenter.se/public/app/code/community/Nmc/Supplierprices/sql/matris/mysql4-upgrade-1.0.5-1.0.6.php ) [function] => include ) [8] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 422 [function] => _modifyResourceDb [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( [0] => upgrade [1] => [2] => 1.0.6 ) ) [9] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 327 [function] => _installResourceDb [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( [0] => 1.0.6 ) ) [10] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 235 [function] => applyUpdates [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( ) ) [11] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/code/local/Mage/Core/Model/App.php [line] => 471 [function] => applyAllUpdates [class] => Mage_Core_Model_Resource_Setup [type] => :: [args] => Array ( ) ) [12] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/code/local/Mage/Core/Model/App.php [line] => 343 [function] => _initModules [class] => Mage_Core_Model_App [type] => -> [args] => Array ( ) ) [13] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/Mage.php [line] => 685 [function] => run [class] => Mage_Core_Model_App [type] => -> [args] => Array ( [0] => Array ( [scope_code] => default_com [scope_type] => store [options] => Array ( ) ) ) ) [14] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/index.php [line] => 92 [function] => run [class] => Mage [type] => :: [args] => Array ( [0] => default_com [1] => store ) ) ) [previous:Exception:private] => PDOException Object ( [message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'nmc_supplierprices_matris' already exists [string:Exception:private] => [code:protected] => 42S01 [file:protected] => /var/www/live.nordicmotorcenter.se/public/lib/Zend/Db/Statement/Pdo.php [line:protected] => 228 [trace:Exception:private] => Array ( [0] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/lib/Zend/Db/Statement/Pdo.php [line] => 228 [function] => execute [class] => PDOStatement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [1] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/lib/Varien/Db/Statement/Pdo/Mysql.php [line] => 110 [function] => _execute [class] => Zend_Db_Statement_Pdo [type] => -> [args] => Array ( [0] => Array ( ) ) ) [2] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/code/core/Zend/Db/Statement.php [line] => 291 [function] => _execute [class] => Varien_Db_Statement_Pdo_Mysql [type] => -> [args] => Array ( [0] => Array ( ) ) ) [3] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/lib/Zend/Db/Adapter/Abstract.php [line] => 480 [function] => execute [class] => Zend_Db_Statement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [4] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/lib/Zend/Db/Adapter/Pdo/Abstract.php [line] => 238 [function] => query [class] => Zend_Db_Adapter_Abstract [type] => -> [args] => Array ( [0] => CREATE TABLE `nmc_supplierprices_matris` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `price_from` decimal(12,2) NOT NULL default '0.00' COMMENT 'Price From' , `price_to` decimal(12,2) NOT NULL default '0.00' COMMENT 'Price To' , `contribution_margin` decimal(12,2) NOT NULL default '0.00' COMMENT 'Contribution Margin' , `coverage_ratio` int UNSIGNED NOT NULL default '0' COMMENT 'Coverage Ratio' , PRIMARY KEY (`entity_id`), UNIQUE `UNQ_NMC_SUPPLIERPRICES_MATRIS_PRICE_FROM_PRICE_TO` (`price_from`, `price_to`) ) COMMENT='nmc_supplierprices_matris' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci [1] => Array ( ) ) ) [5] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/lib/Varien/Db/Adapter/Pdo/Mysql.php [line] => 428 [function] => query [class] => Zend_Db_Adapter_Pdo_Abstract [type] => -> [args] => Array ( [0] => CREATE TABLE `nmc_supplierprices_matris` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `price_from` decimal(12,2) NOT NULL default '0.00' COMMENT 'Price From' , `price_to` decimal(12,2) NOT NULL default '0.00' COMMENT 'Price To' , `contribution_margin` decimal(12,2) NOT NULL default '0.00' COMMENT 'Contribution Margin' , `coverage_ratio` int UNSIGNED NOT NULL default '0' COMMENT 'Coverage Ratio' , PRIMARY KEY (`entity_id`), UNIQUE `UNQ_NMC_SUPPLIERPRICES_MATRIS_PRICE_FROM_PRICE_TO` (`price_from`, `price_to`) ) COMMENT='nmc_supplierprices_matris' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci [1] => Array ( ) ) ) [6] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/lib/Varien/Db/Adapter/Pdo/Mysql.php [line] => 2117 [function] => query [class] => Varien_Db_Adapter_Pdo_Mysql [type] => -> [args] => Array ( [0] => CREATE TABLE `nmc_supplierprices_matris` ( `entity_id` int UNSIGNED NOT NULL COMMENT 'Entity ID' , `price_from` decimal(12,2) NOT NULL default '0.00' COMMENT 'Price From' , `price_to` decimal(12,2) NOT NULL default '0.00' COMMENT 'Price To' , `contribution_margin` decimal(12,2) NOT NULL default '0.00' COMMENT 'Contribution Margin' , `coverage_ratio` int UNSIGNED NOT NULL default '0' COMMENT 'Coverage Ratio' , PRIMARY KEY (`entity_id`), UNIQUE `UNQ_NMC_SUPPLIERPRICES_MATRIS_PRICE_FROM_PRICE_TO` (`price_from`, `price_to`) ) COMMENT='nmc_supplierprices_matris' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci ) ) [7] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/code/community/Nmc/Supplierprices/sql/matris/mysql4-upgrade-1.0.5-1.0.6.php [line] => 34 [function] => createTable [class] => Varien_Db_Adapter_Pdo_Mysql [type] => -> [args] => Array ( [0] => Varien_Db_Ddl_Table Object ( [_tableName:protected] => nmc_supplierprices_matris [_schemaName:protected] => [_tableComment:protected] => nmc_supplierprices_matris [_columns:protected] => Array ( [ENTITY_ID] => Array ( [COLUMN_NAME] => entity_id [COLUMN_TYPE] => integer [COLUMN_POSITION] => 0 [DATA_TYPE] => integer [DEFAULT] => [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => 1 [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Entity ID ) [PRICE_FROM] => Array ( [COLUMN_NAME] => price_from [COLUMN_TYPE] => decimal [COLUMN_POSITION] => 1 [DATA_TYPE] => decimal [DEFAULT] => 0.00 [NULLABLE] => [LENGTH] => [SCALE] => 2 [PRECISION] => 12 [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Price From ) [PRICE_TO] => Array ( [COLUMN_NAME] => price_to [COLUMN_TYPE] => decimal [COLUMN_POSITION] => 2 [DATA_TYPE] => decimal [DEFAULT] => 0.00 [NULLABLE] => [LENGTH] => [SCALE] => 2 [PRECISION] => 12 [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Price To ) [CONTRIBUTION_MARGIN] => Array ( [COLUMN_NAME] => contribution_margin [COLUMN_TYPE] => decimal [COLUMN_POSITION] => 3 [DATA_TYPE] => decimal [DEFAULT] => 0.00 [NULLABLE] => [LENGTH] => [SCALE] => 2 [PRECISION] => 12 [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Contribution Margin ) [COVERAGE_RATIO] => Array ( [COLUMN_NAME] => coverage_ratio [COLUMN_TYPE] => integer [COLUMN_POSITION] => 4 [DATA_TYPE] => integer [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Coverage Ratio ) ) [_indexes:protected] => Array ( [UNQ_NMC_SUPPLIERPRICES_MATRIS_PRICE_FROM_PRICE_TO] => Array ( [INDEX_NAME] => UNQ_NMC_SUPPLIERPRICES_MATRIS_PRICE_FROM_PRICE_TO [COLUMNS] => Array ( [PRICE_FROM] => Array ( [NAME] => price_from [SIZE] => [POSITION] => 0 ) [PRICE_TO] => Array ( [NAME] => price_to [SIZE] => [POSITION] => 1 ) ) [TYPE] => unique ) ) [_foreignKeys:protected] => Array ( ) [_options:protected] => Array ( [type] => INNODB [charset] => utf8 [collate] => utf8_general_ci ) ) ) ) [8] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 624 [args] => Array ( [0] => /var/www/live.nordicmotorcenter.se/public/app/code/community/Nmc/Supplierprices/sql/matris/mysql4-upgrade-1.0.5-1.0.6.php ) [function] => include ) [9] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 422 [function] => _modifyResourceDb [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( [0] => upgrade [1] => [2] => 1.0.6 ) ) [10] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 327 [function] => _installResourceDb [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( [0] => 1.0.6 ) ) [11] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 235 [function] => applyUpdates [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( ) ) [12] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/code/local/Mage/Core/Model/App.php [line] => 471 [function] => applyAllUpdates [class] => Mage_Core_Model_Resource_Setup [type] => :: [args] => Array ( ) ) [13] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/code/local/Mage/Core/Model/App.php [line] => 343 [function] => _initModules [class] => Mage_Core_Model_App [type] => -> [args] => Array ( ) ) [14] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/app/Mage.php [line] => 685 [function] => run [class] => Mage_Core_Model_App [type] => -> [args] => Array ( [0] => Array ( [scope_code] => default_com [scope_type] => store [options] => Array ( ) ) ) ) [15] => Array ( [file] => /var/www/live.nordicmotorcenter.se/public/index.php [line] => 92 [function] => run [class] => Mage [type] => :: [args] => Array ( [0] => default_com [1] => store ) ) ) [previous:Exception:private] => [errorInfo] => Array ( [0] => 42S01 [1] => 1050 [2] => Table 'nmc_supplierprices_matris' already exists ) ) )