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

Install chocking on database install
 
intensity
Member
 
Total Posts:  48
Joined:  2008-11-22
 

I’m doing a new store installation at Dreamhost.  I have been able to install with them a week ago with minimal problems, but it did take a few tries to get it to work.  Now, I keep getting errors in the database installation/configuration part, but each time I get a different error, but they are all along the lines of this.

Error in file"_removed_/app/code/core/Mage/Sales/sql/sales_setup/mysql4-install-0.9.0.php" SQLSTATE[42S01]Base table or view already exists1050 Table 'sales_flat_quote' already exists

I’ve tried the install at least 5 times today and get the same kind of errors, but they aren’t the same everytime.  I drop the tables, erase Magento, redo the Magento file, and then try the install, and it fails every time.  Any help would be greatly appreciated.

Thanks, JR

 
Magento Community Magento Community
Magento Community
Magento Community
 
Roly
Sr. Member
 
Total Posts:  276
Joined:  2008-04-30
 

Have you import the sample data before doing the official installation through the browser?

 
Magento Community Magento Community
Magento Community
Magento Community
 
intensity
Member
 
Total Posts:  48
Joined:  2008-11-22
 

It’s funny.  A second before you posted this I finally got the install to work.

I’m not sure what you are talking about regarding the sample data?  Did I overlook something in the installation guide?

My assumption here as the to problem was that my db server was just too overloaded during the day and this was causing the installation package some problems.  But that’s just a guess.

 
Magento Community Magento Community
Magento Community
Magento Community
 
chinvelski
Jr. Member
 
Total Posts:  2
Joined:  2009-11-04
 

Hi people,

I have the same problem and my database is not overloaded.

Error in file: “E:\vhosts\xxx.com.br\httpdocs\magento\app\code\core\Mage\Catalog\sql\catalog_setup\mysql4-upgrade-0.7.0-0.7.1.php” - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘customer_group_id’
Trace:
#0 E:\vhosts\xxx.com.br\httpdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(292): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 E:\vhosts\xxx.com.br\httpdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(179): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’upgrade’, ‘0.7.0’, ‘0.7.69’)
#2 E:\vhosts\xxx.com.br\httpdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(146): Mage_Core_Model_Resource_Setup->_upgradeResourceDb(’0.7.0’, ‘0.7.69’)
#3 E:\vhosts\xxx.com.br\httpdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(121): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 E:\vhosts\xxx.com.br\httpdocs\magento\app\code\core\Mage\Core\Model\Config.php(263): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 E:\vhosts\xxx.com.br\httpdocs\magento\app\code\core\Mage\Core\Model\App.php(263): Mage_Core_Model_Config->init(Array)
#6 E:\vhosts\xxx.com.br\httpdocs\magento\app\Mage.php(434): Mage_Core_Model_App->init(’’, ‘store’, Array)
#7 E:\vhosts\xxx.com.br\httpdocs\magento\app\Mage.php(455): Mage::app(’’, ‘store’, Array)
#8 E:\vhosts\xxx.com.br\httpdocs\magento\index.php(65): Mage::run()
#9 {main}

Any help welcomed.
Thanks,
André C.
Florianópolis/SC

 
Magento Community Magento Community
Magento Community
Magento Community
 
fabiozc
Jr. Member
 
Total Posts:  3
Joined:  2008-01-29
 

exactly the same issue here on Dreamhost

Error in file: “[..]/app/code/core/Mage/Sales/sql/sales_setup/mysql4-install-0.9.0.php” - SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘sales_flat_quote’ already exists

André, se vc conseguir qualquer novidade, me avise

 
Magento Community Magento Community
Magento Community
Magento Community
 
chinvelski
Jr. Member
 
Total Posts:  2
Joined:  2009-11-04
 

Fabio,

I skirted the problem. For some reason, i don´t know exactly, occurs a timeout when these files were being processed, then when you try again (refreshing the page) this file is reprocessed, from the begining, trying recreate the tables that have been created and this error occur.

You can try increase the timeout of the database. In my case (my hosting is locaweb (windows) and just them can change de configuration) then i skirted the problem editing every file with problem (you fix one of the files with problem than the problems hapen again in other file, until you fix all (i change around 6 or 7)). What is necessary to do is before every create table in these files of instalation with problem put an drop table, or comment (or delete) the create tables for the tables that have been created.

Go to your file with problem:
Error in file: “[..]/app/code/core/Mage/Sales/sql/sales_setup/mysql4-install-0.9.0.php” - SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘sales_flat_quote’ already exists
And put a drop table for ‘sales_flat_quote’, the error will change grin .

Best regards,
André C.

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