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

first upgrade attempt fails predictably - little help?  :)
 
haveabyte
Jr. Member
 
Total Posts:  4
Joined:  2009-05-27
 

I’m trying a Magento upgrade for the first time.  I’ve recently taken over administration for a site, and I’m still learning a lot about Magento.  It’s a great system.

I made a functioning copy of Magento in a subdomain and pointed it to a separate database and verified everything was cordoned off as to not affect the production site.

So, I tried to go from 1.1.6 to 1.3.2.2. 
I followed the instructions for upgrade from a full install from this page:
http://www.magentocommerce.com/wiki/upgrading_magento

I made my backups and downloaded the 1.3.2.2 full release.  I extracted the files on top of the existing ones, and hit the admin page to invoke the database upgrades.  The first time I hit the page, I got this error:

Error in file"/var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/code/core/Mage/CatalogInventory/sql/cataloginventory_setup/mysql4-upgrade-0.7.4-0.7.5.php" Strict NoticeDeclaration of Unirgy_GiftCert_Model_Product_Type::isVirtual() should be compatible with that of Mage_Catalog_Model_Product_Type_Abstract::isVirtual()  in /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/code/community/Unirgy/Giftcert/Model/Product/Type.php on line 73
Trace
:
#0 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(292): Mage::exception('Mage_Core', 'Error in file: ...')
#1 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(179): Mage_Core_Model_Resource_Setup->_modifyResourceDb('upgrade', '0.7.2', '0.7.5')
#2 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(146): Mage_Core_Model_Resource_Setup->_upgradeResourceDb('0.7.2', '0.7.5')
#3 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(121): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/code/core/Mage/Core/Model/Config.php(263): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/code/core/Mage/Core/Model/App.php(263): Mage_Core_Model_Config->init(Array)
#6 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/Mage.php(434): Mage_Core_Model_App->init('', 'store', Array)
#7 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/Mage.php(455): Mage::app('', 'store', Array)
#8 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/index.php(65): Mage::run()
#9 {main}

For kicks I refreshed the page and got this message, which now repeats with every refresh:

Error in file"/var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/code/core/Mage/CatalogInventory/sql/cataloginventory_setup/mysql4-upgrade-0.7.4-0.7.5.php" SQLSTATE[42S01]Base table or view already exists1050 Table 'cataloginventory_stock_status' already exists
Trace
:
#0 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(292): Mage::exception('Mage_Core', 'Error in file: ...')
#1 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(179): Mage_Core_Model_Resource_Setup->_modifyResourceDb('upgrade', '0.7.4', '0.7.5')
#2 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(146): Mage_Core_Model_Resource_Setup->_upgradeResourceDb('0.7.4', '0.7.5')
#3 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(121): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/code/core/Mage/Core/Model/Config.php(263): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/code/core/Mage/Core/Model/App.php(263): Mage_Core_Model_Config->init(Array)
#6 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/Mage.php(434): Mage_Core_Model_App->init('', 'store', Array)
#7 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/app/Mage.php(455): Mage::app('', 'store', Array)
#8 /var/www/vhosts/sitename.com/subdomains/dev/httpdocs/index.php(65): Mage::run()
#9 {main}

I’m guessing I tried to upgrade too many versions at once, as well as some problems with the unirgy gift cert module. 

Off the top of my head, I’m guessing I need to read the release notes for every version between 1.1.6 and 1.3.2.2 and determine how many versions I can upgrade at one time.  Then before I try again, I need to upgrade the unirgy module, or possibly even disable it and reinstall after.

Would appreciate any guidance while I continue investigating.

Thanks!

Erik

 
Magento Community Magento Community
Magento Community
Magento Community
 
toocan
Member
 
Total Posts:  37
Joined:  2008-01-07
 

erik

hi did u manage to get this working im about to take the plunge myself

 
Magento Community Magento Community
Magento Community
Magento Community
 
gabrielk
Sr. Member
 
Avatar
Total Posts:  83
Joined:  2007-11-30
 

A bit belated, but @haveabyte:
Your first error is due to one of your modules, Unirgy’s Gift Certificates.  No experience with that one, but maybe someone in the support thread for that module can help.  What it looks like is the giftcert module is overriding a core function (isVirtual in the file app/code/core/Mage/Catalog/Model/Product/Type/Abstract.php) and the two aren’t compatible.

The second error is a common one, searching for “Table cataloginventory_stock_status already exists” will lead you to a fix for that error.  Chances are there’s a similar error that will crop up after you fix those two.  What I had to do when upgrading is edit app/code/core/Mage/CatalogInventory/sql/cataloginventory_setup/mysql4-upgrade-0.7.4-0.7.5.php

comment out

Mage::getModel('cataloginventory/stock_status')->rebuild();
Look for the line of code that says
CREATE TABLE `{$installer->getTable('cataloginventory_stock_status')}` (
and insert this new line before it
DROP TABLE IF EXISTS {$this->getTable('cataloginventory_stock_status')};
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top