Zend_Db_Statement_Exception Object ( [_previous:Zend_Exception:private] => [message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'catalog_product_entity_group_price' already exists [string:Exception:private] => [code:protected] => 42 [file:protected] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Statement/Pdo.php [line:protected] => 234 [trace:Exception:private] => Array ( [0] => Array ( [file] => /www/wwwroot/kiwilighting.com/lib/Varien/Db/Statement/Pdo/Mysql.php [line] => 110 [function] => _execute [class] => Zend_Db_Statement_Pdo [type] => -> [args] => Array ( [0] => Array ( ) ) ) [1] => Array ( [file] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Adapter/Abstract.php [line] => 479 [function] => execute [class] => Zend_Db_Statement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [3] => Array ( [file] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Adapter/Pdo/Abstract.php [line] => 238 [function] => query [class] => Zend_Db_Adapter_Abstract [type] => -> [args] => Array ( [0] => CREATE TABLE `catalog_product_entity_group_price` ( `value_id` int NOT NULL auto_increment COMMENT 'Value ID', `entity_id` int UNSIGNED NOT NULL default '0' COMMENT 'Entity ID', `all_groups` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Applicable To All Customer Groups', `customer_group_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Customer Group ID', `value` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Value', `website_id` smallint UNSIGNED NOT NULL COMMENT 'Website ID', PRIMARY KEY (`value_id`), UNIQUE `CC12C83765B562314470A24F2BDD0F36` (`entity_id`, `all_groups`, `customer_group_id`, `website_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_ENTITY_ID` (`entity_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_WEBSITE_ID` (`website_id`), CONSTRAINT `FK_DF909D22C11B60B1E5E3EE64AB220ECE` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_CAT_PRD_ENTT_GROUP_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_CAT_PRD_ENTT_GROUP_PRICE_WS_ID_CORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE ) COMMENT='Catalog Product Group Price Attribute Backend Table' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci [1] => Array ( ) ) ) [4] => Array ( [file] => /www/wwwroot/kiwilighting.com/lib/Varien/Db/Adapter/Pdo/Mysql.php [line] => 428 [function] => query [class] => Zend_Db_Adapter_Pdo_Abstract [type] => -> [args] => Array ( [0] => CREATE TABLE `catalog_product_entity_group_price` ( `value_id` int NOT NULL auto_increment COMMENT 'Value ID', `entity_id` int UNSIGNED NOT NULL default '0' COMMENT 'Entity ID', `all_groups` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Applicable To All Customer Groups', `customer_group_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Customer Group ID', `value` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Value', `website_id` smallint UNSIGNED NOT NULL COMMENT 'Website ID', PRIMARY KEY (`value_id`), UNIQUE `CC12C83765B562314470A24F2BDD0F36` (`entity_id`, `all_groups`, `customer_group_id`, `website_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_ENTITY_ID` (`entity_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_WEBSITE_ID` (`website_id`), CONSTRAINT `FK_DF909D22C11B60B1E5E3EE64AB220ECE` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_CAT_PRD_ENTT_GROUP_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_CAT_PRD_ENTT_GROUP_PRICE_WS_ID_CORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE ) COMMENT='Catalog Product Group Price Attribute Backend Table' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci [1] => Array ( ) ) ) [5] => Array ( [file] => /www/wwwroot/kiwilighting.com/lib/Varien/Db/Adapter/Pdo/Mysql.php [line] => 2048 [function] => query [class] => Varien_Db_Adapter_Pdo_Mysql [type] => -> [args] => Array ( [0] => CREATE TABLE `catalog_product_entity_group_price` ( `value_id` int NOT NULL auto_increment COMMENT 'Value ID', `entity_id` int UNSIGNED NOT NULL default '0' COMMENT 'Entity ID', `all_groups` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Applicable To All Customer Groups', `customer_group_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Customer Group ID', `value` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Value', `website_id` smallint UNSIGNED NOT NULL COMMENT 'Website ID', PRIMARY KEY (`value_id`), UNIQUE `CC12C83765B562314470A24F2BDD0F36` (`entity_id`, `all_groups`, `customer_group_id`, `website_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_ENTITY_ID` (`entity_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_WEBSITE_ID` (`website_id`), CONSTRAINT `FK_DF909D22C11B60B1E5E3EE64AB220ECE` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_CAT_PRD_ENTT_GROUP_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_CAT_PRD_ENTT_GROUP_PRICE_WS_ID_CORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE ) COMMENT='Catalog Product Group Price Attribute Backend Table' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci ) ) [6] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Catalog/sql/catalog_setup/upgrade-1.6.0.0.9-1.6.0.0.10.php [line] => 106 [function] => createTable [class] => Varien_Db_Adapter_Pdo_Mysql [type] => -> [args] => Array ( [0] => Varien_Db_Ddl_Table Object ( [_tableName:protected] => catalog_product_entity_group_price [_schemaName:protected] => [_tableComment:protected] => Catalog Product Group Price Attribute Backend Table [_columns:protected] => Array ( [VALUE_ID] => Array ( [COLUMN_NAME] => value_id [COLUMN_TYPE] => integer [COLUMN_POSITION] => 0 [DATA_TYPE] => integer [DEFAULT] => [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => 1 [PRIMARY_POSITION] => 0 [IDENTITY] => 1 [COMMENT] => Value ID ) [ENTITY_ID] => Array ( [COLUMN_NAME] => entity_id [COLUMN_TYPE] => integer [COLUMN_POSITION] => 1 [DATA_TYPE] => integer [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Entity ID ) [ALL_GROUPS] => Array ( [COLUMN_NAME] => all_groups [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 2 [DATA_TYPE] => smallint [DEFAULT] => 1 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Is Applicable To All Customer Groups ) [CUSTOMER_GROUP_ID] => Array ( [COLUMN_NAME] => customer_group_id [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 3 [DATA_TYPE] => smallint [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Customer Group ID ) [VALUE] => Array ( [COLUMN_NAME] => value [COLUMN_TYPE] => decimal [COLUMN_POSITION] => 4 [DATA_TYPE] => decimal [DEFAULT] => 0.0000 [NULLABLE] => [LENGTH] => [SCALE] => 4 [PRECISION] => 12 [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Value ) [WEBSITE_ID] => Array ( [COLUMN_NAME] => website_id [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 5 [DATA_TYPE] => smallint [DEFAULT] => [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Website ID ) ) [_indexes:protected] => Array ( [CC12C83765B562314470A24F2BDD0F36] => Array ( [INDEX_NAME] => CC12C83765B562314470A24F2BDD0F36 [COLUMNS] => Array ( [ENTITY_ID] => Array ( [NAME] => entity_id [SIZE] => [POSITION] => 0 ) [ALL_GROUPS] => Array ( [NAME] => all_groups [SIZE] => [POSITION] => 1 ) [CUSTOMER_GROUP_ID] => Array ( [NAME] => customer_group_id [SIZE] => [POSITION] => 2 ) [WEBSITE_ID] => Array ( [NAME] => website_id [SIZE] => [POSITION] => 3 ) ) [TYPE] => unique ) [IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_ENTITY_ID] => Array ( [INDEX_NAME] => IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_ENTITY_ID [COLUMNS] => Array ( [ENTITY_ID] => Array ( [NAME] => entity_id [SIZE] => [POSITION] => 0 ) ) [TYPE] => index ) [IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_CUSTOMER_GROUP_ID] => Array ( [INDEX_NAME] => IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_CUSTOMER_GROUP_ID [COLUMNS] => Array ( [CUSTOMER_GROUP_ID] => Array ( [NAME] => customer_group_id [SIZE] => [POSITION] => 0 ) ) [TYPE] => index ) [IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_WEBSITE_ID] => Array ( [INDEX_NAME] => IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_WEBSITE_ID [COLUMNS] => Array ( [WEBSITE_ID] => Array ( [NAME] => website_id [SIZE] => [POSITION] => 0 ) ) [TYPE] => index ) ) [_foreignKeys:protected] => Array ( [FK_DF909D22C11B60B1E5E3EE64AB220ECE] => Array ( [FK_NAME] => FK_DF909D22C11B60B1E5E3EE64AB220ECE [COLUMN_NAME] => customer_group_id [REF_TABLE_NAME] => customer_group [REF_COLUMN_NAME] => customer_group_id [ON_DELETE] => CASCADE [ON_UPDATE] => CASCADE ) [FK_CAT_PRD_ENTT_GROUP_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID] => Array ( [FK_NAME] => FK_CAT_PRD_ENTT_GROUP_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID [COLUMN_NAME] => entity_id [REF_TABLE_NAME] => catalog_product_entity [REF_COLUMN_NAME] => entity_id [ON_DELETE] => CASCADE [ON_UPDATE] => CASCADE ) [FK_CAT_PRD_ENTT_GROUP_PRICE_WS_ID_CORE_WS_WS_ID] => Array ( [FK_NAME] => FK_CAT_PRD_ENTT_GROUP_PRICE_WS_ID_CORE_WS_WS_ID [COLUMN_NAME] => website_id [REF_TABLE_NAME] => core_website [REF_COLUMN_NAME] => website_id [ON_DELETE] => CASCADE [ON_UPDATE] => CASCADE ) ) [_options:protected] => Array ( [type] => INNODB [charset] => utf8 [collate] => utf8_general_ci ) ) ) ) [7] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 624 [args] => Array ( [0] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Catalog/sql/catalog_setup/upgrade-1.6.0.0.9-1.6.0.0.10.php ) [function] => include ) [8] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 437 [function] => _modifyResourceDb [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( [0] => upgrade [1] => 1.6.0.0.9 [2] => 1.6.0.0.18 ) ) [9] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 320 [function] => _upgradeResourceDb [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( [0] => 1.6.0.0.9 [1] => 1.6.0.0.18 ) ) [10] => Array ( [file] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/App.php [line] => 417 [function] => applyAllUpdates [class] => Mage_Core_Model_Resource_Setup [type] => :: [args] => Array ( ) ) [12] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/App.php [line] => 343 [function] => _initModules [class] => Mage_Core_Model_App [type] => -> [args] => Array ( ) ) [13] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/Mage.php [line] => 683 [function] => run [class] => Mage_Core_Model_App [type] => -> [args] => Array ( [0] => Array ( [scope_code] => [scope_type] => store [options] => Array ( ) ) ) ) [14] => Array ( [file] => /www/wwwroot/kiwilighting.com/index.php [line] => 87 [function] => run [class] => Mage [type] => :: [args] => Array ( [0] => [1] => store ) ) ) [previous:Exception:private] => PDOException Object ( [message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'catalog_product_entity_group_price' already exists [string:Exception:private] => [code:protected] => 42S01 [file:protected] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Statement/Pdo.php [line:protected] => 228 [trace:Exception:private] => Array ( [0] => Array ( [file] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Statement/Pdo.php [line] => 228 [function] => execute [class] => PDOStatement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [1] => Array ( [file] => /www/wwwroot/kiwilighting.com/lib/Varien/Db/Statement/Pdo/Mysql.php [line] => 110 [function] => _execute [class] => Zend_Db_Statement_Pdo [type] => -> [args] => Array ( [0] => Array ( ) ) ) [2] => Array ( [file] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Adapter/Abstract.php [line] => 479 [function] => execute [class] => Zend_Db_Statement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [4] => Array ( [file] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Adapter/Pdo/Abstract.php [line] => 238 [function] => query [class] => Zend_Db_Adapter_Abstract [type] => -> [args] => Array ( [0] => CREATE TABLE `catalog_product_entity_group_price` ( `value_id` int NOT NULL auto_increment COMMENT 'Value ID', `entity_id` int UNSIGNED NOT NULL default '0' COMMENT 'Entity ID', `all_groups` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Applicable To All Customer Groups', `customer_group_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Customer Group ID', `value` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Value', `website_id` smallint UNSIGNED NOT NULL COMMENT 'Website ID', PRIMARY KEY (`value_id`), UNIQUE `CC12C83765B562314470A24F2BDD0F36` (`entity_id`, `all_groups`, `customer_group_id`, `website_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_ENTITY_ID` (`entity_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_WEBSITE_ID` (`website_id`), CONSTRAINT `FK_DF909D22C11B60B1E5E3EE64AB220ECE` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_CAT_PRD_ENTT_GROUP_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_CAT_PRD_ENTT_GROUP_PRICE_WS_ID_CORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE ) COMMENT='Catalog Product Group Price Attribute Backend Table' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci [1] => Array ( ) ) ) [5] => Array ( [file] => /www/wwwroot/kiwilighting.com/lib/Varien/Db/Adapter/Pdo/Mysql.php [line] => 428 [function] => query [class] => Zend_Db_Adapter_Pdo_Abstract [type] => -> [args] => Array ( [0] => CREATE TABLE `catalog_product_entity_group_price` ( `value_id` int NOT NULL auto_increment COMMENT 'Value ID', `entity_id` int UNSIGNED NOT NULL default '0' COMMENT 'Entity ID', `all_groups` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Applicable To All Customer Groups', `customer_group_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Customer Group ID', `value` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Value', `website_id` smallint UNSIGNED NOT NULL COMMENT 'Website ID', PRIMARY KEY (`value_id`), UNIQUE `CC12C83765B562314470A24F2BDD0F36` (`entity_id`, `all_groups`, `customer_group_id`, `website_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_ENTITY_ID` (`entity_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_WEBSITE_ID` (`website_id`), CONSTRAINT `FK_DF909D22C11B60B1E5E3EE64AB220ECE` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_CAT_PRD_ENTT_GROUP_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_CAT_PRD_ENTT_GROUP_PRICE_WS_ID_CORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE ) COMMENT='Catalog Product Group Price Attribute Backend Table' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci [1] => Array ( ) ) ) [6] => Array ( [file] => /www/wwwroot/kiwilighting.com/lib/Varien/Db/Adapter/Pdo/Mysql.php [line] => 2048 [function] => query [class] => Varien_Db_Adapter_Pdo_Mysql [type] => -> [args] => Array ( [0] => CREATE TABLE `catalog_product_entity_group_price` ( `value_id` int NOT NULL auto_increment COMMENT 'Value ID', `entity_id` int UNSIGNED NOT NULL default '0' COMMENT 'Entity ID', `all_groups` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Applicable To All Customer Groups', `customer_group_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Customer Group ID', `value` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Value', `website_id` smallint UNSIGNED NOT NULL COMMENT 'Website ID', PRIMARY KEY (`value_id`), UNIQUE `CC12C83765B562314470A24F2BDD0F36` (`entity_id`, `all_groups`, `customer_group_id`, `website_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_ENTITY_ID` (`entity_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`), INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_WEBSITE_ID` (`website_id`), CONSTRAINT `FK_DF909D22C11B60B1E5E3EE64AB220ECE` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_CAT_PRD_ENTT_GROUP_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_CAT_PRD_ENTT_GROUP_PRICE_WS_ID_CORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE ) COMMENT='Catalog Product Group Price Attribute Backend Table' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci ) ) [7] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Catalog/sql/catalog_setup/upgrade-1.6.0.0.9-1.6.0.0.10.php [line] => 106 [function] => createTable [class] => Varien_Db_Adapter_Pdo_Mysql [type] => -> [args] => Array ( [0] => Varien_Db_Ddl_Table Object ( [_tableName:protected] => catalog_product_entity_group_price [_schemaName:protected] => [_tableComment:protected] => Catalog Product Group Price Attribute Backend Table [_columns:protected] => Array ( [VALUE_ID] => Array ( [COLUMN_NAME] => value_id [COLUMN_TYPE] => integer [COLUMN_POSITION] => 0 [DATA_TYPE] => integer [DEFAULT] => [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => 1 [PRIMARY_POSITION] => 0 [IDENTITY] => 1 [COMMENT] => Value ID ) [ENTITY_ID] => Array ( [COLUMN_NAME] => entity_id [COLUMN_TYPE] => integer [COLUMN_POSITION] => 1 [DATA_TYPE] => integer [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Entity ID ) [ALL_GROUPS] => Array ( [COLUMN_NAME] => all_groups [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 2 [DATA_TYPE] => smallint [DEFAULT] => 1 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Is Applicable To All Customer Groups ) [CUSTOMER_GROUP_ID] => Array ( [COLUMN_NAME] => customer_group_id [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 3 [DATA_TYPE] => smallint [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Customer Group ID ) [VALUE] => Array ( [COLUMN_NAME] => value [COLUMN_TYPE] => decimal [COLUMN_POSITION] => 4 [DATA_TYPE] => decimal [DEFAULT] => 0.0000 [NULLABLE] => [LENGTH] => [SCALE] => 4 [PRECISION] => 12 [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Value ) [WEBSITE_ID] => Array ( [COLUMN_NAME] => website_id [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 5 [DATA_TYPE] => smallint [DEFAULT] => [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Website ID ) ) [_indexes:protected] => Array ( [CC12C83765B562314470A24F2BDD0F36] => Array ( [INDEX_NAME] => CC12C83765B562314470A24F2BDD0F36 [COLUMNS] => Array ( [ENTITY_ID] => Array ( [NAME] => entity_id [SIZE] => [POSITION] => 0 ) [ALL_GROUPS] => Array ( [NAME] => all_groups [SIZE] => [POSITION] => 1 ) [CUSTOMER_GROUP_ID] => Array ( [NAME] => customer_group_id [SIZE] => [POSITION] => 2 ) [WEBSITE_ID] => Array ( [NAME] => website_id [SIZE] => [POSITION] => 3 ) ) [TYPE] => unique ) [IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_ENTITY_ID] => Array ( [INDEX_NAME] => IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_ENTITY_ID [COLUMNS] => Array ( [ENTITY_ID] => Array ( [NAME] => entity_id [SIZE] => [POSITION] => 0 ) ) [TYPE] => index ) [IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_CUSTOMER_GROUP_ID] => Array ( [INDEX_NAME] => IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_CUSTOMER_GROUP_ID [COLUMNS] => Array ( [CUSTOMER_GROUP_ID] => Array ( [NAME] => customer_group_id [SIZE] => [POSITION] => 0 ) ) [TYPE] => index ) [IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_WEBSITE_ID] => Array ( [INDEX_NAME] => IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_WEBSITE_ID [COLUMNS] => Array ( [WEBSITE_ID] => Array ( [NAME] => website_id [SIZE] => [POSITION] => 0 ) ) [TYPE] => index ) ) [_foreignKeys:protected] => Array ( [FK_DF909D22C11B60B1E5E3EE64AB220ECE] => Array ( [FK_NAME] => FK_DF909D22C11B60B1E5E3EE64AB220ECE [COLUMN_NAME] => customer_group_id [REF_TABLE_NAME] => customer_group [REF_COLUMN_NAME] => customer_group_id [ON_DELETE] => CASCADE [ON_UPDATE] => CASCADE ) [FK_CAT_PRD_ENTT_GROUP_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID] => Array ( [FK_NAME] => FK_CAT_PRD_ENTT_GROUP_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID [COLUMN_NAME] => entity_id [REF_TABLE_NAME] => catalog_product_entity [REF_COLUMN_NAME] => entity_id [ON_DELETE] => CASCADE [ON_UPDATE] => CASCADE ) [FK_CAT_PRD_ENTT_GROUP_PRICE_WS_ID_CORE_WS_WS_ID] => Array ( [FK_NAME] => FK_CAT_PRD_ENTT_GROUP_PRICE_WS_ID_CORE_WS_WS_ID [COLUMN_NAME] => website_id [REF_TABLE_NAME] => core_website [REF_COLUMN_NAME] => website_id [ON_DELETE] => CASCADE [ON_UPDATE] => CASCADE ) ) [_options:protected] => Array ( [type] => INNODB [charset] => utf8 [collate] => utf8_general_ci ) ) ) ) [8] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 624 [args] => Array ( [0] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Catalog/sql/catalog_setup/upgrade-1.6.0.0.9-1.6.0.0.10.php ) [function] => include ) [9] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 437 [function] => _modifyResourceDb [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( [0] => upgrade [1] => 1.6.0.0.9 [2] => 1.6.0.0.18 ) ) [10] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 320 [function] => _upgradeResourceDb [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( [0] => 1.6.0.0.9 [1] => 1.6.0.0.18 ) ) [11] => Array ( [file] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/App.php [line] => 417 [function] => applyAllUpdates [class] => Mage_Core_Model_Resource_Setup [type] => :: [args] => Array ( ) ) [13] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/App.php [line] => 343 [function] => _initModules [class] => Mage_Core_Model_App [type] => -> [args] => Array ( ) ) [14] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/Mage.php [line] => 683 [function] => run [class] => Mage_Core_Model_App [type] => -> [args] => Array ( [0] => Array ( [scope_code] => [scope_type] => store [options] => Array ( ) ) ) ) [15] => Array ( [file] => /www/wwwroot/kiwilighting.com/index.php [line] => 87 [function] => run [class] => Mage [type] => :: [args] => Array ( [0] => [1] => store ) ) ) [previous:Exception:private] => [errorInfo] => Array ( [0] => 42S01 [1] => 1050 [2] => Table 'catalog_product_entity_group_price' already exists ) ) )