PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'salesrule' already exists
[string:private] =>
[code:protected] => 42S01
[file:protected] => /var/www/vhosts/boeddha.org/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line:protected] => 208
[trace:private] => Array
(
[0] => Array
(
[file] => /var/www/vhosts/boeddha.org/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 208
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] => -- DROP TABLE IF EXISTS salesrule;
CREATE TABLE salesrule (
`rule_id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`from_date` date default '0000-00-00',
`to_date` date default '0000-00-00',
`store_ids` varchar(255) NOT NULL default '',
`coupon_code` varchar(255) default NULL,
`uses_per_coupon` smallint(11) NOT NULL default '0',
`uses_per_customer` smallint(11) NOT NULL default '0',
`customer_group_ids` varchar(255) NOT NULL default '',
`is_active` tinyint(1) NOT NULL default '0',
`conditions_serialized` text NOT NULL,
`actions_serialized` text NOT NULL,
`stop_rules_processing` tinyint(1) NOT NULL default '1',
`is_advanced` tinyint(3) unsigned NOT NULL default '1',
`product_ids` text,
`sort_order` int(10) unsigned NOT NULL default '0',
`simple_action` varchar(32) NOT NULL default '',
`discount_amount` decimal(12,4) NOT NULL default '0.0000',
`discount_qty` decimal(12,4) unsigned default NULL,
`simple_free_shipping` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`rule_id`),
KEY `sort_order` (`is_active`,`sort_order`,`to_date`,`from_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)
)
[1] => Array
(
[file] => /var/www/vhosts/boeddha.org/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 311
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => -- DROP TABLE IF EXISTS salesrule;
CREATE TABLE salesrule (
`rule_id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`from_date` date default '0000-00-00',
`to_date` date default '0000-00-00',
`store_ids` varchar(255) NOT NULL default '',
`coupon_code` varchar(255) default NULL,
`uses_per_coupon` smallint(11) NOT NULL default '0',
`uses_per_customer` smallint(11) NOT NULL default '0',
`customer_group_ids` varchar(255) NOT NULL default '',
`is_active` tinyint(1) NOT NULL default '0',
`conditions_serialized` text NOT NULL,
`actions_serialized` text NOT NULL,
`stop_rules_processing` tinyint(1) NOT NULL default '1',
`is_advanced` tinyint(3) unsigned NOT NULL default '1',
`product_ids` text,
`sort_order` int(10) unsigned NOT NULL default '0',
`simple_action` varchar(32) NOT NULL default '',
`discount_amount` decimal(12,4) NOT NULL default '0.0000',
`discount_qty` decimal(12,4) unsigned default NULL,
`simple_free_shipping` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`rule_id`),
KEY `sort_order` (`is_active`,`sort_order`,`to_date`,`from_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)
)
[2] => Array
(
[file] => /var/www/vhosts/boeddha.org/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 507
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
-- DROP TABLE IF EXISTS salesrule;
CREATE TABLE salesrule (
`rule_id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`from_date` date default '0000-00-00',
`to_date` date default '0000-00-00',
`store_ids` varchar(255) NOT NULL default '',
`coupon_code` varchar(255) default NULL,
`uses_per_coupon` smallint(11) NOT NULL default '0',
`uses_per_customer` smallint(11) NOT NULL default '0',
`customer_group_ids` varchar(255) NOT NULL default '',
`is_active` tinyint(1) NOT NULL default '0',
`conditions_serialized` text NOT NULL,
`actions_serialized` text NOT NULL,
`stop_rules_processing` tinyint(1) NOT NULL default '1',
`is_advanced` tinyint(3) unsigned NOT NULL default '1',
`product_ids` text,
`sort_order` int(10) unsigned NOT NULL default '0',
`simple_action` varchar(32) NOT NULL default '',
`discount_amount` decimal(12,4) NOT NULL default '0.0000',
`discount_qty` decimal(12,4) unsigned default NULL,
`simple_free_shipping` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`rule_id`),
KEY `sort_order` (`is_active`,`sort_order`,`to_date`,`from_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- DROP TABLE IF EXISTS salesrule_customer;
CREATE TABLE salesrule_customer (
`rule_customer_id` int(10) unsigned NOT NULL auto_increment,
`rule_id` int(10) unsigned NOT NULL default '0',
`customer_id` int(10) unsigned NOT NULL default '0',
`times_used` smallint(11) unsigned NOT NULL default '0',
PRIMARY KEY (`rule_customer_id`),
KEY `rule_id` (`rule_id`,`customer_id`),
KEY `customer_id` (`customer_id`,`rule_id`),
CONSTRAINT `FK_salesrule_customer_id` FOREIGN KEY (`customer_id`) REFERENCES customer_entity (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_salesrule_customer_rule` FOREIGN KEY (`rule_id`) REFERENCES salesrule (`rule_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- DROP TABLE IF EXISTS salesrule_product;
CREATE TABLE salesrule_product (
`rule_product_id` int(10) unsigned NOT NULL auto_increment,
`rule_id` int(10) unsigned NOT NULL default '0',
`from_time` int(10) unsigned NOT NULL default '0',
`to_time` int(10) unsigned NOT NULL default '0',
`store_id` smallint(5) unsigned NOT NULL default '0',
`customer_group_id` smallint(5) unsigned NOT NULL default '0',
`product_id` int(10) unsigned NOT NULL default '0',
`coupon_code` varchar(255) default NULL,
`sort_order` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`rule_product_id`),
UNIQUE KEY `sort_order` (`from_time`,`to_time`,`store_id`,`customer_group_id`,`product_id`,`coupon_code`,`sort_order`),
KEY `FK_salesrule_product_rule` (`rule_id`),
KEY `FK_salesrule_product_store` (`store_id`),
KEY `FK_salesrule_product_customergroup` (`customer_group_id`),
CONSTRAINT `FK_salesrule_product_customergroup` FOREIGN KEY (`customer_group_id`) REFERENCES customer_group (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_salesrule_product_rule` FOREIGN KEY (`rule_id`) REFERENCES salesrule (`rule_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_salesrule_product_store` FOREIGN KEY (`store_id`) REFERENCES core_store (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- DROP TABLE IF EXISTS salesrule_product_action;
CREATE TABLE salesrule_product_action (
`rule_product_action_id` int(10) unsigned NOT NULL auto_increment,
`rule_product_id` int(10) unsigned NOT NULL default '0',
`action_type` varchar(255) NOT NULL default '',
`action_attribute` varchar(255) NOT NULL default '',
`action_operator` varchar(255) NOT NULL default '',
`action_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`rule_product_action_id`),
KEY `rule_product_id` (`rule_product_id`),
CONSTRAINT `salesrule_product_action_ibfk_1` FOREIGN KEY (`rule_product_id`) REFERENCES salesrule_product (`rule_product_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
)
)
[3] => Array
(
[file] => /var/www/vhosts/boeddha.org/httpdocs/app/code/core/Mage/SalesRule/sql/salesrule_setup/mysql4-install-0.7.0.php
[line] => 108
[function] => run
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] =>
-- DROP TABLE IF EXISTS salesrule;
CREATE TABLE salesrule (
`rule_id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`from_date` date default '0000-00-00',
`to_date` date default '0000-00-00',
`store_ids` varchar(255) NOT NULL default '',
`coupon_code` varchar(255) default NULL,
`uses_per_coupon` smallint(11) NOT NULL default '0',
`uses_per_customer` smallint(11) NOT NULL default '0',
`customer_group_ids` varchar(255) NOT NULL default '',
`is_active` tinyint(1) NOT NULL default '0',
`conditions_serialized` text NOT NULL,
`actions_serialized` text NOT NULL,
`stop_rules_processing` tinyint(1) NOT NULL default '1',
`is_advanced` tinyint(3) unsigned NOT NULL default '1',
`product_ids` text,
`sort_order` int(10) unsigned NOT NULL default '0',
`simple_action` varchar(32) NOT NULL default '',
`discount_amount` decimal(12,4) NOT NULL default '0.0000',
`discount_qty` decimal(12,4) unsigned default NULL,
`simple_free_shipping` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`rule_id`),
KEY `sort_order` (`is_active`,`sort_order`,`to_date`,`from_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- DROP TABLE IF EXISTS salesrule_customer;
CREATE TABLE salesrule_customer (
`rule_customer_id` int(10) unsigned NOT NULL auto_increment,
`rule_id` int(10) unsigned NOT NULL default '0',
`customer_id` int(10) unsigned NOT NULL default '0',
`times_used` smallint(11) unsigned NOT NULL default '0',
PRIMARY KEY (`rule_customer_id`),
KEY `rule_id` (`rule_id`,`customer_id`),
KEY `customer_id` (`customer_id`,`rule_id`),
CONSTRAINT `FK_salesrule_customer_id` FOREIGN KEY (`customer_id`) REFERENCES customer_entity (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_salesrule_customer_rule` FOREIGN KEY (`rule_id`) REFERENCES salesrule (`rule_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- DROP TABLE IF EXISTS salesrule_product;
CREATE TABLE salesrule_product (
`rule_product_id` int(10) unsigned NOT NULL auto_increment,
`rule_id` int(10) unsigned NOT NULL default '0',
`from_time` int(10) unsigned NOT NULL default '0',
`to_time` int(10) unsigned NOT NULL default '0',
`store_id` smallint(5) unsigned NOT NULL default '0',
`customer_group_id` smallint(5) unsigned NOT NULL default '0',
`product_id` int(10) unsigned NOT NULL default '0',
`coupon_code` varchar(255) default NULL,
`sort_order` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`rule_product_id`),
UNIQUE KEY `sort_order` (`from_time`,`to_time`,`store_id`,`customer_group_id`,`product_id`,`coupon_code`,`sort_order`),
KEY `FK_salesrule_product_rule` (`rule_id`),
KEY `FK_salesrule_product_store` (`store_id`),
KEY `FK_salesrule_product_customergroup` (`customer_group_id`),
CONSTRAINT `FK_salesrule_product_customergroup` FOREIGN KEY (`customer_group_id`) REFERENCES customer_group (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_salesrule_product_rule` FOREIGN KEY (`rule_id`) REFERENCES salesrule (`rule_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_salesrule_product_store` FOREIGN KEY (`store_id`) REFERENCES core_store (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- DROP TABLE IF EXISTS salesrule_product_action;
CREATE TABLE salesrule_product_action (
`rule_product_action_id` int(10) unsigned NOT NULL auto_increment,
`rule_product_id` int(10) unsigned NOT NULL default '0',
`action_type` varchar(255) NOT NULL default '',
`action_attribute` varchar(255) NOT NULL default '',
`action_operator` varchar(255) NOT NULL default '',
`action_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`rule_product_action_id`),
KEY `rule_product_id` (`rule_product_id`),
CONSTRAINT `salesrule_product_action_ibfk_1` FOREIGN KEY (`rule_product_id`) REFERENCES salesrule_product (`rule_product_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
)
)
[4] => Array
(
[file] => /var/www/vhosts/boeddha.org/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 274
[args] => Array
(
[0] => /var/www/vhosts/boeddha.org/httpdocs/app/code/core/Mage/SalesRule/sql/salesrule_setup/mysql4-install-0.7.0.php
)
[function] => include
)
[5] => Array
(
[file] => /var/www/vhosts/boeddha.org/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 167
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => install
[1] =>
[2] => 0.7.7
)
)
[6] => Array
(
[file] => /var/www/vhosts/boeddha.org/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 155
[function] => _installResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 0.7.7
)
)
[7] => Array
(
[file] => /var/www/vhosts/boeddha.org/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 121
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)
)
[8] => Array
(
[file] => /var/www/vhosts/boeddha.org/httpdocs/app/code/core/Mage/Core/Model/Config.php
[line] => 207
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[9] => Array
(
[file] => /var/www/vhosts/boeddha.org/httpdocs/app/code/core/Mage/Core/Model/App.php
[line] => 242
[function] => init
[class] => Mage_Core_Model_Config
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[10] => Array
(
[file] => /var/www/vhosts/boeddha.org/httpdocs/app/Mage.php
[line] => 432
[function] => init
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] =>
[1] => store
[2] => Array
(
)
)
)
[11] => Array
(
[file] => /var/www/vhosts/boeddha.org/httpdocs/app/Mage.php
[line] => 453
[function] => app
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
[2] => Array
(
)
)
)
[12] => Array
(
[file] => /var/www/vhosts/boeddha.org/httpdocs/index.php
[line] => 52
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
)
)
)
[errorInfo] => Array
(
[0] => 42S01
[1] => 1050
[2] => Table 'salesrule' already exists
)
)