Magento Forum

   
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘tax_calculation_rate’ already exists
 
kekoh
Jr. Member
 
Total Posts:  3
Joined:  2009-05-21
 

Error in file: “/var/www/vhosts/site.com/subdomains/store/httpdocs/app/code/core/Mage/Tax/sql/tax_setup/mysql4-upgrade-0.7.6-0.7.7.php” - SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘tax_calculation_rate’ already exists
Trace:
#0 /var/www/vhosts/site.com/subdomains/store/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(292): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 /var/www/vhosts/site.com/subdomains/store/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(179): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’upgrade’, ‘0.7.6’, ‘0.7.8’)
#2 /var/www/vhosts/site.com/subdomains/store/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(146): Mage_Core_Model_Resource_Setup->_upgradeResourceDb(’0.7.6’, ‘0.7.8’)
#3 /var/www/vhosts/site.com/subdomains/store/httpdocs/app/code/core/Mage/Core/Model/Resource/Setup.php(121): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /var/www/vhosts/site.com/subdomains/store/httpdocs/app/code/core/Mage/Core/Model/Config.php(263): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /var/www/vhosts/site.com/subdomains/store/httpdocs/app/code/core/Mage/Core/Model/App.php(263): Mage_Core_Model_Config->init(Array)
#6 /var/www/vhosts/site.com/subdomains/store/httpdocs/app/Mage.php(434): Mage_Core_Model_App->init(’’, ‘store’, Array)
#7 /var/www/vhosts/site.com/subdomains/store/httpdocs/app/Mage.php(455): Mage::app(’’, ‘store’, Array)
#8 /var/www/vhosts/site.com/subdomains/store/httpdocs/index.php(65): Mage::run()
#9 {main}

can someone help me with this, I can delete the base table. would greatly appreciate it, thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
sixsicsix
Jr. Member
 
Total Posts:  23
Joined:  2009-08-14
 

Go into your files and rename

app/code/core/Mage/Tax/sql/tax_setup/mysql4-upgrade-0.7.6-0.7.7.php

to

app/code/core/Mage/Tax/sql/tax_setup/mysql4-upgrade-0.7.6-0.7.7.php_

With an underscore at the end. This skips where the upgrade bugs, and it will finish the upgrade. Do this for each file it hangs on. Make sure to reload your DOMAIN, not the ERROR page.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top