title: Magento: receiving "table exists / error in file" error when viewing a page
body: <p>Running a clean install of Magento 1.8.1 with sample data. I've had a ton of issues with this whole thing. My current issue is a blank page when viewing a category. The page either loads blank, or removes all function of the previous page with a url change.</p>
  
  <p>No errors appear when viewing the page. Problem currently persists on all navigational categories.</p>
  
  <p>Viewing the "Reports" I find an error....</p>
  
  <pre><code>a:5:{i:0;s:263:"Error in file: "/data/9/3/59/144/3385633/user/3775743/htdocs/enigme/app/code/core/Mage/Catalog/sql/catalog_setup/upgrade-1.6.0.0.9-1.6.0.0.10.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'catalog_product_entity_group_price' already exists";i:1;s:1196:"
  
  #0 /data/9/3/59/144/3385633/user/3775743/htdocs/enigme/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception('Mage_Core', 'Error in file: ...')
  
  #1 /data/9/3/59/144/3385633/user/3775743/htdocs/enigme/app/code/core/Mage/Core/Model/Resource/Setup.php(437): Mage_Core_Model_Resource_Setup-&gt;_modifyResourceDb('upgrade', '1.6.0.0.9', '1.6.0.0.18')
  
  #2 /data/9/3/59/144/3385633/user/3775743/htdocs/enigme/app/code/core/Mage/Core/Model/Resource/Setup.php(320): Mage_Core_Model_Resource_Setup-&gt;_upgradeResourceDb('1.6.0.0.9', '1.6.0.0.18')
  
  #3 /data/9/3/59/144/3385633/user/3775743/htdocs/enigme/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup-&gt;applyUpdates()
  
  #4 /data/9/3/59/144/3385633/user/3775743/htdocs/enigme/app/code/core/Mage/Core/Model/App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()
  
  #5 /data/9/3/59/144/3385633/user/3775743/htdocs/enigme/app/code/core/Mage/Core/Model/App.php(343): Mage_Core_Model_App-&gt;_initModules()
  
  #6 /data/9/3/59/144/3385633/user/3775743/htdocs/enigme/app/Mage.php(684): Mage_Core_Model_App-&gt;run(Array)
  
  #7 /data/9/3/59/144/3385633/user/3775743/htdocs/enigme/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";}
  </code></pre>
  
  <p>I've seen this error now on a magento db w/o sample data as well as WITH the sample data. I currently have 3 weeks remaining on this project and after convincing them to switch from opencart to something more "functional" the client refuses to use anything but Magento, does not want to switch to something else <em>again</em>. WHAT IS GOING ON?</p>
  
  <p>Website for reference: <a href="http://enigmedesigns.com" rel="nofollow">http://enigmedesigns.com</a></p>
  
  <p>EDIT: I have attempted flushing the catch, disabling compilation, adding <code>ini_set('display_errors', 1);</code> to index.php, FULL reinstall, category/product deletion, I'm stumped.</p>