cancel
Showing results for 
Search instead for 
Did you mean: 

Problem to upgrade 1.9.2.1 to 1.9.3.1

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

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