title: Behavior Difference between find('count') and find('all') cakePHP
body: <p>I am having an odd problem in CakePHP where </p>
  
  <pre><code>$this-&gt;something-&gt;find('count'); 
  </code></pre>
  
  <p>works perfectly, yet </p>
  
  <pre><code>$this-&gt;something-&gt;find('all'); 
  </code></pre>
  
  <p>returns nothing (not even an empty array, any errors, or anything).</p>
  
  <p>edit: turns out I am getting an sql error: "SQL Error: 1054: Unknown column" - for a column that does indeed exist. (users.display_name in the sql query below):</p>
  
  <pre><code>SELECT item.id, item.name, item.description, item.user_id, users.display_name FROM item LEFT JOIN users ON (item.user_id = users.id);
  </code></pre>
  
  <p>I also tried using findAllBy as well as paginate (paginate is actually what I am trying to do - although from what I've gathered, paginate and find('all') are pretty similar in functionality). </p>
  
  <p>The odd thing is that find('all') works everywhere else - it's just in this specific controller that it is acting odd. I am not getting any errors, simply an empty result.</p>
  
  <p>I'm thinking that I may be overlooking something quite simple, but any help is appreciated. Thanks!</p>