title: Magento SQLSTATE[42S01] error
body: <p>I've been having problems with my magento site.  It suddenly crashed, and locked me out from even entering admin.  I contacted our host to roll back our DB and nothing has changed.  I even deleted the tables with the errors as suggested and cleared my local cache and /var/cache/ and still nothing.  I have hundreds of products in the DB and don't want to flush them out, how can I fix this?</p>
  
  <blockquote>
    <p>Error in file:
    "/home/sppower6/public_html/app/code/core/Mage/Admin/sql/admin_setup/install-1.6.0.0.php"
    - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'admin_assert' already exists, query was: CREATE TABLE admin_assert (
    assert_id int UNSIGNED NOT NULL auto_increment COMMENT 'Assert ID' ,
    assert_type varchar(20) NULL default NULL COMMENT 'Assert Type' ,
    assert_data text NULL COMMENT 'Assert Data' , PRIMARY KEY (assert_id)
    ) COMMENT='Admin Assert Table' ENGINE=INNODB charset=utf8
    COLLATE=utf8_general_ci</p>
    
    <p>Trace:
    0 /home/sppower6/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(645):
    Mage::exception('Mage_Core', 'Error in file: ...')</p>
    
    <p>1 /home/sppower6/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(421):
    Mage_Core_Model_Resource_Setup->_modifyResourceDb('install', '',
    '1.6.1.1')</p>
    
    <p>2 /home/sppower6/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(327):
    Mage_Core_Model_Resource_Setup->_installResourceDb('1.6.1.1')</p>
    
    <p>3 /home/sppower6/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(235):
    Mage_Core_Model_Resource_Setup->applyUpdates()</p>
    
    <p>4 /home/sppower6/public_html/app/code/core/Mage/Core/Model/App.php(428):
    Mage_Core_Model_Resource_Setup::applyAllUpdates()</p>
    
    <p>5 /home/sppower6/public_html/app/code/core/Mage/Core/Model/App.php(354):
    Mage_Core_Model_App->_initModules()</p>
    
    <p>6 /home/sppower6/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)</p>
    
    <p>7 /home/sppower6/public_html/index.php(87): Mage::run('', 'store')</p>
    
    <p>8 {main}</p>
  </blockquote>