GroupingError: ERROR: column must appear in the GROUP BY clause or be used in an aggregate function

by

You are not allowed to select reviews.id (selected implicitly through the wildcard *) without adding it to the GROUP BY clause or applying an aggregate function like avg(). The solution is to do one of the following:

  1. Remove the wildcard * from your select
  2. Add the field reviews.id to your group clause
  3. Select reviews.id explicitly and apply an aggregate function to it (e.g. sum(reviews.id))
  4. Replace the wildcard * with the table-specific wildcard albums.*

The second and third option do not make much sense in your scenario though.
Based on your comment, I added option four.

More Related Contents:

  1. Boolean Validation
  2. ActiveRecord OR query Hash notation
  3. Generic Ruby solution for SQLite3 “LIKE” or PostgreSQL “ILIKE”?
  4. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  5. Clean way to find ActiveRecord objects by id in the order specified
  6. Change from SQLite to PostgreSQL in a fresh Rails project
  7. Rails 4 nested attributes and has_many :through associaton in a form
  8. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  9. New data not persisting to Rails array column on Postgres
  10. Rails: PG::UndefinedTable: ERROR: relation “…” does not exist
  11. Store the day of the week and time?
  12. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects
  13. An error occurred while installing pg (0.17.1), and Bundler cannot continue
  14. Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?
  15. How to get a random number in Ruby
  16. Rails 4 Authenticity Token
  17. Rails 5: ActiveRecord OR query
  18. Ruby on Rails. How do I use the Active Record .build method in a :belongs to relationship?
  19. Add Custom Field/Column to Devise with Rails 4
  20. ActiveRecord Find By Year, Day or Month on a Date field
  21. Cannot add a NOT NULL column with default value NULL in Sqlite3
  22. Redis + ActionController::Live threads not dying
  23. Do rails rake tasks provide access to ActiveRecord models?
  24. how to add records to has_many :through association in rails
  25. How to implement bulk insert in Rails 3
  26. Rails 4 – Gem::LoadError: Specified ‘mysql2’ for database adapter, but the gem is not loaded
  27. Rails: FATAL – Peer authentication failed for user (PG::Error)
  28. Is puma the ONLY multi-threaded rails 4 http server?
  29. Rails best way to get previous and next active record object
  30. Rails Object Relationships and JSON Rendering

Leave a Comment