Actions
Bug #2011
closedParam Class optimization fails on Postges
Description
foreman/hosts/new
x PG::Error: ERROR: column "lookup_keys.key" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...ss_id" IN (NULL) GROUP BY puppetclass_id ORDER BY lookup_key... ^ : SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (NULL) GROUP BY puppetclass_id ORDER BY lookup_keys.key If you feel this is an error with Foreman itself, please open a new issue with Foreman ticketing system, You would probably need to attach the Full trace and relevant log entries. 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: ...ss_id" IN (NULL) GROUP BY puppetclass_id ORDER BY lookup_key... ^ : SELECT COUNT(*) AS count_all, puppetclass_id AS puppetclass_id FROM "lookup_keys" WHERE "lookup_keys"."puppetclass_id" IN (NULL) GROUP BY puppetclass_id ORDER BY lookup_keys.key app/helpers/hosts_and_hostgroups_helper.rb:83:in `interesting_klasses' app/views/puppetclasses/_classes_parameters.html.erb:11:in `_app_views_puppetclasses__classes_parameters_html_erb__786019820_107278740_909626628' app/views/hosts/_form.html.erb:74:in `block in _app_views_hosts__form_html_erb___702716785_109829890_127430104' app/helpers/layout_helper.rb:155:in `form_for' app/views/hosts/_form.html.erb:4:in `_app_views_hosts__form_html_erb___702716785_109829890_127430104' app/views/hosts/new.html.erb:3:in `_app_views_hosts_new_html_erb__861224596_109807200_763432826' lib/foreman/threadsession.rb:31:in `clear_thread' Back
Updated by Ohad Levy about 12 years ago
- Status changed from New to Closed
- % Done changed from 0 to 100
Applied in changeset 3c2fb3fdf3e78d2379b6108a9698eb43b0574e11.
Actions