Magento Forum

   
Problems upgrading Magento 1.4.1 to 1.7.0
 
Will Craig
Jr. Member
 
Total Posts:  6
Joined:  2011-02-18
 

Hi,

We are trying to update Magento from 1.4.1 to the latest stable release.

I have tried the down-loader, but get a series of errors, and it sticks in maintenance mode after the commit. When I remove maintenance file, the site works as the original install.

So I uploaded Magento to a different domain on the same server. I asked the host to migrate the DB as an exact clone using SSH, created a blank db and configured installation to use this db.

Then I copied the full package on top of the Magento installation. All at this point is fine, as in we get a successful 1.7.0 installation.

I then got MySQL errors to do with missing columns, so ran the migration tool.

The migration tool the resulted in the following errors, would the community be so kind as to assist in a resolution to the steps it failed to complete, these are as follows:

From the tool:

Error #1075: Incorrect table definition; there can be only one auto column and it must be defined as a key on SQL: ALTER TABLE `mg_catalogsearch_fulltext` ADD COLUMN `fulltext_id` int(10) unsigned NOT NULL auto_increment FIRST
Error #1067: Invalid default value for ‘created_at’ on SQL: ALTER TABLE `mg_salesrule_coupon` ADD COLUMN `created_at` timestamp NOT NULL DEFAULT ‘CURRENT_TIMESTAMP’ AFTER `is_primary`
Error #1075: Incorrect table definition; there can be only one auto column and it must be defined as a key on SQL: ALTER TABLE `mg_tax_calculation` ADD COLUMN `tax_calculation_id` int(11) NOT NULL auto_increment FIRST
Error #1005: Can’t create table ‘./honey4d_martiledb2/#sql-441b1_4834c4.frm’ (errno: 150) on SQL: ALTER TABLE `mg_downloadable_link_purchased` ADD CONSTRAINT `FK_MG_DL_LNK_PURCHASED_CSTR_ID_MG_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `mg_customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE
Error #1005: Can’t create table ‘./honey4d_martiledb2/#sql-441b1_4834c4.frm’ (errno: 150) on SQL: ALTER TABLE `mg_downloadable_link_purchased_item` ADD CONSTRAINT `FK_B235119BEAE7DC9F9B423F9A11BE0A42` FOREIGN KEY (`order_item_id`) REFERENCES `mg_sales_flat_order_item` (`item_id`) ON DELETE SET NULL ON UPDATE CASCADE
Error #1005: Can’t create table ‘./honey4d_martiledb2/#sql-441b1_4834c4.frm’ (errno: 150) on SQL: ALTER TABLE `mg_tag` ADD CONSTRAINT `FK_MG_TAG_FIRST_CUSTOMER_ID_MG_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`first_customer_id`) REFERENCES `mg_customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE NO ACTION

From frontend:

Error in file: “/home/honey4d/public_html/app/code/core/Mage/Catalog/sql/catalog_setup/mysql4-upgrade-1.5.9.9-1.6.0.0.php” - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘website_date’

Trace:

#0 /home/honey4d/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 /home/honey4d/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’upgrade’, ‘1.4.0.0.44’, ‘1.6.0.0.14’)
#2 /home/honey4d/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(320): Mage_Core_Model_Resource_Setup->_upgradeResourceDb(’1.4.0.0.44’, ‘1.6.0.0.14’)
#3 /home/honey4d/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /home/honey4d/public_html/app/code/core/Mage/Core/Model/App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /home/honey4d/public_html/app/code/core/Mage/Core/Model/App.php(343): Mage_Core_Model_App->_initModules()
#6 /home/honey4d/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#7 /home/honey4d/public_html/index.php(87): Mage::run(’’, ‘store’)
#8 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
Will Craig
Jr. Member
 
Total Posts:  6
Joined:  2011-02-18
 

Just a bit of additional information.

I fixed a few of these by checking the database tables against each other manually, and using phpMyAdmin to set them up.

I have ran the tool again and the new errors are:

Error #1005: Can’t create table ‘./honey4d_martiledb2/#sql-441b1_490bcc.frm’ (errno: 150) on SQL: ALTER TABLE `mg_downloadable_link_purchased` ADD CONSTRAINT `FK_MG_DL_LNK_PURCHASED_CSTR_ID_MG_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `mg_customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE
Error #1005: Can’t create table ‘./honey4d_martiledb2/#sql-441b1_490bcc.frm’ (errno: 150) on SQL: ALTER TABLE `mg_downloadable_link_purchased_item` ADD CONSTRAINT `FK_B235119BEAE7DC9F9B423F9A11BE0A42` FOREIGN KEY (`order_item_id`) REFERENCES `mg_sales_flat_order_item` (`item_id`) ON DELETE SET NULL ON UPDATE CASCADE
Error #1005: Can’t create table ‘./honey4d_martiledb2/#sql-441b1_490bcc.frm’ (errno: 150) on SQL: ALTER TABLE `mg_tag` ADD CONSTRAINT `FK_MG_TAG_FIRST_CUSTOMER_ID_MG_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`first_customer_id`) REFERENCES `mg_customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE NO ACTION

