log out

gistfile1.txt

Started GET "/my-recommendations" for 127.0.0.1 at 2011-12-30 13:34:20 -0800
  Processing by PagesController#recs as HTML
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
  Recommendation Load (0.4ms)  SELECT "recommendations".* FROM "recommendations" INNER JOIN "approvals" ON "approvals"."recommendation_id" = "recommendations"."id" WHERE (approvals.count = 1 AND recommendations.user_id = 1)
PGError: ERROR:  aggregates not allowed in WHERE clause
LINE 1: ...ecommendation_id" = "recommendations"."id" WHERE (approvals....
                                                             ^
: SELECT "recommendations".* FROM "recommendations" INNER JOIN "approvals" ON "approvals"."recommendation_id" = "recommendations"."id" WHERE (approvals.count = 1 AND recommendations.user_id = 1)
Rendered pages/recs.html.erb within layouts/application (58.6ms)
Completed 500 Internal Server Error in 104ms

ActionView::Template::Error (PGError: ERROR:  aggregates not allowed in WHERE clause
LINE 1: ...ecommendation_id" = "recommendations"."id" WHERE (approvals....
                                                             ^
: SELECT "recommendations".* FROM "recommendations" INNER JOIN "approvals" ON "approvals"."recommendation_id" = "recommendations"."id" WHERE (approvals.count = 1 AND recommendations.user_id = 1)):
    1: <h1>My Recommendations</h1>
    2: 
    3: 
    4: <% @recommendations.each do |rec| %>
    5: 	<h3><%= link_to rec.nominee, edit_recommendation_path(rec) %></h3>
    6: <% end %>
  app/views/pages/recs.html.erb:4:in `_app_views_pages_recs_html_erb___3315861878310539382_2175018220'

Rendered /Users/tjs/.rvm/gems/ruby-1.9.2-p290/gems/actionpack-3.1.1/lib/action_dispatch/middleware/templates/rescues/_trace.erb (1.9ms)
Rendered /Users/tjs/.rvm/gems/ruby-1.9.2-p290/gems/actionpack-3.1.1/lib/action_dispatch/middleware/templates/rescues/_request_and_response.erb (1.2ms)
Rendered /Users/tjs/.rvm/gems/ruby-1.9.2-p290/gems/actionpack-3.1.1/lib/action_dispatch/middleware/templates/rescues/template_error.erb within rescues/layout (37.6ms)