Project

General

Profile

Actions
Copy link

Bug #13660

closed

SQL error on dashboard with host collections and errata

Added by Walden Raines about 8 years ago. Updated almost 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Walden Raines
Category:
-
Target version:
Katello 3.0.0
Difficulty:
Triaged:
Bugzilla link:
Pull request:
https://github.com/Katello/katello/pull/5767
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

2016-02-10T22:59:59 [app] [F]
ActionView::Template::Error (PG::Error: ERROR: missing FROM-clause entry for table "katello_content_facets"
 LINE 1: ...rrata"."erratum_id" = "katello_errata"."id" WHERE "katello_c...
 ^
 : SELECT "katello_errata".* FROM "katello_errata" INNER JOIN "katello_content_facet_errata" ON "katello_content_facet_errata"."erratum_id" = "katello_errata"."id" WHERE "katello_content_facets"."host_id" IN (1)):
 3: </h4>
 4:
 5: <% organizations = Organization.current.present? ? [Organization.current] : User.current.allowed_organizations %>
 6: <% critical, warning, ok = Katello::HostCollection.lists_by_updates_needed(organizations) %>
 7: <% host_collections = (critical + warning + ok)[0..6] %>
 8:
 9: <% if host_collections.empty? %>
 /home/vagrant/katello/app/models/katello/host_collection.rb:144:in `block in lists_by_updates_needed'
 /home/vagrant/katello/app/models/katello/host_collection.rb:141:in `lists_by_updates_needed'
 /home/vagrant/katello/app/views/dashboard/_host_collection_widget.html.erb:6:in `_3d1129c1228dff86c131433ec2290104'
 app/helpers/dashboard_helper.rb:39:in `render_widget'
 app/views/dashboard/index.html.erb:20:in `block (2 levels) in _6d4019b83f0729ae00c8d44080d4f145'
 app/views/dashboard/index.html.erb:14:in `block in _6d4019b83f0729ae00c8d44080d4f145'
 app/views/dashboard/index.html.erb:13:in `_6d4019b83f0729ae00c8d44080d4f145'
 app/controllers/dashboard_controller.rb:8:in `index'
 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'
Actions
Copy link
 #1

Updated by The Foreman Bot about 8 years ago

  • Status changed from Assigned to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/5767 added
Actions
Copy link
 #2

Updated by Walden Raines about 8 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions
Copy link
 #3

Updated by Eric Helms about 8 years ago

  • translation missing: en.field_release set to 86
Actions
Copy link

Also available in: Atom PDF