ruby-on-rails – 将表列添加到Group by子句 – Ruby on Rails

On another question我问我收到了一些指导,说我应该将列添加到我的group by子句中,我不知道该怎么做.请参阅下面的完整错误和PostsControll#index.

SELECT posts.*,count(*) as vote_total FROM "posts"   INNER JOIN "votes" ON votes.post_id = posts.id   GROUP BY votes.post_id ORDER BY created_at DESC LIMIT 5 OFFSET 0):

PostsController

def index
    @tag_counts = Tag.count(:group => :tag_name,:order => 'count_all DESC',:limit => 20)
       conditions,joins = {},:votes

    @ugtag_counts = Ugtag.count(:group => :ugctag_name,:votes

    @vote_counts = Vote.count(:group => :post_title,:limit => 20)
          conditions,:votes


       unless(params[:tag_name] || "").empty?
         conditions = ["tags.tag_name = ? ",params[:tag_name]]
         joins = [:tags,:votes]
       end
       @posts=Post.paginate(
                 :select => "posts.*,count(*) as vote_total",:joins => joins,:conditions=> conditions,:group => "votes.post_id",:order => "created_at DESC",:page => params[:page],:per_page => 5)
        @popular_posts=Post.paginate(
                 :select => "posts.*,:order => "vote_total DESC",:per_page => 3)

    respond_to do |format|
      format.html # index.html.erb
      format.xml  { render :xml => @posts }
      format.json { render :json => @posts }
      format.atom
    end
  end