Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

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