This is my website (www.4happydays.com)

yesterday till noon it was working properly. but after that i got this error...

Error in file: "/home/happydays/public_html/app/code/core/Mage/Core/sql/core_setup/install-" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'core_resource' already exists

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

this is the second time i am getting this error last time i uploaded the backup i had earlier,but i am facing this problem again and again.. This time i lost all my tables from the database... please tell me what would be the possible cause for this.. is there anything in the template i have used... ??

  • Ther are lot of issue in your instance
    – Amit Bera
    Nov 30, 2014 at 10:06
  • Why did you list both Magento 1.6 and 1.9? Nov 30, 2014 at 14:07

2 Answers 2


If there were no any changes in Magento code (according to the question it just suddenly occurred for no reason), please contact your host, as the only possible reason would be database corruption or filesystem corruption. Check it with your hosting support and request them to restore the last consistent backup of your site.

Otherwise (in case you installed extensions, changed themes or someone was fixing Magento code), please provide more details.

  • yes the problem is with the host..thanks Alex..
    – Pavan
    Dec 3, 2014 at 16:14

Your issue is the same as this one: https://stackoverflow.com/questions/17147811/sql-error-core-resource-already-exists

Check solutions described in answers.

Not the answer you're looking for? Browse other questions tagged or ask your own question.