- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-20-2016
10:11 AM
11-20-2016
10:11 AM
Problem to upgrade 1.9.2.1 to 1.9.3.1
Hi everyone
I have a one magento site (1.9.2.1) and now I trying to upgrade 1.9.3.1
I create a new database copy and setting it in local.xml
And upload new version in folder (/1/) and copy theme and extension to new directory.
Now, when go to new url I see this error:
There has been an error processing your request Error in file: "/home/simurghd/public_html/websites/****.com/1/app/code/core/Mage/Sales/sql/sales_setup/upgrade-1.6.0.9-1.6.0.10.php" - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'simurghd_newdb2.sales_bestsellers_aggregated_daily' doesn't exist, query was: DESCRIBE `sales_bestsellers_aggregated_daily` Trace: #0 /home/simurghd/public_html/websites/****.com/1/app/code/core/Mage/Core/Model/Resource/Setup.php(644): Mage::exception('Mage_Core', 'Error in file: ...') #1 /home/simurghd/public_html/websites/****.com/1/app/code/core/Mage/Core/Model/Resource/Setup.php(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb('upgrade', '1.6.0.9', '1.6.0.10') #2 /home/simurghd/public_html/websites/****.com/1/app/code/core/Mage/Core/Model/Resource/Setup.php(320): Mage_Core_Model_Resource_Setup->_upgradeResourceDb('1.6.0.9', '1.6.0.10') #3 /home/simurghd/public_html/websites/****.com/1/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates() #4 /home/simurghd/public_html/websites/****.com/1/app/code/core/Mage/Core/Model/App.php(428): Mage_Core_Model_Resource_Setup::applyAllUpdates() #5 /home/simurghd/public_html/websites/****.com/1/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Model_App->_initModules() #6 /home/simurghd/public_html/websites/****.com/1/app/Mage.php(684): Mage_Core_Model_App->run(Array) #7 /home/simurghd/public_html/websites/****.com/1/index.php(85): Mage::run('', 'store') #8 {main} Error log record number: 588906762184 Magento is a trademark of Magento Inc. Copyright © 2016 Magento Inc.
and error log is:
a:5:{i:0;s:323:"Error in file: "/home/simurghd/public_html/websites/****.com/1/app/code/core/Mage/Sales/sql/sales_setup/upgrade-1.6.0.9-1.6.0.10.php" - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'simurghd_newdb2.sales_bestsellers_aggregated_daily' doesn't exist, query was: DESCRIBE `sales_bestsellers_aggregated_daily`";i:1;s:1172:"#0 /home/simurghd/public_html/websites/****.com/1/app/code/core/Mage/Core/Model/Resource/Setup.php(644): Mage::exception('Mage_Core', 'Error in file: ...') #1 /home/simurghd/public_html/websites/****.com/1/app/code/core/Mage/Core/Model/Resource/Setup.php(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb('upgrade', '1.6.0.9', '1.6.0.10') #2 /home/simurghd/public_html/websites/*****.com/1/app/code/core/Mage/Core/Model/Resource/Setup.php(320): Mage_Core_Model_Resource_Setup->_upgradeResourceDb('1.6.0.9', '1.6.0.10') #3 /home/simurghd/public_html/websites/****.com/1/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates() #4 /home/simurghd/public_html/websites/****.com/1/app/code/core/Mage/Core/Model/App.php(428): Mage_Core_Model_Resource_Setup::applyAllUpdates() #5 /home/simurghd/public_html/websites/****.com/1/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Model_App->_initModules() #6 /home/simurghd/public_html/websites/****.com/1/app/Mage.php(684): Mage_Core_Model_App->run(Array) #7 /home/simurghd/public_html/websites/****.com/1/index.php(85): Mage::run('', 'store') #8 {main}";s:3:"url";s:3:"/1/";s:11:"script_name";s:12:"/1/index.php";s:4:"skin";s:7:"default";}
Please help to fix this problem
Thanks