Magento/Upgrade 1.4 to 1.7

Make Backup!!

Prequesits

php.ini

max_execution_time=18000
memory_limit = 300M

Links4Upgrade

http://duntuk.com/magento-upgrade

http://www.magentocommerce.com/wiki/groups/227/moving_magento_to_another_server

http://www.magentocommerce.com/wiki/3_-_store_setup_and_management/so_you_want_a_real_store_and_not_a_demo

http://turnkeye.com/blog/magento-upgrade-guide/

http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/magento_1.5_to_1.6_upgrade

http://www.expertmagentodevelopers.com/blog/magento-1-6-upgrade-errors-with-solutions/

To Change Shop-URL

see Table `core_config_data`, Path=web/unsecure/base_url and web/secure/base_url

Install Magento 1.7

Install a fresh 1.7, but we use our old db from 1.4. Our old shop (1.4) is in bsshop_fail

http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/installing_magento_via_shell_ssh

mkdir bsshop
cd bsshop
wget http://www.magentocommerce.com/downloads/assets/1.7.0.2/magento-1.7.0.2.tar.gz
tar -zxvf magento-1.7.0.2.tar.gz
mv magento/* magento/.htaccess .
chmod -R o+w media var
chmod o+w app/etc
rm -rf magento/ magento-1.7.0.2.tar.gz

cp -Ra ../bsshop_fail/app/etc/local.xml app/etc/

optional in local.xml, set DB/cache-prefix...

import our data from 1.4

cp -Ra ../bsshop_fail/app/design/frontend/default/bienenschwarm app/design/frontend/default/
cp -Ra ../bsshop_fail/skin/frontend/default/bienenschwarm skin/frontend/default/
cp -Ra ../bsshop_fail/media/feed/ media/
cp -Ra ../bsshop_fail/media/catalog media/
cp -Ra ../bsshop_fail/media/sales/ media/
cp -Ra ../bsshop_fail/media/laden/ media/
chmod -R o+w media var

redirect as /catalog was the very old shop

cp -Ra ../bsshop_fail/catalog/ catalog/

chmod +x mage
./mage mage-setup .
./mage config-set preferred_state stable
./mage sync

reinstall all packages, overwrites rights...

//not ./mage install http://connect20.magentocommerce.com/community Mage_All_Latest --force

install some packages

./mage install community Dull_Uploader
./mage install community market_ready_germany
./mage install community magento_easy_lightbox
./mage install community DebitPayment
./mage install community ET_AdvancedCompare
./mage install community Fooman_GoogleAnalyticsPlus

update sql

delete from cms_block_store where block_id = 8 and store_id = 1;
DELETE FROM `sales_bestsellers_aggregated_daily` WHERE store_id =0;
DELETE FROM `sales_bestsellers_aggregated_monthly` WHERE store_id =0;
DELETE FROM `sales_bestsellers_aggregated_yearly` WHERE store_id =0;

ignore errors

php shell/indexer.php reindexall
/etc/init.d/apache2 restart

Open your shop with your browser magento now tries to upgrade your DB....

Known Problems

First Error: Press F5 ;-)

Customer_setup/mysql4-upgrade-1.5.9.9-1.6.0.0.php

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-1855' for key 'UNQ_BY_CUSTOMER'

mysql4-upgrade-1.4.0.20-1.4.0.21.php

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`magento1417_2`.<result 2 when explaining filename '#sql-751_b73f'>, CONSTRAINT `FK_PRODUCT_ORDERED_AGGREGATED_DAILY_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON )

data-upgrade-1.6.0.0.0-1.6.0.0.1.php

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails `magento1417_2`.`cms_page_store`, CONSTRAINT `FK_CMS_PAGE_STORE_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE)

More ...

remove from cms_block_store -> footer_links (id=8)delete from cms_block_store where block_id = 8 and store_id = 1

Add cms_block=footer_links to your store later again!!