php - 将 Magento CE 1.6.2 升级到 1.9.1 时出错

Question

我正在尝试升级 Magento 但出现此错误:

a:5:{i:0;s:1275:"Error in file: "/backup/home2/devnoc/public_html/app/code/core/Mage/Sales/data/sales_setup/data-upgrade-1.6.0.4-1.6.0.5.php" - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'main.base_tax_refunded' in 'field list', query was: UPDATE `sales_flat_order_item` AS `main`
 INNER JOIN (SELECT SUM(citem.row_total) AS `amount_refunded`, SUM(citem.base_row_total) AS `base_amount_refunded`, SUM(citem.base_tax_amount) AS `base_tax_refunded`, SUM(citem.discount_amount) AS `discount_refunded`, SUM(citem.base_discount_amount) AS `base_discount_refunded`, `oitem`.`item_id` FROM `sales_flat_creditmemo_item` AS `citem`
 LEFT JOIN `sales_flat_creditmemo` AS `c` ON c.entity_id = citem.parent_id
 LEFT JOIN `sales_flat_order` AS `o` ON o.entity_id = c.order_id
 LEFT JOIN `sales_flat_order_item` AS `oitem` ON oitem.order_id = o.entity_id AND oitem.product_id=citem.product_id GROUP BY `oitem`.`item_id`) AS `selected`
SET `main`.`amount_refunded` = `selected`.`amount_refunded`, `main`.`base_amount_refunded` = `selected`.`base_amount_refunded`, `main`.`base_tax_refunded` = `selected`.`base_tax_refunded`, `main`.`discount_refunded` = `selected`.`discount_refunded`, `main`.`base_discount_refunded` = `selected`.`base_discount_refunded`
WHERE (main.item_id = selected.item_id)";i:1;s:925:"#0 /backup/home2/devnoc/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception('Mage_Core', 'Error in file: ...')
#1 /backup/home2/devnoc/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(407): Mage_Core_Model_Resource_Setup->_modifyResourceDb('data-upgrade', '1.6.0.4', '1.6.0.8')
#2 /backup/home2/devnoc/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(286): Mage_Core_Model_Resource_Setup->_upgradeData('1.6.0.4', '1.6.0.8')
#3 /backup/home2/devnoc/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(269): Mage_Core_Model_Resource_Setup->applyDataUpdates()
#4 /backup/home2/devnoc/public_html/app/code/core/Mage/Core/Model/App.php(351): Mage_Core_Model_Resource_Setup::applyAllDataUpdates()
#5 /backup/home2/devnoc/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#6 /backup/home2/devnoc/public_html/index.php(87): Mage::run('', 'store')
#7 {main}";s:3:"url";s:1:"/";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:3:"bsk";}

我从一个全新的 Magento 1.9.1 副本开始，并导入我的 1.6.2 数据库来运行更新。

如能就我需要采取的具体步骤提供任何帮助，我们将不胜感激。

Answer 1

我建议您使用 ssh。使用 ssh，您可以轻松更新 magento。在开始更新之前，请确保您有文件和数据库的备份。备份后转到安装 magento 的文件夹。假设文档路径是/var/www/html 然后使用这个命令去 html 文件夹。

cd /var/www/html

然后使用这个命令

./mage list-upgrades

你会看到这样的结果社区更新:

Mage_All_Latest: 1.6.2 => 1.9.1.0
Lib_Js_Mage: 1.6.2 => 1.9.1.0
Lib_Varien: 1.6.2 => 1.9.1.0

这意味着你的Magento将升级到1.9.1.0版本

输入此命令将升级 channel 更改为稳定版./mage config-set preferred_state 稳定

选择 channel 后，您可以使用以下命令将您的 Magento 升级到 Magento 1.9.x.x:

./mage upgrade-all --force

如果“./mage upgrade-all --force”不起作用，您可以尝试执行此命令:

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

您将在屏幕上看到升级包:

Package upgraded: community/Mage_Locale_en_US 1.9.1.0
Package upgraded: community/Lib_Mage 1.9.1.0
Package upgraded: community/Lib_ZF 1.11.1.0

现在您的文件已更新，但现在是更新数据库的时候了。但首先使用此命令删除缓存和 session 。

rm -rf var/cache var/session

现在运行这个命令。

php -f ./index.php

您可能需要运行此命令 2-3 次，但如果它立即显示结果，请在浏览器上运行管理 url。登录后，您可以在页脚看到升级版本。