Thumbs_Up Gem with Rails: Problems with `Having`
<p>I'm using the <code>thumbs_up</code> gem for voting and am getting the following SQL error:</p>

<pre><code>SQLite3::SQLException: a GROUP BY clause is required before HAVING: SELECT "rules".* FROM "rules" HAVING plusminus_tally &gt;= 100
</code></pre>

<p>I have the following definitions in my controller:</p>

<pre><code>  @rules = Rule.where(approved: true).plusminus_tally.order("plusminus_tally DESC")
  @manrules = Rule.having('plusminus_tally &gt;= 100')
  @manguidelines = Rule.having('plusminus_tally &lt; 100')
</code></pre>

<p>The error is called on my <code>erb</code> here:</p>

<pre><code>  &lt;% @manruless.each do |rule| %&gt;  &lt;&lt;&lt;&lt;ERROR CALLED ON THIS LINE
    ...
  &lt;% end %&gt;
</code></pre>

<p>Just for comparison's sake, I tried it with <code>@rules</code> instead of <code>@manrules</code> and it worked fine, so the only error should be in my controller statements using <code>having</code>.  Can anyone help me fix this?</p>