PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'cataloginventory_stock' already exists
[string:private] =>
[code:protected] => 42S01
[file:protected] => /home/admin/domains/rodaigh.com/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line:protected] => 109
[trace:private] => Array
(
[0] => Array
(
[file] => /home/admin/domains/rodaigh.com/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 109
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] => -- DROP TABLE IF EXISTS `cataloginventory_stock`;
CREATE TABLE `cataloginventory_stock` (
`stock_id` smallint(4) unsigned NOT NULL auto_increment,
`stock_name` varchar(255) NOT NULL default '',
PRIMARY KEY (`stock_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog inventory Stocks list'
)
)
[1] => Array
(
[file] => /home/admin/domains/rodaigh.com/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 147
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => -- DROP TABLE IF EXISTS `cataloginventory_stock`;
CREATE TABLE `cataloginventory_stock` (
`stock_id` smallint(4) unsigned NOT NULL auto_increment,
`stock_name` varchar(255) NOT NULL default '',
PRIMARY KEY (`stock_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog inventory Stocks list'
)
)
[2] => Array
(
[file] => /home/admin/domains/rodaigh.com/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 484
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
-- DROP TABLE IF EXISTS `cataloginventory_stock`;
CREATE TABLE `cataloginventory_stock` (
`stock_id` smallint(4) unsigned NOT NULL auto_increment,
`stock_name` varchar(255) NOT NULL default '',
PRIMARY KEY (`stock_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog inventory Stocks list';
insert into `cataloginventory_stock`(`stock_id`,`stock_name`) values (1, 'Default');
-- DROP TABLE IF EXISTS `cataloginventory_stock_item`;
CREATE TABLE `cataloginventory_stock_item` (
`item_id` int(10) unsigned NOT NULL auto_increment,
`product_id` int(10) unsigned NOT NULL default '0',
`stock_id` smallint(4) unsigned NOT NULL default '0',
`qty` decimal(12,4) NOT NULL default '0.0000',
`min_qty` decimal(12,4) NOT NULL default '0.0000',
`use_config_min_qty` tinyint(1) unsigned NOT NULL default '1',
`is_qty_decimal` tinyint(1) unsigned NOT NULL default '0',
`backorders` tinyint(3) unsigned NOT NULL default '0',
`use_config_backorders` tinyint(1) unsigned NOT NULL default '1',
`min_sale_qty` decimal(12,4) NOT NULL default '1.0000',
`use_config_min_sale_qty` tinyint(1) unsigned NOT NULL default '1',
`max_sale_qty` decimal(12,4) NOT NULL default '0.0000',
`use_config_max_sale_qty` tinyint(1) unsigned NOT NULL default '1',
`is_in_stock` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`item_id`),
UNIQUE KEY `IDX_STOCK_PRODUCT` (`product_id`,`stock_id`),
KEY `FK_CATALOGINVENTORY_STOCK_ITEM_PRODUCT` (`product_id`),
KEY `FK_CATALOGINVENTORY_STOCK_ITEM_STOCK` (`stock_id`),
CONSTRAINT `FK_CATALOGINVENTORY_STOCK_ITEM_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_CATALOGINVENTORY_STOCK_ITEM_STOCK` FOREIGN KEY (`stock_id`) REFERENCES `cataloginventory_stock` (`stock_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Inventory Stock Item Data';
)
)
[3] => Array
(
[file] => /home/admin/domains/rodaigh.com/public_html/app/code/core/Mage/CatalogInventory/sql/cataloginventory_setup/mysql4-install-0.7.0.php
[line] => 61
[function] => run
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] =>
-- DROP TABLE IF EXISTS `cataloginventory_stock`;
CREATE TABLE `cataloginventory_stock` (
`stock_id` smallint(4) unsigned NOT NULL auto_increment,
`stock_name` varchar(255) NOT NULL default '',
PRIMARY KEY (`stock_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog inventory Stocks list';
insert into `cataloginventory_stock`(`stock_id`,`stock_name`) values (1, 'Default');
-- DROP TABLE IF EXISTS `cataloginventory_stock_item`;
CREATE TABLE `cataloginventory_stock_item` (
`item_id` int(10) unsigned NOT NULL auto_increment,
`product_id` int(10) unsigned NOT NULL default '0',
`stock_id` smallint(4) unsigned NOT NULL default '0',
`qty` decimal(12,4) NOT NULL default '0.0000',
`min_qty` decimal(12,4) NOT NULL default '0.0000',
`use_config_min_qty` tinyint(1) unsigned NOT NULL default '1',
`is_qty_decimal` tinyint(1) unsigned NOT NULL default '0',
`backorders` tinyint(3) unsigned NOT NULL default '0',
`use_config_backorders` tinyint(1) unsigned NOT NULL default '1',
`min_sale_qty` decimal(12,4) NOT NULL default '1.0000',
`use_config_min_sale_qty` tinyint(1) unsigned NOT NULL default '1',
`max_sale_qty` decimal(12,4) NOT NULL default '0.0000',
`use_config_max_sale_qty` tinyint(1) unsigned NOT NULL default '1',
`is_in_stock` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`item_id`),
UNIQUE KEY `IDX_STOCK_PRODUCT` (`product_id`,`stock_id`),
KEY `FK_CATALOGINVENTORY_STOCK_ITEM_PRODUCT` (`product_id`),
KEY `FK_CATALOGINVENTORY_STOCK_ITEM_STOCK` (`stock_id`),
CONSTRAINT `FK_CATALOGINVENTORY_STOCK_ITEM_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_CATALOGINVENTORY_STOCK_ITEM_STOCK` FOREIGN KEY (`stock_id`) REFERENCES `cataloginventory_stock` (`stock_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Inventory Stock Item Data';
)
)
[4] => Array
(
[file] => /home/admin/domains/rodaigh.com/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 260
[args] => Array
(
[0] => /home/admin/domains/rodaigh.com/public_html/app/code/core/Mage/CatalogInventory/sql/cataloginventory_setup/mysql4-install-0.7.0.php
)
[function] => include
)
[5] => Array
(
[file] => /home/admin/domains/rodaigh.com/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 158
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => install
[1] =>
[2] => 0.7.1
)
)
[6] => Array
(
[file] => /home/admin/domains/rodaigh.com/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 144
[function] => _installResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 0.7.1
)
)
[7] => Array
(
[file] => /home/admin/domains/rodaigh.com/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 111
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)
)
[8] => Array
(
[file] => /home/admin/domains/rodaigh.com/public_html/app/code/core/Mage/Core/Model/Config.php
[line] => 195
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[9] => Array
(
[file] => /home/admin/domains/rodaigh.com/public_html/app/code/core/Mage/Core/Model/App.php
[line] => 208
[function] => init
[class] => Mage_Core_Model_Config
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[10] => Array
(
[file] => /home/admin/domains/rodaigh.com/public_html/app/Mage.php
[line] => 404
[function] => init
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] =>
[1] => store
[2] => Array
(
)
)
)
[11] => Array
(
[file] => /home/admin/domains/rodaigh.com/public_html/app/Mage.php
[line] => 423
[function] => app
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
[2] => Array
(
)
)
)
[12] => Array
(
[file] => /home/admin/domains/rodaigh.com/public_html/index.php
[line] => 40
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
)
)
)
[errorInfo] => Array
(
[0] => 42S01
[1] => 1050
[2] => Table 'cataloginventory_stock' already exists
)
)