Zend_Db_Statement_Exception Object ( [_previous:Zend_Exception:private] => [message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'salesrule' 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 `salesrule` ( `rule_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Rule Id', `name` varchar(255) NULL COMMENT 'Name', `description` text NULL COMMENT 'Description', `from_date` date NULL COMMENT 'From Date', `to_date` date NULL COMMENT 'To Date', `uses_per_customer` int NOT NULL default '0' COMMENT 'Uses Per Customer', `customer_group_ids` text NULL COMMENT 'Customer Group Ids', `is_active` smallint NOT NULL default '0' COMMENT 'Is Active', `conditions_serialized` mediumtext NULL COMMENT 'Conditions Serialized', `actions_serialized` mediumtext NULL COMMENT 'Actions Serialized', `stop_rules_processing` smallint NOT NULL default '1' COMMENT 'Stop Rules Processing', `is_advanced` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Advanced', `product_ids` text NULL COMMENT 'Product Ids', `sort_order` int UNSIGNED NOT NULL default '0' COMMENT 'Sort Order', `simple_action` varchar(32) NULL COMMENT 'Simple Action', `discount_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Discount Amount', `discount_qty` decimal(12,4) NULL COMMENT 'Discount Qty', `discount_step` int UNSIGNED NOT NULL COMMENT 'Discount Step', `simple_free_shipping` smallint UNSIGNED NOT NULL default '0' COMMENT 'Simple Free Shipping', `apply_to_shipping` smallint UNSIGNED NOT NULL default '0' COMMENT 'Apply To Shipping', `times_used` int UNSIGNED NOT NULL default '0' COMMENT 'Times Used', `is_rss` smallint NOT NULL default '0' COMMENT 'Is Rss', `website_ids` text NULL COMMENT 'Website Ids', `coupon_type` smallint UNSIGNED NOT NULL default '1' COMMENT 'Coupon Type', PRIMARY KEY (`rule_id`), INDEX `IDX_SALESRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE` (`is_active`, `sort_order`, `to_date`, `from_date`) ) COMMENT='Salesrule' 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 `salesrule` ( `rule_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Rule Id', `name` varchar(255) NULL COMMENT 'Name', `description` text NULL COMMENT 'Description', `from_date` date NULL COMMENT 'From Date', `to_date` date NULL COMMENT 'To Date', `uses_per_customer` int NOT NULL default '0' COMMENT 'Uses Per Customer', `customer_group_ids` text NULL COMMENT 'Customer Group Ids', `is_active` smallint NOT NULL default '0' COMMENT 'Is Active', `conditions_serialized` mediumtext NULL COMMENT 'Conditions Serialized', `actions_serialized` mediumtext NULL COMMENT 'Actions Serialized', `stop_rules_processing` smallint NOT NULL default '1' COMMENT 'Stop Rules Processing', `is_advanced` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Advanced', `product_ids` text NULL COMMENT 'Product Ids', `sort_order` int UNSIGNED NOT NULL default '0' COMMENT 'Sort Order', `simple_action` varchar(32) NULL COMMENT 'Simple Action', `discount_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Discount Amount', `discount_qty` decimal(12,4) NULL COMMENT 'Discount Qty', `discount_step` int UNSIGNED NOT NULL COMMENT 'Discount Step', `simple_free_shipping` smallint UNSIGNED NOT NULL default '0' COMMENT 'Simple Free Shipping', `apply_to_shipping` smallint UNSIGNED NOT NULL default '0' COMMENT 'Apply To Shipping', `times_used` int UNSIGNED NOT NULL default '0' COMMENT 'Times Used', `is_rss` smallint NOT NULL default '0' COMMENT 'Is Rss', `website_ids` text NULL COMMENT 'Website Ids', `coupon_type` smallint UNSIGNED NOT NULL default '1' COMMENT 'Coupon Type', PRIMARY KEY (`rule_id`), INDEX `IDX_SALESRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE` (`is_active`, `sort_order`, `to_date`, `from_date`) ) COMMENT='Salesrule' 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 `salesrule` ( `rule_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Rule Id', `name` varchar(255) NULL COMMENT 'Name', `description` text NULL COMMENT 'Description', `from_date` date NULL COMMENT 'From Date', `to_date` date NULL COMMENT 'To Date', `uses_per_customer` int NOT NULL default '0' COMMENT 'Uses Per Customer', `customer_group_ids` text NULL COMMENT 'Customer Group Ids', `is_active` smallint NOT NULL default '0' COMMENT 'Is Active', `conditions_serialized` mediumtext NULL COMMENT 'Conditions Serialized', `actions_serialized` mediumtext NULL COMMENT 'Actions Serialized', `stop_rules_processing` smallint NOT NULL default '1' COMMENT 'Stop Rules Processing', `is_advanced` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Advanced', `product_ids` text NULL COMMENT 'Product Ids', `sort_order` int UNSIGNED NOT NULL default '0' COMMENT 'Sort Order', `simple_action` varchar(32) NULL COMMENT 'Simple Action', `discount_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Discount Amount', `discount_qty` decimal(12,4) NULL COMMENT 'Discount Qty', `discount_step` int UNSIGNED NOT NULL COMMENT 'Discount Step', `simple_free_shipping` smallint UNSIGNED NOT NULL default '0' COMMENT 'Simple Free Shipping', `apply_to_shipping` smallint UNSIGNED NOT NULL default '0' COMMENT 'Apply To Shipping', `times_used` int UNSIGNED NOT NULL default '0' COMMENT 'Times Used', `is_rss` smallint NOT NULL default '0' COMMENT 'Is Rss', `website_ids` text NULL COMMENT 'Website Ids', `coupon_type` smallint UNSIGNED NOT NULL default '1' COMMENT 'Coupon Type', PRIMARY KEY (`rule_id`), INDEX `IDX_SALESRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE` (`is_active`, `sort_order`, `to_date`, `from_date`) ) COMMENT='Salesrule' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci ) ) [6] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/SalesRule/sql/salesrule_setup/install-1.6.0.0.php [line] => 121 [function] => createTable [class] => Varien_Db_Adapter_Pdo_Mysql [type] => -> [args] => Array ( [0] => Varien_Db_Ddl_Table Object ( [_tableName:protected] => salesrule [_schemaName:protected] => [_tableComment:protected] => Salesrule [_columns:protected] => Array ( [RULE_ID] => Array ( [COLUMN_NAME] => rule_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] => Rule Id ) [NAME] => Array ( [COLUMN_NAME] => name [COLUMN_TYPE] => text [COLUMN_POSITION] => 1 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 255 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Name ) [DESCRIPTION] => Array ( [COLUMN_NAME] => description [COLUMN_TYPE] => text [COLUMN_POSITION] => 2 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 64k [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Description ) [FROM_DATE] => Array ( [COLUMN_NAME] => from_date [COLUMN_TYPE] => date [COLUMN_POSITION] => 3 [DATA_TYPE] => date [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => From Date ) [TO_DATE] => Array ( [COLUMN_NAME] => to_date [COLUMN_TYPE] => date [COLUMN_POSITION] => 4 [DATA_TYPE] => date [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => To Date ) [USES_PER_CUSTOMER] => Array ( [COLUMN_NAME] => uses_per_customer [COLUMN_TYPE] => integer [COLUMN_POSITION] => 5 [DATA_TYPE] => integer [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Uses Per Customer ) [CUSTOMER_GROUP_IDS] => Array ( [COLUMN_NAME] => customer_group_ids [COLUMN_TYPE] => text [COLUMN_POSITION] => 6 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 64k [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Customer Group Ids ) [IS_ACTIVE] => Array ( [COLUMN_NAME] => is_active [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 7 [DATA_TYPE] => smallint [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Is Active ) [CONDITIONS_SERIALIZED] => Array ( [COLUMN_NAME] => conditions_serialized [COLUMN_TYPE] => text [COLUMN_POSITION] => 8 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 2M [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Conditions Serialized ) [ACTIONS_SERIALIZED] => Array ( [COLUMN_NAME] => actions_serialized [COLUMN_TYPE] => text [COLUMN_POSITION] => 9 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 2M [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Actions Serialized ) [STOP_RULES_PROCESSING] => Array ( [COLUMN_NAME] => stop_rules_processing [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 10 [DATA_TYPE] => smallint [DEFAULT] => 1 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Stop Rules Processing ) [IS_ADVANCED] => Array ( [COLUMN_NAME] => is_advanced [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 11 [DATA_TYPE] => smallint [DEFAULT] => 1 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Is Advanced ) [PRODUCT_IDS] => Array ( [COLUMN_NAME] => product_ids [COLUMN_TYPE] => text [COLUMN_POSITION] => 12 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 64k [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Product Ids ) [SORT_ORDER] => Array ( [COLUMN_NAME] => sort_order [COLUMN_TYPE] => integer [COLUMN_POSITION] => 13 [DATA_TYPE] => integer [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Sort Order ) [SIMPLE_ACTION] => Array ( [COLUMN_NAME] => simple_action [COLUMN_TYPE] => text [COLUMN_POSITION] => 14 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 32 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Simple Action ) [DISCOUNT_AMOUNT] => Array ( [COLUMN_NAME] => discount_amount [COLUMN_TYPE] => decimal [COLUMN_POSITION] => 15 [DATA_TYPE] => decimal [DEFAULT] => 0.0000 [NULLABLE] => [LENGTH] => [SCALE] => 4 [PRECISION] => 12 [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Discount Amount ) [DISCOUNT_QTY] => Array ( [COLUMN_NAME] => discount_qty [COLUMN_TYPE] => decimal [COLUMN_POSITION] => 16 [DATA_TYPE] => decimal [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => 4 [PRECISION] => 12 [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Discount Qty ) [DISCOUNT_STEP] => Array ( [COLUMN_NAME] => discount_step [COLUMN_TYPE] => integer [COLUMN_POSITION] => 17 [DATA_TYPE] => integer [DEFAULT] => [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Discount Step ) [SIMPLE_FREE_SHIPPING] => Array ( [COLUMN_NAME] => simple_free_shipping [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 18 [DATA_TYPE] => smallint [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Simple Free Shipping ) [APPLY_TO_SHIPPING] => Array ( [COLUMN_NAME] => apply_to_shipping [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 19 [DATA_TYPE] => smallint [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Apply To Shipping ) [TIMES_USED] => Array ( [COLUMN_NAME] => times_used [COLUMN_TYPE] => integer [COLUMN_POSITION] => 20 [DATA_TYPE] => integer [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Times Used ) [IS_RSS] => Array ( [COLUMN_NAME] => is_rss [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 21 [DATA_TYPE] => smallint [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Is Rss ) [WEBSITE_IDS] => Array ( [COLUMN_NAME] => website_ids [COLUMN_TYPE] => text [COLUMN_POSITION] => 22 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 4000 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Website Ids ) [COUPON_TYPE] => Array ( [COLUMN_NAME] => coupon_type [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 23 [DATA_TYPE] => smallint [DEFAULT] => 1 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Coupon Type ) ) [_indexes:protected] => Array ( [IDX_SALESRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE] => Array ( [INDEX_NAME] => IDX_SALESRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE [COLUMNS] => Array ( [IS_ACTIVE] => Array ( [NAME] => is_active [SIZE] => [POSITION] => 0 ) [SORT_ORDER] => Array ( [NAME] => sort_order [SIZE] => [POSITION] => 1 ) [TO_DATE] => Array ( [NAME] => to_date [SIZE] => [POSITION] => 2 ) [FROM_DATE] => Array ( [NAME] => from_date [SIZE] => [POSITION] => 3 ) ) [TYPE] => index ) ) [_foreignKeys:protected] => Array ( ) [_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/SalesRule/sql/salesrule_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.3 ) ) [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.3 ) ) [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 'salesrule' 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 `salesrule` ( `rule_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Rule Id', `name` varchar(255) NULL COMMENT 'Name', `description` text NULL COMMENT 'Description', `from_date` date NULL COMMENT 'From Date', `to_date` date NULL COMMENT 'To Date', `uses_per_customer` int NOT NULL default '0' COMMENT 'Uses Per Customer', `customer_group_ids` text NULL COMMENT 'Customer Group Ids', `is_active` smallint NOT NULL default '0' COMMENT 'Is Active', `conditions_serialized` mediumtext NULL COMMENT 'Conditions Serialized', `actions_serialized` mediumtext NULL COMMENT 'Actions Serialized', `stop_rules_processing` smallint NOT NULL default '1' COMMENT 'Stop Rules Processing', `is_advanced` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Advanced', `product_ids` text NULL COMMENT 'Product Ids', `sort_order` int UNSIGNED NOT NULL default '0' COMMENT 'Sort Order', `simple_action` varchar(32) NULL COMMENT 'Simple Action', `discount_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Discount Amount', `discount_qty` decimal(12,4) NULL COMMENT 'Discount Qty', `discount_step` int UNSIGNED NOT NULL COMMENT 'Discount Step', `simple_free_shipping` smallint UNSIGNED NOT NULL default '0' COMMENT 'Simple Free Shipping', `apply_to_shipping` smallint UNSIGNED NOT NULL default '0' COMMENT 'Apply To Shipping', `times_used` int UNSIGNED NOT NULL default '0' COMMENT 'Times Used', `is_rss` smallint NOT NULL default '0' COMMENT 'Is Rss', `website_ids` text NULL COMMENT 'Website Ids', `coupon_type` smallint UNSIGNED NOT NULL default '1' COMMENT 'Coupon Type', PRIMARY KEY (`rule_id`), INDEX `IDX_SALESRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE` (`is_active`, `sort_order`, `to_date`, `from_date`) ) COMMENT='Salesrule' 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 `salesrule` ( `rule_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Rule Id', `name` varchar(255) NULL COMMENT 'Name', `description` text NULL COMMENT 'Description', `from_date` date NULL COMMENT 'From Date', `to_date` date NULL COMMENT 'To Date', `uses_per_customer` int NOT NULL default '0' COMMENT 'Uses Per Customer', `customer_group_ids` text NULL COMMENT 'Customer Group Ids', `is_active` smallint NOT NULL default '0' COMMENT 'Is Active', `conditions_serialized` mediumtext NULL COMMENT 'Conditions Serialized', `actions_serialized` mediumtext NULL COMMENT 'Actions Serialized', `stop_rules_processing` smallint NOT NULL default '1' COMMENT 'Stop Rules Processing', `is_advanced` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Advanced', `product_ids` text NULL COMMENT 'Product Ids', `sort_order` int UNSIGNED NOT NULL default '0' COMMENT 'Sort Order', `simple_action` varchar(32) NULL COMMENT 'Simple Action', `discount_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Discount Amount', `discount_qty` decimal(12,4) NULL COMMENT 'Discount Qty', `discount_step` int UNSIGNED NOT NULL COMMENT 'Discount Step', `simple_free_shipping` smallint UNSIGNED NOT NULL default '0' COMMENT 'Simple Free Shipping', `apply_to_shipping` smallint UNSIGNED NOT NULL default '0' COMMENT 'Apply To Shipping', `times_used` int UNSIGNED NOT NULL default '0' COMMENT 'Times Used', `is_rss` smallint NOT NULL default '0' COMMENT 'Is Rss', `website_ids` text NULL COMMENT 'Website Ids', `coupon_type` smallint UNSIGNED NOT NULL default '1' COMMENT 'Coupon Type', PRIMARY KEY (`rule_id`), INDEX `IDX_SALESRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE` (`is_active`, `sort_order`, `to_date`, `from_date`) ) COMMENT='Salesrule' 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 `salesrule` ( `rule_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Rule Id', `name` varchar(255) NULL COMMENT 'Name', `description` text NULL COMMENT 'Description', `from_date` date NULL COMMENT 'From Date', `to_date` date NULL COMMENT 'To Date', `uses_per_customer` int NOT NULL default '0' COMMENT 'Uses Per Customer', `customer_group_ids` text NULL COMMENT 'Customer Group Ids', `is_active` smallint NOT NULL default '0' COMMENT 'Is Active', `conditions_serialized` mediumtext NULL COMMENT 'Conditions Serialized', `actions_serialized` mediumtext NULL COMMENT 'Actions Serialized', `stop_rules_processing` smallint NOT NULL default '1' COMMENT 'Stop Rules Processing', `is_advanced` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Advanced', `product_ids` text NULL COMMENT 'Product Ids', `sort_order` int UNSIGNED NOT NULL default '0' COMMENT 'Sort Order', `simple_action` varchar(32) NULL COMMENT 'Simple Action', `discount_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Discount Amount', `discount_qty` decimal(12,4) NULL COMMENT 'Discount Qty', `discount_step` int UNSIGNED NOT NULL COMMENT 'Discount Step', `simple_free_shipping` smallint UNSIGNED NOT NULL default '0' COMMENT 'Simple Free Shipping', `apply_to_shipping` smallint UNSIGNED NOT NULL default '0' COMMENT 'Apply To Shipping', `times_used` int UNSIGNED NOT NULL default '0' COMMENT 'Times Used', `is_rss` smallint NOT NULL default '0' COMMENT 'Is Rss', `website_ids` text NULL COMMENT 'Website Ids', `coupon_type` smallint UNSIGNED NOT NULL default '1' COMMENT 'Coupon Type', PRIMARY KEY (`rule_id`), INDEX `IDX_SALESRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE` (`is_active`, `sort_order`, `to_date`, `from_date`) ) COMMENT='Salesrule' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci ) ) [7] => Array ( [file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/SalesRule/sql/salesrule_setup/install-1.6.0.0.php [line] => 121 [function] => createTable [class] => Varien_Db_Adapter_Pdo_Mysql [type] => -> [args] => Array ( [0] => Varien_Db_Ddl_Table Object ( [_tableName:protected] => salesrule [_schemaName:protected] => [_tableComment:protected] => Salesrule [_columns:protected] => Array ( [RULE_ID] => Array ( [COLUMN_NAME] => rule_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] => Rule Id ) [NAME] => Array ( [COLUMN_NAME] => name [COLUMN_TYPE] => text [COLUMN_POSITION] => 1 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 255 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Name ) [DESCRIPTION] => Array ( [COLUMN_NAME] => description [COLUMN_TYPE] => text [COLUMN_POSITION] => 2 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 64k [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Description ) [FROM_DATE] => Array ( [COLUMN_NAME] => from_date [COLUMN_TYPE] => date [COLUMN_POSITION] => 3 [DATA_TYPE] => date [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => From Date ) [TO_DATE] => Array ( [COLUMN_NAME] => to_date [COLUMN_TYPE] => date [COLUMN_POSITION] => 4 [DATA_TYPE] => date [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => To Date ) [USES_PER_CUSTOMER] => Array ( [COLUMN_NAME] => uses_per_customer [COLUMN_TYPE] => integer [COLUMN_POSITION] => 5 [DATA_TYPE] => integer [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Uses Per Customer ) [CUSTOMER_GROUP_IDS] => Array ( [COLUMN_NAME] => customer_group_ids [COLUMN_TYPE] => text [COLUMN_POSITION] => 6 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 64k [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Customer Group Ids ) [IS_ACTIVE] => Array ( [COLUMN_NAME] => is_active [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 7 [DATA_TYPE] => smallint [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Is Active ) [CONDITIONS_SERIALIZED] => Array ( [COLUMN_NAME] => conditions_serialized [COLUMN_TYPE] => text [COLUMN_POSITION] => 8 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 2M [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Conditions Serialized ) [ACTIONS_SERIALIZED] => Array ( [COLUMN_NAME] => actions_serialized [COLUMN_TYPE] => text [COLUMN_POSITION] => 9 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 2M [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Actions Serialized ) [STOP_RULES_PROCESSING] => Array ( [COLUMN_NAME] => stop_rules_processing [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 10 [DATA_TYPE] => smallint [DEFAULT] => 1 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Stop Rules Processing ) [IS_ADVANCED] => Array ( [COLUMN_NAME] => is_advanced [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 11 [DATA_TYPE] => smallint [DEFAULT] => 1 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Is Advanced ) [PRODUCT_IDS] => Array ( [COLUMN_NAME] => product_ids [COLUMN_TYPE] => text [COLUMN_POSITION] => 12 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 64k [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Product Ids ) [SORT_ORDER] => Array ( [COLUMN_NAME] => sort_order [COLUMN_TYPE] => integer [COLUMN_POSITION] => 13 [DATA_TYPE] => integer [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Sort Order ) [SIMPLE_ACTION] => Array ( [COLUMN_NAME] => simple_action [COLUMN_TYPE] => text [COLUMN_POSITION] => 14 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 32 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Simple Action ) [DISCOUNT_AMOUNT] => Array ( [COLUMN_NAME] => discount_amount [COLUMN_TYPE] => decimal [COLUMN_POSITION] => 15 [DATA_TYPE] => decimal [DEFAULT] => 0.0000 [NULLABLE] => [LENGTH] => [SCALE] => 4 [PRECISION] => 12 [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Discount Amount ) [DISCOUNT_QTY] => Array ( [COLUMN_NAME] => discount_qty [COLUMN_TYPE] => decimal [COLUMN_POSITION] => 16 [DATA_TYPE] => decimal [DEFAULT] => [NULLABLE] => 1 [LENGTH] => [SCALE] => 4 [PRECISION] => 12 [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Discount Qty ) [DISCOUNT_STEP] => Array ( [COLUMN_NAME] => discount_step [COLUMN_TYPE] => integer [COLUMN_POSITION] => 17 [DATA_TYPE] => integer [DEFAULT] => [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Discount Step ) [SIMPLE_FREE_SHIPPING] => Array ( [COLUMN_NAME] => simple_free_shipping [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 18 [DATA_TYPE] => smallint [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Simple Free Shipping ) [APPLY_TO_SHIPPING] => Array ( [COLUMN_NAME] => apply_to_shipping [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 19 [DATA_TYPE] => smallint [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Apply To Shipping ) [TIMES_USED] => Array ( [COLUMN_NAME] => times_used [COLUMN_TYPE] => integer [COLUMN_POSITION] => 20 [DATA_TYPE] => integer [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Times Used ) [IS_RSS] => Array ( [COLUMN_NAME] => is_rss [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 21 [DATA_TYPE] => smallint [DEFAULT] => 0 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Is Rss ) [WEBSITE_IDS] => Array ( [COLUMN_NAME] => website_ids [COLUMN_TYPE] => text [COLUMN_POSITION] => 22 [DATA_TYPE] => text [DEFAULT] => [NULLABLE] => 1 [LENGTH] => 4000 [SCALE] => [PRECISION] => [UNSIGNED] => [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Website Ids ) [COUPON_TYPE] => Array ( [COLUMN_NAME] => coupon_type [COLUMN_TYPE] => smallint [COLUMN_POSITION] => 23 [DATA_TYPE] => smallint [DEFAULT] => 1 [NULLABLE] => [LENGTH] => [SCALE] => [PRECISION] => [UNSIGNED] => 1 [PRIMARY] => [PRIMARY_POSITION] => 0 [IDENTITY] => [COMMENT] => Coupon Type ) ) [_indexes:protected] => Array ( [IDX_SALESRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE] => Array ( [INDEX_NAME] => IDX_SALESRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE [COLUMNS] => Array ( [IS_ACTIVE] => Array ( [NAME] => is_active [SIZE] => [POSITION] => 0 ) [SORT_ORDER] => Array ( [NAME] => sort_order [SIZE] => [POSITION] => 1 ) [TO_DATE] => Array ( [NAME] => to_date [SIZE] => [POSITION] => 2 ) [FROM_DATE] => Array ( [NAME] => from_date [SIZE] => [POSITION] => 3 ) ) [TYPE] => index ) ) [_foreignKeys:protected] => Array ( ) [_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/SalesRule/sql/salesrule_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.3 ) ) [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.3 ) ) [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 'salesrule' already exists ) ) )