title: Magento 1.8 - Advanced Search doesn't work
body: <p>I have found a strange bug in the latest release of magento: Advanced Search tool doesn't work properly.</p>
  
  <p>What have I done:</p>
  
  <ul>
  <li>Install a fresh copy of magento</li>
  <li>Added a product called Test 1 by the administration page</li>
  <li>Reindex all</li>
  <li>Cleared all caches</li>
  <li>At the frontend page:
  
  <ul>
  <li>Open the Advanced Search Page</li>
  <li>Search the "Test 1" product that you have added before in the catalog
  
  <ul>
  <li>No result </li>
  </ul></li>
  </ul></li>
  </ul>
  
  <p>I have no result using as search attribute the "Name" of the product.</p>
  
  <p>Seems that another user has the same issue: <a href="https://stackoverflow.com/questions/18587673/magento-advanced-search-returns-no-results">Magento advanced search returns no results</a></p>
  
  <p>If you see the entity table in the database, you can see the attribute "71" with the name of the product. Attribute 71 is the "Name" Magento Attribute.</p>
  
  <p><strong>Catalog Product Varchar Attribute Backend Table</strong></p>
  
  <p><img src="https://i.stack.imgur.com/YNu1I.jpg" alt="Catalog Product Varchar Attribute Backend Table"></p>
  
  <p>If I try to read the Magento code at app/code/core/Mage/CatalogSearch/Model/Advanced.php and debug it, I can see this command:</p>
  
  <pre><code>$this-&gt;getProductCollection()-&gt;addFieldsToFilter($allConditions);
  
  array(1) {
    ["catalog_product_entity_varchar"] =&gt; array(1) {
      [71] =&gt; array(1) {
        ["like"] =&gt; string(9) "%Test 1%"
      }
    }
  }
  </code></pre>
  
  <p>but Magento doesn't show me any result.</p>
  
  <p><strong>If I try to execute a search process using the SKU field, magento return the product!</strong></p>
  
  <pre><code>array(1) {
    ["catalog_product_entity"] =&gt; array(1) {
      ["sku"] =&gt; array(1) {
        ["like"] =&gt; string(6) "%test%"
      }
    }
  }
  </code></pre>
  
  <p>Is a Magento Bug?</p>
  
  <p>Update: If I add the default category to the list of the product categories, seems that it works. Is a normal Magento behaviour?</p>
  
  <p>thanks</p>