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

Problems installing on Gigahost.dk
 
redneck_dk
Jr. Member
 
Total Posts:  3
Joined:  2013-01-23
 

Getting theese errors:

Error in file: “/home/www/redneck.dk/magento/app/code/core/Mage/Sales/sql/sales_setup/install-1.6.0.0.php” - SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘sales_flat_order’ already exists

Trace:
#0 /home/www/redneck.dk/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 /home/www/redneck.dk/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(421): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’install’, ‘’, ‘1.6.0.7’)
#2 /home/www/redneck.dk/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(327): Mage_Core_Model_Resource_Setup->_installResourceDb(’1.6.0.7’)
#3 /home/www/redneck.dk/magento/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /home/www/redneck.dk/magento/app/code/core/Mage/Core/Model/App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /home/www/redneck.dk/magento/app/code/core/Mage/Core/Model/App.php(343): Mage_Core_Model_App->_initModules()
#6 /home/www/redneck.dk/magento/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#7 /home/www/redneck.dk/magento/index.php(87): Mage::run(’’, ‘store’)
#8 {main}

Any help?

Thanks John munch soerensen

 
Magento Community Magento Community
Magento Community
Magento Community
 
GoMageTeam
Guru
 
Avatar
Total Posts:  356
Joined:  2013-01-13
Warsaw, Poland
 

Hello,

This error means that the Sales extension tries to update its tables in the database, but they already exist, because they have been created earlier. If you have transferred Magento from one hosting to another one, you need to do the dump of the database again, but you should not do it using phpMyAdmin.  You should do it using either console, or System->Tools->Backup in the Magento admin panel. After these actions you should import the dump again. If the error has appeared after Magento upgrade, then you have updated it using Magento Connect. You should not do it this way.  Please, read the following information in order to update Magento correctly:

http://www.magentocommerce.com/boards/viewthread/310317/

 
Magento Community Magento Community
Magento Community
Magento Community
 
devromans
Jr. Member
 
Avatar
Total Posts:  18
Joined:  2012-04-05
 

@Monty22, you are very funny guy. You said that you are one of the best Magento developer, but: ”Base table or view already exists: 1050 Table ‘sales_flat_order’ already exists” and you said:

Try to set permission 755 for magento folder and index.php.

.
So how changing file permissions will help to resolve DB error?
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top