cancel
Showing results for 
Search instead for 
Did you mean: 

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'core_resource' already

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'core_resource' already

My site has been working for years then having maintenance, it is no longer working. browsering site, it get get error. checking log, it shows below. Please advise how to resolve this issue. Thanks.

 

a:5:{i:0;s:198:"Error in file: "/home/tko4e284/public_html/app/code/core/Mage/Core/sql/core_setup/install-1.6.0.0.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'core_resource' already exists";i:1;s:968:"#0 /home/tko4e284/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception('Mage_Core', 'Error in file: ...')

#1 /home/tko4e284/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(421): Mage_Core_Model_Resource_Setup->_modifyResourceDb('install', '', '1.6.0.4')

#2 /home/tko4e284/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(327): Mage_Core_Model_Resource_Setup->_installResourceDb('1.6.0.4')

#3 /home/tko4e284/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()

#4 /home/tko4e284/public_html/app/code/core/Mage/Core/Model/App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()

#5 /home/tko4e284/public_html/app/code/core/Mage/Core/Model/App.php(343): Mage_Core_Model_App->_initModules()

#6 /home/tko4e284/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)

#7 /home/tko4e284/public_html/index.php(87): Mage::run('', 'store')

#8 {main}";s:3:"url";s:1:"/";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";}

 

2 REPLIES

Re: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'core_resource' already

Hi,

What version of Magento are you using?

 

Can you run the following on your database and let me know what it comes back with?

 

SELECT * FROM `core_resource` WHERE `code` = 'core_setup'
Problem solved? Click Accept as Solution!
Magento Certified Developer Plus | www.iwebsolutions.co.uk | Magento Small Business Partner

Re: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'core_resource' already

code : core_setup

version: 1.6.0.6

data version : null

 

Above details are shown when I run the SQL in database phpmyadmin