However the frontend still has the same issues, although I can now access the downloader tool!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Will Craig
Jr. Member
 
Total Posts:  6
Joined:  2011-02-18
 

Ok the down-loader now has less errors, and no MySQL ones, but still quite a few:

CONNECT ERROR: Package ‘Mage_All_Latest’ is invalid
‘./pkginfo/Mage_All_Latest.txt’ already exists
Package ‘Interface_Adminhtml_Default’ is invalid
‘./app/design/adminhtml/default/default/layout/admin.xml’ already exists
Package ‘Interface_Frontend_Default’ is invalid
‘./app/design/frontend/default/default/etc/widget.xml’ already exists
Package ‘Interface_Install_Default’ is invalid
‘./app/design/install/default/default/layout/main.xml’ already exists
Package ‘Mage_Centinel’ is invalid
‘./app/code/core/Mage/Centinel/Block/Adminhtml/Validation/Form.php’ already exists
Package ‘Interface_Frontend_Base_Default’ is invalid
‘./app/design/frontend/base/default/etc/widget.xml’ already exists
Package ‘Phoenix_Moneybookers’ is invalid
‘./app/code/community/Phoenix/Moneybookers/Block/Form.php’ already exists
Package ‘Mage_Compiler’ is invalid
‘./app/code/core/Mage/Compiler/Block/Process.php’ already exists
Package ‘Magento_Mobile’ is invalid
‘./app/code/core/Mage/XmlConnect/Block/Adminhtml/History/Grid.php’ already exists
Package ‘Mage_Core_Adminhtml’ is invalid
‘./app/code/core/Mage/Adminhtml/Block/Abstract.php’ already exists
Package ‘Mage_Core_Modules’ is invalid
‘./app/code/core/Mage/Admin/Helper/Data.php’ already exists
Package ‘Lib_Js_Ext’ is invalid
‘./js/extjs/css/README.txt’ already exists
Package ‘Lib_Js_TinyMCE’ is invalid
‘./js/tiny_mce/classes/AddOnManager.js’ already exists
Package ‘Lib_Varien’ is invalid
‘./lib/Varien/Autoload.php’ already exists
Package ‘Lib_Google_Checkout’ is invalid
‘./lib/googlecheckout/googlecart.php’ already exists
Package ‘Lib_Js_Calendar’ is invalid
‘./js/calendar/calendar-blue.css’ already exists
Package ‘Lib_Js_Mage’ is invalid
‘./js/lib/FABridge.js’ already exists
Package ‘Lib_ZF’ is invalid
‘./lib/Zend/Acl/Assert/Interface.php’ already exists
Package ‘Lib_Js_Prototype’ is invalid
‘./js/prototype/debug.js’ already exists
Package ‘Lib_ZF_Locale’ is invalid
‘./lib/Zend/Locale/Data/Translation.php’ already exists

 
Magento Community Magento Community
Magento Community
Magento Community
 
charismeky
Jr. Member
 
Total Posts:  9
Joined:  2011-03-29
 

same here. did you solve the problem and if so how.
thanks and kind regards

 
Magento Community Magento Community
Magento Community
Magento Community
 
Will Craig
Jr. Member
 
Total Posts:  6
Joined:  2011-02-18
 

No sorry this is still an outstanding issue. I will post any resolutions but in the meantime if anybody has any suggestions they will be much appreciated.

 
Magento Community Magento Community
Magento Community
Magento Community
 
zafarshaikh92
Jr. Member
 
Total Posts:  7
Joined:  2012-01-10
India
 

Hi,

I tried but still i am getting error. Can you please provide me a referral website or guide. So, that i can able to upgrade Magento 1.4.1 to 1.7.0.

Thanks in advance.

quality blog | Cheap Guest posting service

 
Magento Community Magento Community
Magento Community
Magento Community
 
GoMageTeam
Guru
 
Avatar
Total Posts:  356
Joined:  2013-01-13
Warsaw, Poland
 

Hello,

You can find the useful information how to solve the issue here:

http://www.magentocommerce.com/boards/viewreply/429219/

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