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
)
)
)