Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

after updating to 1.2.1 have major problem…… PDOException Object
 
tapebrothers
Sr. Member
 
Total Posts:  96
Joined:  2008-05-14
 

after updating 1.2.0 to 1.2.1 with magento connect i cant get in to any site or admin i get this. can this be fix ?

PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘cataloginventory_stock_status’ already exists
[string:private] =>
[code:protected] => 42S01
[file:protected] => /chroot/home/camoduct/camoducttape.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line:protected] => 207
[trace:private] => Array
(
[0] => Array
(
[file] => /chroot/home/camoduct/camoducttape.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 207
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `cataloginventory_stock_status` (
`product_id` int(10) unsigned NOT NULL,
`website_id` smallint(5) unsigned NOT NULL,
`stock_id` smallint(4) unsigned NOT NULL,
`qty` decimal(12,4) NOT NULL DEFAULT ‘0.0000’,
`stock_status` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`product_id`,`website_id`,`stock_id`),
CONSTRAINT `FK_CATALOGINVENTORY_STOCK_STATUS_STOCK` FOREIGN KEY (`stock_id`) REFERENCES `cataloginventory_stock` (`stock_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_CATALOGINVENTORY_STOCK_STATUS_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_CATALOGINVENTORY_STOCK_STATUS_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)

)

[1] => Array
(
[file] => /chroot/home/camoduct/camoducttape.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 310
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `cataloginventory_stock_status` (
`product_id` int(10) unsigned NOT NULL,
`website_id` smallint(5) unsigned NOT NULL,
`stock_id` smallint(4) unsigned NOT NULL,
`qty` decimal(12,4) NOT NULL DEFAULT ‘0.0000’,
`stock_status` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`product_id`,`website_id`,`stock_id`),
CONSTRAINT `FK_CATALOGINVENTORY_STOCK_STATUS_STOCK` FOREIGN KEY (`stock_id`) REFERENCES `cataloginventory_stock` (`stock_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_CATALOGINVENTORY_STOCK_STATUS_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_CATALOGINVENTORY_STOCK_STATUS_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)

)

[2] => Array
(
[file] => /chroot/home/camoduct/camoducttape.com/html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 508
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
CREATE TABLE `cataloginventory_stock_status` (
`product_id` int(10) unsigned NOT NULL,
`website_id` smallint(5) unsigned NOT NULL,
`stock_id` smallint(4) unsigned NOT NULL,
`qty` decimal(12,4) NOT NULL DEFAULT ‘0.0000’,
`stock_status` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`product_id`,`website_id`,`stock_id`),
CONSTRAINT `FK_CATALOGINVENTORY_STOCK_STATUS_STOCK` FOREIGN KEY (`stock_id`) REFERENCES `cataloginventory_stock` (`stock_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_CATALOGINVENTORY_STOCK_STATUS_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_CATALOGINVENTORY_STOCK_STATUS_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

)

)

[3] => Array
(
[file] => /chroot/home/camoduct/camoducttape.com/html/app/code/core/Mage/CatalogInventory/sql/cataloginventory_setup/mysql4-upgrade-0.7.4-0.7.5.php
[line] => 43
[function] => run
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] =>
CREATE TABLE `cataloginventory_stock_status` (
`product_id` int(10) unsigned NOT NULL,
`website_id` smallint(5) unsigned NOT NULL,
`stock_id` smallint(4) unsigned NOT NULL,
`qty` decimal(12,4) NOT NULL DEFAULT ‘0.0000’,
`stock_status` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`product_id`,`website_id`,`stock_id`),
CONSTRAINT `FK_CATALOGINVENTORY_STOCK_STATUS_STOCK` FOREIGN KEY (`stock_id`) REFERENCES `cataloginventory_stock` (`stock_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_CATALOGINVENTORY_STOCK_STATUS_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_CATALOGINVENTORY_STOCK_STATUS_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

)

)

[4] => Array
(
[file] => /chroot/home/camoduct/camoducttape.com/html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 274
[args] => Array
(
[0] => /chroot/home/camoduct/camoducttape.com/html/app/code/core/Mage/CatalogInventory/sql/cataloginventory_setup/mysql4-upgrade-0.7.4-0.7.5.php
)

[function] => include
)

[5] => Array
(
[file] => /chroot/home/camoduct/camoducttape.com/html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 179
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => upgrade
[1] => 0.7.4
[2] => 0.7.5
)

)

[6] => Array
(
[file] => /chroot/home/camoduct/camoducttape.com/html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 146
[function] => _upgradeResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 0.7.4
[1] => 0.7.5
)

)

[7] => Array
(
[file] => /chroot/home/camoduct/camoducttape.com/html/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] => /chroot/home/camoduct/camoducttape.com/html/app/code/core/Mage/Core/Model/Config.php
[line] => 214
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)

)

[9] => Array
(
[file] => /chroot/home/camoduct/camoducttape.com/html/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] => /chroot/home/camoduct/camoducttape.com/html/app/Mage.php
[line] => 432
[function] => init
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] =>
[1] => store
[2] => Array
(
)

)

)

[11] => Array
(
[file] => /chroot/home/camoduct/camoducttape.com/html/downloader/Maged/Model/Session.php
[line] => 35
[function] => app
[class] => Mage
[type] => ::
[args] => Array
(
)

)

[12] => Array
(
[file] => /chroot/home/camoduct/camoducttape.com/html/downloader/Maged/Controller.php
[line] => 261
[function] => start
[class] => Maged_Model_Session
[type] => ->
[args] => Array
(
)

)

[13] => Array
(
[file] => /chroot/home/camoduct/camoducttape.com/html/downloader/Maged/Controller.php
[line] => 343
[function] => session
[class] => Maged_Controller
[type] => ->
[args] => Array
(
)

)

[14] => Array
(
[file] => /chroot/home/camoduct/camoducttape.com/html/downloader/Maged/Controller.php
[line] => 170
[function] => dispatch
[class] => Maged_Controller
[type] => ->
[args] => Array
(
)

)

[15] => Array
(
[file] => /chroot/home/camoduct/camoducttape.com/html/downloader/index.php
[line] => 35
[function] => run
[class] => Maged_Controller
[type] => ::
[args] => Array
(
)

)

)

[errorInfo] => Array
(
[0] => 42S01
[1] => 1050
[2] => Table ‘cataloginventory_stock_status’ already exists
)

)

Magento Downloader

 
Magento Community Magento Community
Magento Community
Magento Community
 
Gabrusch
Member
 
Avatar
Total Posts:  44
Joined:  2008-03-26
Wuerzburg, Germany
 

Yep, having the same problem!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Gabrusch
Member
 
Avatar
Total Posts:  44
Joined:  2008-03-26
Wuerzburg, Germany
 

Check if your database is InnoDB and not MyISAM.

I have a small converter vor version 1.2.0.3

File Attachments
innodb-fix.sql  (File Size: 14KB - Downloads: 216)
 
Magento Community Magento Community
Magento Community
Magento Community
 
resonance
Member
 
Avatar
Total Posts:  62
Joined:  2008-09-24
 

Seems like it’s saying the table already exists that it’s trying to create? Take a look at this thread, it might help: http://www.magentocommerce.com/boards/viewthread/30703/

 
Magento Community Magento Community
Magento Community
Magento Community
 
lurebeauty
Sr. Member
 
Avatar
Total Posts:  229
Joined:  2009-07-06
 
Gabrusch - 05 February 2009 10:43 AM

Check if your database is InnoDB and not MyISAM.

I have a small converter vor version 1.2.0.3

I had been having so much trouble with this and this fix helped, thank you so much!!!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top