Actions
Bug #939
closedInvalid PostgreSQL statement in 0.3rc2
Description
I upgraded to 0.3rc2 and am now getting the following in the logs whenever I try and bring up the web page:
Processing HostsController#index (for 161.210.45.73 at 2011-05-24 13:09:28) [GET] Parameters: {"action"=>"index", "controller"=>"hosts"} ActiveRecord::StatementInvalid (PGError: ERROR: column "hosts.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT * FROM "hosts" GROUP BY hosts.id ORDER BY "hosts"."n... ^ : SELECT * FROM "hosts" GROUP BY hosts.id ORDER BY "hosts"."name" ASC LIMIT 20 OFFSET 0): app/controllers/hosts_controller.rb:37:in `index' app/controllers/hosts_controller.rb:35:in `index' /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' /usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread' /usr/lib/ruby/1.8/webrick/server.rb:162:in `start' /usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread' /usr/lib/ruby/1.8/webrick/server.rb:95:in `start' /usr/lib/ruby/1.8/webrick/server.rb:92:in `each' /usr/lib/ruby/1.8/webrick/server.rb:92:in `start' /usr/lib/ruby/1.8/webrick/server.rb:23:in `start' /usr/lib/ruby/1.8/webrick/server.rb:82:in `start' Rendering /usr/share/foreman/public/500.html (500 Internal Server Error)
I'm using PostgreSQL 9.0.4 as my database.
Actions