Bug 719426
| Summary: | Roles tab throwing trace | ||
|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Corey Welton <cwelton> |
| Component: | WebUI | Assignee: | Partha Aji <paji> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Katello QA List <katello-qa-list> |
| Severity: | high | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 6.0.0 | CC: | mmccune |
| Target Milestone: | Unspecified | Keywords: | Triaged |
| Target Release: | Unused | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2012-08-22 17:48:34 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 747354 | ||
should be fixed as of http://git.fedorahosted.org/git/?p=katello.git;a=commit;h=4bd0ef1dc5cc59bc96837c97891e8b7648ecd32c QA Verified. |
Description of problem: Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. Login to browser 2. Administration > Roles. 3. View results Actual results: ActiveRecord::StatementInvalid in Roles#index Showing /root/katello/src/app/views/common/_panel.html.haml where line #64 raised: PGError: ERROR: column "roles.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "roles".* FROM "roles" left outer join users on user... ^ : SELECT "roles".* FROM "roles" left outer join users on users.own_role_id = roles.id WHERE "users"."own_role_id" IS NULL GROUP BY roles.id LIMIT 25 Extracted source (around line #64): 61: - if custom_rows 62: = render_rows(:collection=>collection, :columns=>columns, :accessor=>accessor) 63: - else 64: - for item in collection 65: = render :partial=>"common/list_item", :locals=>{:item=>item, :accessor=>accessor, :columns=>columns} 66: %br.clear Trace of template inclusion: app/views/roles/index.html.haml Rails.root: /root/katello/src Application Trace | Framework Trace | Full Trace app/views/common/_panel.html.haml:64:in `_app_views_common__panel_html_haml__1072711784_70002462948100_1233218804' app/helpers/application_helper.rb:77:in `two_panel' app/views/roles/index.html.haml:7:in `_app_views_roles_index_html_haml__1838679593_70002463530420_0' lib/util/threadsession.rb:77:in `thread_locals' Request Parameters: None Show session dump Show env dump Response Headers: None Expected results: Working Roles view Additional info: