Magento News

 

Solid 1.1.x to 1.4.1.1 Upgrade Strategy

by edmondscommerce (Posted Thu, 14 Oct 2010 11:14:49 GMT)
Having some issues performing a solid upgrade from 1.1.6 to 1.4.1.1

It seems that the various Magento SQL update files plain don’t work when making a version jump this big.

For example:

app/code/core/Mage/Sales/sql/sales_setup/mysql4-upgrade-0.9.28-0.9.29.php

tries to add columns to a table that doesn’t exist – so somewhere this create tables SQL is missing, though how that is possible I’m not really sure.

I know you can just remove, rename or otherwise disable the particular steps that don’t work and then run the repair tool but this approach feels messy to me and I think it is just brewing up problems down the line.

What is your upgrade strategy?

Ideas we have had include –

manually fixing all the various upgrade file steps (for example some can be fixed by simply wrapping the SQL in:

Code:
SET foreign_key_checks = 0;
// the SQL in the file
SET foreign_key_checks = 1;

Those are the easy ones, others are more complex and could involve creating whole custom modules to override particular methods etc. It all starts to feel like a bit of a massive task.

Other options are to simply give the client a fresh clean 1.4.1.1 with all their extensions and themes etc set up and then import products, but then they don’t have customer or order data

What is your preferred strategy for upgrades?


http://magento-forum.co.uk/viewtopic.php?f=5&t=454#p1628

Magento Forum

Possibly Related Posts:


 

Leave a Reply