Hello!

I am using foreman-1.0.1-1.el6 on Postgres (the rpm package). If i try to go to http://foreman/puppetclasses it gives me the following error:

ActiveRecord::StatementInvalid
PG::Error: ERROR: column "lookup_keys.key" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ... 83, 1, 2) GROUP BY puppetclass_id ORDER BY LOWER(lookup_key... ^ : SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (184, 139, 158, 96, 95, 109, 178, 180, 252, 194, 189, 188, 190, 193, 253, 191, 192, 97, 157, 108, 177, 179, 83, 1, 2) GROUP BY puppetclass_id ORDER BY LOWER(lookup_keys.key)
app/controllers/puppetclasses_controller.rb:21:in `index'
app/controllers/puppetclasses_controller.rb:17:in `index'

Despite that http://foreman/puppetclasses?format=json is working.

The debug output in production.log is:

Started GET "/puppetclasses" for 172.25.49.62 at Mon Aug 27 11:48:45 +0200 2012
  Processing by PuppetclassesController#index as HTML
  User Load (0.3ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 3 LIMIT 1
Setting current user thread-local variable to naglha
  Puppetclass Load (0.5ms)  SELECT "puppetclasses".* FROM "puppetclasses" ORDER BY LOWER(puppetclasses.name) LIMIT 1
  SQL (0.6ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = '"puppetclasses"'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
  Puppetclass Load (0.6ms)  SELECT "puppetclasses".* FROM "puppetclasses" ORDER BY LOWER(puppetclasses.name) LIMIT 25 OFFSET 0
  Environment Load (0.6ms)  SELECT "environments".*, t0.puppetclass_id as the_parent_record_id FROM "environments" INNER JOIN "environments_puppetclasses" t0 ON "environments".id = t0.environment_id WHERE (t0.puppetclass_id IN (184,139,158,96,95,109,178,180,252,194,189,188,190,193,253,191,192,97,157,108,177,179,83,1,2))
  Hostgroup Load (0.5ms)  SELECT "hostgroups".*, t0.puppetclass_id as the_parent_record_id FROM "hostgroups" INNER JOIN "hostgroups_puppetclasses" t0 ON "hostgroups".id = t0.hostgroup_id WHERE (t0.puppetclass_id IN (184,139,158,96,95,109,178,180,252,194,189,188,190,193,253,191,192,97,157,108,177,179,83,1,2))
  SQL (0.2ms)  SELECT COUNT(*) FROM "puppetclasses" 
  SQL (0.5ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = '"host_classes"'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum

  SQL (0.5ms)   SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
 FROM pg_attribute a LEFT JOIN pg_attrdef d
 ON a.attrelid = d.adrelid AND a.attnum = d.adnum
 WHERE a.attrelid = '"host_classes"'::regclass
 AND a.attnum > 0 AND NOT a.attisdropped
 ORDER BY a.attnum
  SQL (0.7ms)  SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "hosts" INNER JOIN "host_classes" ON "hosts"."id" = "host_classes"."host_id" INNER JOIN "puppetclasses" ON "puppetclasses"."id" = "host_classes"."puppetclass_id" WHERE "puppetclasses"."id" IN (184, 139, 158, 96, 95, 109, 178, 180, 252, 194, 189, 188, 190, 193, 253, 191, 192, 97, 157, 108, 177, 179, 83, 1, 2) GROUP BY puppetclass_id
  SQL (0.4ms)  SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (184, 139, 158, 96, 95, 109, 178, 180, 252, 194, 189, 188, 190, 193, 253, 191, 192, 97, 157, 108, 177, 179, 83, 1, 2) GROUP BY puppetclass_id ORDER BY LOWER(lookup_keys.key)
PG::Error: ERROR:  column "lookup_keys.key" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ... 83, 1, 2) GROUP BY puppetclass_id ORDER BY LOWER(lookup_key...
                                                             ^
: SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (184, 139, 158, 96, 95, 109, 178, 180, 252, 194, 189, 188, 190, 193, 253, 191, 192, 97, 157, 108, 177, 179, 83, 1, 2) GROUP BY puppetclass_id ORDER BY LOWER(lookup_keys.key)
Operation FAILED: PG::Error: ERROR:  column "lookup_keys.key" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ... 83, 1, 2) GROUP BY puppetclass_id ORDER BY LOWER(lookup_key...
                                                             ^
: SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (184, 139, 158, 96, 95, 109, 178, 180, 252, 194, 189, 188, 190, 193, 253, 191, 192, 97, 157, 108, 177, 179, 83, 1, 2) GROUP BY puppetclass_id ORDER BY LOWER(lookup_keys.key)
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/postgresql_adapter.rb:518:in `exec'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/postgresql_adapter.rb:518:in `execute'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/abstract_adapter.rb:202:in `log'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/abstract_adapter.rb:200:in `log'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/postgresql_adapter.rb:514:in `execute'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/postgresql_adapter.rb:1004:in `select_raw'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/postgresql_adapter.rb:997:in `select'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/abstract/query_cache.rb:54:in `select_all'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/abstract/query_cache.rb:68:in `cache_sql'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/abstract/query_cache.rb:54:in `select_all'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/relation/calculations.rb:235:in `execute_grouped_calculation'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/relation/calculations.rb:180:in `perform_calculation'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/relation/calculations.rb:152:in `calculate'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/relation/calculations.rb:147:in `calculate'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/relation/calculations.rb:58:in `count'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/base.rb:448:in `__send__'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/base.rb:448:in `count'
/usr/share/foreman/app/controllers/puppetclasses_controller.rb:21:in `index'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/mime_responds.rb:192:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/mime_responds.rb:192:in `respond_to'
/usr/share/foreman/app/controllers/puppetclasses_controller.rb:17:in `index'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/implicit_render.rb:4:in `send_action'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/implicit_render.rb:4:in `send_action'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/abstract_controller/base.rb:150:in `process_action'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/rendering.rb:11:in `process_action'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/abstract_controller/callbacks.rb:18:in `process_action'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:479:in `_run__2117744461__process_action__199225275__callbacks'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:221:in `_conditional_callback_around_3205'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:331:in `around'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:315:in `send'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:315:in `_callback_around_2668'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:220:in `_conditional_callback_around_3205'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:473:in `_run__2117744461__process_action__199225275__callbacks'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:221:in `_conditional_callback_around_3204'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:331:in `around'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:315:in `send'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:315:in `_callback_around_13'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:220:in `_conditional_callback_around_3204'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:436:in `_run__2117744461__process_action__199225275__callbacks'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:410:in `send'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:410:in `_run_process_action_callbacks'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:94:in `send'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:94:in `run_callbacks'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/abstract_controller/callbacks.rb:17:in `process_action'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/rescue.rb:17:in `process_action'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/instrumentation.rb:30:in `process_action'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/notifications.rb:52:in `instrument'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/notifications.rb:52:in `instrument'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/instrumentation.rb:29:in `process_action'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/abstract_controller/base.rb:119:in `process'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/abstract_controller/rendering.rb:41:in `process'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal.rb:138:in `dispatch'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_controller/metal.rb:178:in `action'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/routing/route_set.rb:68:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/routing/route_set.rb:68:in `dispatch'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/routing/route_set.rb:33:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-mount-0.6.14/lib/rack/mount/route_set.rb:148:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-mount-0.6.14/lib/rack/mount/code_generation.rb:93:in `recognize'
/usr/lib/ruby/gems/1.8/gems/rack-mount-0.6.14/lib/rack/mount/code_generation.rb:131:in `optimized_each'
/usr/lib/ruby/gems/1.8/gems/rack-mount-0.6.14/lib/rack/mount/code_generation.rb:92:in `recognize'
/usr/lib/ruby/gems/1.8/gems/rack-mount-0.6.14/lib/rack/mount/route_set.rb:139:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/routing/route_set.rb:499:in `call'
/usr/lib/ruby/gems/1.8/gems/apipie-rails-0.0.9/lib/apipie/static_dispatcher.rb:57:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/best_standards_support.rb:17:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/head.rb:14:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/methodoverride.rb:24:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/params_parser.rb:21:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/flash.rb:182:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/session/abstract_store.rb:149:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/cookies.rb:302:in `call'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/query_cache.rb:32:in `call'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/abstract/query_cache.rb:28:in `cache'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/query_cache.rb:12:in `cache'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/query_cache.rb:31:in `call'
/usr/lib/ruby/gems/1.8/gems/activerecord-3.0.15/lib/active_record/connection_adapters/abstract/connection_pool.rb:354:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/callbacks.rb:46:in `call'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/callbacks.rb:416:in `_run_call_callbacks'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/callbacks.rb:44:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/sendfile.rb:106:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/remote_ip.rb:48:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/show_exceptions.rb:47:in `call'
/usr/lib/ruby/gems/1.8/gems/railties-3.0.15/lib/rails/rack/logger.rb:13:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/runtime.rb:17:in `call'
/usr/lib/ruby/gems/1.8/gems/activesupport-3.0.15/lib/active_support/cache/strategy/local_cache.rb:72:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/lock.rb:13:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/lock.rb:13:in `synchronize'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/lock.rb:13:in `call'
/usr/lib/ruby/gems/1.8/gems/actionpack-3.0.15/lib/action_dispatch/middleware/static.rb:30:in `call'
/usr/lib/ruby/gems/1.8/gems/railties-3.0.15/lib/rails/application.rb:168:in `call'
/usr/lib/ruby/gems/1.8/gems/railties-3.0.15/lib/rails/application.rb:77:in `send'
/usr/lib/ruby/gems/1.8/gems/railties-3.0.15/lib/rails/application.rb:77:in `method_missing'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/urlmap.rb:47:in `call'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/urlmap.rb:41:in `each'
/usr/lib/ruby/gems/1.8/gems/rack-1.2.5/lib/rack/urlmap.rb:41:in `call'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/rack/request_handler.rb:96:in `process_request'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_request_handler.rb:513:in `accept_and_process_next_request'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_request_handler.rb:274:in `main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/rack/application_spawner.rb:206:in `start_request_handler'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/rack/application_spawner.rb:171:in `send'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/rack/application_spawner.rb:171:in `handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/utils.rb:479:in `safe_fork'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/rack/application_spawner.rb:166:in `handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server.rb:357:in `__send__'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server.rb:180:in `start'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/rack/application_spawner.rb:129:in `start'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/spawn_manager.rb:253:in `spawn_rack_application'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server_collection.rb:132:in `lookup_or_add'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/spawn_manager.rb:246:in `spawn_rack_application'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server_collection.rb:82:in `synchronize'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/spawn_manager.rb:244:in `spawn_rack_application'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/spawn_manager.rb:137:in `spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/spawn_manager.rb:275:in `handle_spawn_application'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server.rb:357:in `__send__'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
/usr/lib/ruby/gems/1.8/gems/passenger-3.0.11/helper-scripts/passenger-spawn-server:99
Read fragment views/tabs_and_title_records-3 (0.3ms)
Rendered home/_topbar.rhtml (1.0ms)
  Bookmark Load (0.4ms)  SELECT "bookmarks".* FROM "bookmarks" WHERE (((bookmarks.public = 't') OR (bookmarks.owner_id = 3 AND bookmarks.owner_type = 'User'))) AND (controller = 'puppetclasses') ORDER BY name
Rendered common/_searchbar.erb (4.1ms)
Rendered common/500.rhtml within layouts/application (13.7ms)
Completed 500 Internal Server Error in 52ms (Views: 14.0ms | ActiveRecord: 7.0ms)

Thanks
Hannes