Zend_Db_Statement_Exception Object ( [_previous:Zend_Exception:private] => [message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'googleshopping_types' 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 `googleshopping_types` ( `type_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Type ID', `attribute_set_id` smallint UNSIGNED NOT NULL COMMENT 'Attribute Set Id', `target_country` varchar(2) NOT NULL default 'US' COMMENT 'Target country', PRIMARY KEY (`type_id`), UNIQUE `UNQ_GOOGLESHOPPING_TYPES_ATTRIBUTE_SET_ID_TARGET_COUNTRY` (`attribute_set_id`, `target_country`), CONSTRAINT `FK_GOOGLESHOPPING_TYPES_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) ON DELETE CASCADE ON UPDATE NO ACTION ) COMMENT='Google Content Item Types link Attribute Sets' 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 `googleshopping_types` ( `type_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Type ID', `attribute_set_id` smallint UNSIGNED NOT NULL COMMENT 'Attribute Set Id', `target_country` varchar(2) NOT NULL default 'US' COMMENT 'Target country', PRIMARY KEY (`type_id`), UNIQUE `UNQ_GOOGLESHOPPING_TYPES_ATTRIBUTE_SET_ID_TARGET_COUNTRY` (`attribute_set_id`, `target_country`), CONSTRAINT `FK_GOOGLESHOPPING_TYPES_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) ON DELETE CASCADE ON UPDATE NO ACTION ) COMMENT='Google Content Item Types link Attribute Sets' 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 `googleshopping_types` ( `type_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Type ID', `attribute_set_id` smallint UNSIGNED NOT NULL COMMENT 'Attribute Set Id', `target_country` varchar(2) NOT NULL default 'US' COMMENT 'Target country', PRIMARY KEY (`type_id`), UNIQUE `UNQ_GOOGLESHOPPING_TYPES_ATTRIBUTE_SET_ID_TARGET_COUNTRY` (`attribute_set_id`, `target_country`), CONSTRAINT `FK_GOOGLESHOPPING_TYPES_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) ON DELETE CASCADE ON UPDATE NO ACTION ) COMMENT='Google Content Item Types link Attribute Sets' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci ) ) [6] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/GoogleShopping/sql/googleshopping_setup/install-1.6.0.0.php [line] => 76 [function] => createTable [class] => Varien_Db_Adapter_Pdo_Mysql [type] => -> [args] => Array ( [0] => Varien_Db_Ddl_Table Object ( [_tableName:protected] => googleshopping_types [_schemaName:protected] => [_tableComment:protected] => Google Content Item Types link Attribute Sets [_columns:protected] => Array ( [TYPE_ID] => Array ( [COLUMN_NAME] => type_id [COLUMN_TYPE] => integer [COLUMN_POSITION] => 0 [DATA_TYPE] => integer [DEFAULT] => [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => 1 [PRIMARY_POSITION] => 0 [IDENTITY] => 1 [COMMENT] => Type ID ) [ATTRIBUTE_SET_ID] => Array ( [COLUMN_NAME] => attribute_set_id [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 1 [DATA_TYPE] => smallint [DEFAULT] => [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Attribute Set Id ) [TARGET_COUNTRY] => Array ( [COLUMN_NAME] => target_country [COLUMN_TYPE] => text [COLUMN_POSITION] => 2 [DATA_TYPE] => text [DEFAULT] => US [NULLABLE] => [LENGTH] => 2 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Target country ) ) [_indexes:protected] => Array ( [UNQ_GOOGLESHOPPING_TYPES_ATTRIBUTE_SET_ID_TARGET_COUNTRY] => Array ( [INDEX_NAME] => UNQ_GOOGLESHOPPING_TYPES_ATTRIBUTE_SET_ID_TARGET_COUNTRY [COLUMNS] => Array ( [ATTRIBUTE_SET_ID] => Array ( [NAME] => attribute_set_id [SIZE] => [POSITION] => 0 ) [TARGET_COUNTRY] => Array ( [NAME] => target_country [SIZE] => [POSITION] => 1 ) ) [TYPE] => unique ) ) [_foreignKeys:protected] => Array ( [FK_GOOGLESHOPPING_TYPES_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID] => Array ( [FK_NAME] => FK_GOOGLESHOPPING_TYPES_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID [COLUMN_NAME] => attribute_set_id [REF_TABLE_NAME] => eav_attribute_set [REF_COLUMN_NAME] => attribute_set_id [ON_DELETE] => CASCADE [ON_UPDATE] => NO ACTION ) ) [_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/GoogleShopping/sql/googleshopping_setup/install-1.6.0.0.php ) [function] => include ) [8] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 421 [function] => _modifyResourceDb [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( [0] => install [1] => [2] => 1.6.0.0.1 ) ) [9] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 327 [function] => _installResourceDb [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( [0] => 1.6.0.0.1 ) ) [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 'googleshopping_types' 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 `googleshopping_types` ( `type_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Type ID', `attribute_set_id` smallint UNSIGNED NOT NULL COMMENT 'Attribute Set Id', `target_country` varchar(2) NOT NULL default 'US' COMMENT 'Target country', PRIMARY KEY (`type_id`), UNIQUE `UNQ_GOOGLESHOPPING_TYPES_ATTRIBUTE_SET_ID_TARGET_COUNTRY` (`attribute_set_id`, `target_country`), CONSTRAINT `FK_GOOGLESHOPPING_TYPES_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) ON DELETE CASCADE ON UPDATE NO ACTION ) COMMENT='Google Content Item Types link Attribute Sets' 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 `googleshopping_types` ( `type_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Type ID', `attribute_set_id` smallint UNSIGNED NOT NULL COMMENT 'Attribute Set Id', `target_country` varchar(2) NOT NULL default 'US' COMMENT 'Target country', PRIMARY KEY (`type_id`), UNIQUE `UNQ_GOOGLESHOPPING_TYPES_ATTRIBUTE_SET_ID_TARGET_COUNTRY` (`attribute_set_id`, `target_country`), CONSTRAINT `FK_GOOGLESHOPPING_TYPES_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) ON DELETE CASCADE ON UPDATE NO ACTION ) COMMENT='Google Content Item Types link Attribute Sets' 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 `googleshopping_types` ( `type_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Type ID', `attribute_set_id` smallint UNSIGNED NOT NULL COMMENT 'Attribute Set Id', `target_country` varchar(2) NOT NULL default 'US' COMMENT 'Target country', PRIMARY KEY (`type_id`), UNIQUE `UNQ_GOOGLESHOPPING_TYPES_ATTRIBUTE_SET_ID_TARGET_COUNTRY` (`attribute_set_id`, `target_country`), CONSTRAINT `FK_GOOGLESHOPPING_TYPES_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `eav_attribute_set` (`attribute_set_id`) ON DELETE CASCADE ON UPDATE NO ACTION ) COMMENT='Google Content Item Types link Attribute Sets' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci ) ) [7] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/GoogleShopping/sql/googleshopping_setup/install-1.6.0.0.php [line] => 76 [function] => createTable [class] => Varien_Db_Adapter_Pdo_Mysql [type] => -> [args] => Array ( [0] => Varien_Db_Ddl_Table Object ( [_tableName:protected] => googleshopping_types [_schemaName:protected] => [_tableComment:protected] => Google Content Item Types link Attribute Sets [_columns:protected] => Array ( [TYPE_ID] => Array ( [COLUMN_NAME] => type_id [COLUMN_TYPE] => integer [COLUMN_POSITION] => 0 [DATA_TYPE] => integer [DEFAULT] => [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => 1 [PRIMARY_POSITION] => 0 [IDENTITY] => 1 [COMMENT] => Type ID ) [ATTRIBUTE_SET_ID] => Array ( [COLUMN_NAME] => attribute_set_id [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 1 [DATA_TYPE] => smallint [DEFAULT] => [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Attribute Set Id ) [TARGET_COUNTRY] => Array ( [COLUMN_NAME] => target_country [COLUMN_TYPE] => text [COLUMN_POSITION] => 2 [DATA_TYPE] => text [DEFAULT] => US [NULLABLE] => [LENGTH] => 2 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Target country ) ) [_indexes:protected] => Array ( [UNQ_GOOGLESHOPPING_TYPES_ATTRIBUTE_SET_ID_TARGET_COUNTRY] => Array ( [INDEX_NAME] => UNQ_GOOGLESHOPPING_TYPES_ATTRIBUTE_SET_ID_TARGET_COUNTRY [COLUMNS] => Array ( [ATTRIBUTE_SET_ID] => Array ( [NAME] => attribute_set_id [SIZE] => [POSITION] => 0 ) [TARGET_COUNTRY] => Array ( [NAME] => target_country [SIZE] => [POSITION] => 1 ) ) [TYPE] => unique ) ) [_foreignKeys:protected] => Array ( [FK_GOOGLESHOPPING_TYPES_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID] => Array ( [FK_NAME] => FK_GOOGLESHOPPING_TYPES_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID [COLUMN_NAME] => attribute_set_id [REF_TABLE_NAME] => eav_attribute_set [REF_COLUMN_NAME] => attribute_set_id [ON_DELETE] => CASCADE [ON_UPDATE] => NO ACTION ) ) [_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/GoogleShopping/sql/googleshopping_setup/install-1.6.0.0.php ) [function] => include ) [9] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 421 [function] => _modifyResourceDb [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( [0] => install [1] => [2] => 1.6.0.0.1 ) ) [10] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 327 [function] => _installResourceDb [class] => Mage_Core_Model_Resource_Setup [type] => -> [args] => Array ( [0] => 1.6.0.0.1 ) ) [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 'googleshopping_types' already exists ) ) )