title: Magento - Blank white screen search results. Many things broken
body: <p>Whenever a user searches, I get this error:</p>
  
  <pre><code>2012-06-26 11:05:21.671 [NOTICE] [208.69.120.120:48175-0#hostname] [STDERR] PHP Fatal error: Call to undefined method Mage_Catalog_Model_Resource_Product_Flat::getEntityTablePrefix() in /chroot/home/SITENAME/DOMAIN.COM/html/app/code/core/Mage/Eav/Model/Entity/Attribute/Abstract.php on line 505
  </code></pre>
  
  <p>And instead of the user's results appearing, they get a blank white page- no error on their end, no UI, just white. This was the first issue I noticed, but on the same day the following issues started coming up:</p>
  
  <ol>
  <li>White Search Results</li>
  <li>Sub-category product count for all sub-categories in layered nav is showing 0.</li>
  <li>Some customers can not view orders from their front-end UI when logged in.</li>
  <li>Our order export script is returning blank fields (1.7mb instead of 4.3).</li>
  <li>Our "Made-in-the-usa" and "best sellers" pages are returning more products than they should.</li>
  </ol>
  
  <p>Now, I know these are all incorrect because if I reindex the entire site, for some period while it is processing the index, all of the above works. However, when the index is complete, it all breaks again. The same day this happened we had an error page appear that stated one of the tables had broken and should be repaired. We ran PHPMyAdmin's repair and optimize functions on all tables and it fixed that error- but all of these are still broken.</p>
  
  <p>Any ideas at all? Any ideas of what could be tried to fix this? I cant find this error anywhere- and the guys over at Nexcess haven't been able to find anything for this, either.</p>
  
  <p>Thank you for your time.</p>