Bug #10158
closedAdd new host to fresh install
Description
When adding a new host to a fresh install I get:
"PGError: ERROR: column reference "id" is ambiguous LINE 1: SELECT DISTINCT id FROM "puppetclasses" INNER JOIN "environm... ^ : SELECT DISTINCT id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 2 AND "puppetclasses"."id" IN (NULL)"
Full trace:
"ActiveRecord::StatementInvalid
PGError: ERROR: column reference "id" is ambiguous LINE 1: SELECT DISTINCT id FROM "puppetclasses" INNER JOIN "environm... ^ : SELECT DISTINCT id FROM "puppetclasses" INNER JOIN "environment_classes" ON "puppetclasses"."id" = "environment_classes"."puppetclass_id" WHERE "environment_classes"."environment_id" = 2 AND "puppetclasses"."id" IN (NULL)
app/helpers/hosts_and_hostgroups_helper.rb:90:in `interesting_klasses'
app/views/puppetclasses/_classes_parameters.html.erb:11:in `_app_views_puppetclasses__classes_parameters_html_erb___3524885019236351929_133134600'
app/views/hosts/_form.html.erb:125:in `block (2 levels) in app_views_hosts_form_html_erb___477616481609675676_87327160'
app/helpers/layout_helper.rb:274:in `form_for'
app/views/hosts/_form.html.erb:8:in `block in app_views_hosts_form_html_erb___477616481609675676_87327160'
app/models/taxonomy.rb:61:in `block (2 levels) in as_taxonomy'
app/models/concerns/foreman/thread_session.rb:147:in `as_location'
app/models/taxonomy.rb:60:in `block in as_taxonomy'
app/models/concerns/foreman/thread_session.rb:112:in `as_org'
app/models/taxonomy.rb:59:in `as_taxonomy'
app/views/hosts/_form.html.erb:6:in `_app_views_hosts__form_html_erb___477616481609675676_87327160'
app/views/hosts/new.html.erb:3:in `_app_views_hosts_new_html_erb___568193090970988544_113524080'
app/controllers/application_controller.rb:269:in `process_error'
app/controllers/hosts_controller.rb:88:in `create'
app/controllers/concerns/application_shared.rb:13:in `set_timezone'
app/models/concerns/foreman/thread_session.rb:32:in `clear_thread'
lib/middleware/catch_json_parse_errors.rb:9:in `call'"
Updated by Dominic Cleal almost 10 years ago
- Related to Bug #9969: N+1 on host[group] edit page added
Updated by Dominic Cleal almost 10 years ago
- Category set to Rails
Introduced by #9969 into nightlies.
Updated by Diogo Ferreira almost 10 years ago
The version is 1.9.0 and the platform in question is the newest release of Centos 7.1, minimal.
Updated by Dominic Cleal almost 10 years ago
- Status changed from New to Assigned
- Assignee set to Dominic Cleal
Updated by The Foreman Bot almost 10 years ago
- Status changed from Assigned to Ready For Testing
- Pull request https://github.com/theforeman/foreman/pull/2312 added
- Pull request deleted (
)
Updated by Dominic Cleal almost 10 years ago
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Applied in changeset f34c2ce77074ed25409db83e67487abd9f203ebf.