Magento - 1.3 upgrade SQL error - Magento 1.3.0 Upgrade Issues - eCommerce Software for Growth

Log In

Username or Email

Password:

Forgot Password

or
Register

Skip to site navigation »
Skip to main content »
Skip to footer content »

Magento Forum

1.3 upgrade SQL error

freshwebservices Total Posts: 150 Joined: 2008-05-27 Leicestershire, UK Ignore user	Hi, Tried to update my dev system (XP SP3, XAMPP) from 1.2.1.1 to 1.3.0 via Connect. I got the following error msg from Connect & also when trying to log into admin: Error in file: "C:\Program Files\xampp2\htdocs\magento\app\code\core\Mage\CatalogInventory\sql\cataloginventory_setup\mysql4-upgrade-0.7.4-0.7.5.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'cataloginventory_stock_status' already exists Trace: #0 C:\Program Files\xampp2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(292): Mage::exception('Mage_Core', 'Error in file: ...') #1 C:\Program Files\xampp2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(179): Mage_Core_Model_Resource_Setup->_modifyResourceDb('upgrade', '0.7.4', '0.7.5') #2 C:\Program Files\xampp2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(146): Mage_Core_Model_Resource_Setup->_upgradeResourceDb('0.7.4', '0.7.5') #3 C:\Program Files\xampp2\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(121): Mage_Core_Model_Resource_Setup->applyUpdates() #4 C:\Program Files\xampp2\htdocs\magento\app\code\core\Mage\Core\Model\Config.php(207): Mage_Core_Model_Resource_Setup::applyAllUpdates() #5 C:\Program Files\xampp2\htdocs\magento\app\code\core\Mage\Core\Model\App.php(242): Mage_Core_Model_Config->init(Array) #6 C:\Program Files\xampp2\htdocs\magento\app\Mage.php(432): Mage_Core_Model_App->init('', 'store', Array) #7 C:\Program Files\xampp2\htdocs\magento\app\Mage.php(453): Mage::app('', 'store', Array) #8 C:\Program Files\xampp2\htdocs\magento\index.php(52): Mage::run() #9 {main} I’ve tried to do the following pear commands: `pear install mage-core/Mage_All_Latest-stable` but got “package is not valid” `pear upgrade-all` didn’t error but made no difference. Any suggestions? Thanks, Eddie Signature Web Design Leicestershire Content Management Specialist
	Posted: April 1 2009 \| top

ButterfliesForRelease Total Posts: 25 Joined: 2008-11-16 Brooker, FL Ignore user	Did you use ./pear or pear? you need to use the copy of pear that is in the magento directory, not the generic version on the server. Signature Thanks, David Butterflies For Release
	Posted: April 2 2009 \| top \| # 1

freshwebservices Total Posts: 150 Joined: 2008-05-27 Leicestershire, UK Ignore user	Hi David, used pear - ./pear wouldn’t run on my XP. Eddie Signature Web Design Leicestershire Content Management Specialist
	Posted: April 2 2009 \| top \| # 2

ButterfliesForRelease Total Posts: 25 Joined: 2008-11-16 Brooker, FL Ignore user	oops, I missed the XP part of your post Signature Thanks, David Butterflies For Release
	Posted: April 2 2009 \| top \| # 3

freshwebservices Total Posts: 150 Joined: 2008-05-27 Leicestershire, UK Ignore user	No worries David, Thanks for trying to help - I’ll see if I can find a way to use the Mage pear rather than the XAMPP pear. Oh what fun! Eddie Signature Web Design Leicestershire Content Management Specialist
	Posted: April 3 2009 \| top \| # 4

moleygunn Total Posts: 72 Joined: 2008-11-25 Ignore user	Hi Eddie, http://www.magentocommerce.com/boards/viewthread/27026/ fixed this problem for me.
	Posted: April 3 2009 \| top \| # 5

Magento Community

Magento Community

Back to top

1.3 upgrade SQL error

[solved]Product Zoom - Add To Cart - Tabs - Anything javascript not working