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
