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

[vinhbui]

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";}

[iweb_p3mbo]

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'

[kalai0291]

code : core_setup

version: 1.6.0.6

data version : null

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