当我试图将magento网站从服务器迁移到localhost时出错


Getting error when i am trying to migrate magento website from server to localhost

我正在尝试将我的实时网站设置到localhost中,我收到了这些错误,任何人都可以帮助这个吗

Error in file: "G:'test'apps'magento'htdocs'app'code'core'Mage'Reports'sql'reports_setup'upgrade-1.6.0.0-1.6.0.0.1.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'report_viewed_product_aggregated_daily' already exists
Trace:
#0 G:'test'apps'magento'htdocs'app'code'core'Mage'Core'Model'Resource'Setup.php(645): Mage::exception('Mage_Core', 'Error in file: ...')
#1 G:'test'apps'magento'htdocs'app'code'core'Mage'Core'Model'Resource'Setup.php(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb('upgrade', '1.6.0.0', '1.6.0.0.1')
#2 G:'test'apps'magento'htdocs'app'code'core'Mage'Core'Model'Resource'Setup.php(320): Mage_Core_Model_Resource_Setup->_upgradeResourceDb('1.6.0.0', '1.6.0.0.1')
#3 G:'test'apps'magento'htdocs'app'code'core'Mage'Core'Model'Resource'Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 G:'test'apps'magento'htdocs'app'code'core'Mage'Core'Model'App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 G:'test'apps'magento'htdocs'app'code'core'Mage'Core'Model'App.php(343): Mage_Core_Model_App->_initModules()
#6 G:'test'apps'magento'htdocs'app'Mage.php(684): Mage_Core_Model_App->run(Array)
#7 G:'test'apps'magento'htdocs'index.php(87): Mage::run('', 'store')

它清楚地表明,report_viewed_product_aggregated_daily已经存在。因此,您需要跳过此表,或者清除数据库,然后再次尝试导入。

更新

错误来自该列的唯一索引。它以前是null,所以MySQL忽略了唯一索引。它将过去默认为NULL的列更改为默认为非NULL。

ALTER TABLE `report_compared_product_index` MODIFY COLUMN `customer_id` int UNSIGNED NOT NULL COMMENT '';

最好的选择是删除文件G:'test'apps'magento'htdocs'app'code'core'Mage'Reports'sql'reports_setup'upgrade-1.6.0.0-1.6.0.0.1.php,或者截断(空)该表,我们不需要该数据。

欲了解更多信息,请点击此处