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

Magnento isn’t working anymore. Just launched site Help! 
 
proteinshake
Member
 
Total Posts:  42
Joined:  2008-05-12
 

Hi, I have just launched my site and began running ads and now my website isn’t working. I haven’t changed any files since it was running. Here is the Error:

Error in file: “/public_html/app/code/core/Mage/Core/sql/core_setup/mysql4-install-0.8.0.php” - SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘core_resource’ already exists
Trace:
#0 /public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(278): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 /public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(158): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’install’, ‘’, ‘0.8.7’)
#2 /public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(144): Mage_Core_Model_Resource_Setup->_installResourceDb(’0.8.7’)
#3 /public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(111): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /public_html/app/code/core/Mage/Core/Model/Config.php(195): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /public_html/app/code/core/Mage/Core/Model/App.php(208): Mage_Core_Model_Config->init(Array)
#6 //public_html/app/Mage.php(404): Mage_Core_Model_App->init(’’, ‘store’, Array)
#7 /public_html/app/Mage.php(423): Mage::app(’’, ‘store’, Array)
#8 /public_html/index.php(40): Mage::run()
#9 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
jenks
Member
 
Total Posts:  37
Joined:  2008-06-03
Michigan
 

have you attempted an update? It seems to me the file it states in the beginning is only used on setup. Do you have a url I can see to where this is coming up?

 
Magento Community Magento Community
Magento Community
Magento Community
 
proteinshake
Member
 
Total Posts:  42
Joined:  2008-05-12
 

well now I did something really stupid. I deleted my database to it could rebuilt and lost all of my products. I really dont even know what to do now i’m so devastated. About 2 months worth of work down the drain.

 
Magento Community Magento Community
Magento Community
Magento Community
 
proteinshake
Member
 
Total Posts:  42
Joined:  2008-05-12
 

I also can’t even login now after that.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Unirgy
Guru
 
Avatar
Total Posts:  478
Joined:  2007-09-07
 

@proteinshake: you sure no backup exists? most hostings have at least one copy db backup services

 
Magento Community Magento Community
Magento Community
Magento Community
 
proteinshake
Member
 
Total Posts:  42
Joined:  2008-05-12
 

Ok… I can log in now. Anyone know if there is any way I can get my products back after deleting the database?

 
Magento Community Magento Community
Magento Community
Magento Community
 
proteinshake
Member
 
Total Posts:  42
Joined:  2008-05-12
 
Saharian - 26 June 2008 09:32 AM

@proteinshake: you sure no backup exists? most hostings have at least one copy db backup services

I did export my database before deleting it, but It seems that the file is corrupt:

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN”
“http://www.w’ at line 1

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