Bug 719426 - Roles tab throwing trace
Summary: Roles tab throwing trace
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: WebUI
Version: 6.0.0
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: Unspecified
Assignee: Partha Aji
QA Contact: Katello QA List
URL:
Whiteboard:
Depends On:
Blocks: katello-blockers
TreeView+ depends on / blocked
 
Reported: 2011-07-06 19:36 UTC by Corey Welton
Modified: 2019-09-26 13:17 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-08-22 17:48:34 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Corey Welton 2011-07-06 19:36:23 UTC
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:

Comment 2 Corey Welton 2011-08-10 12:57:04 UTC
QA Verified.


Note You need to log in before you can comment on or make changes to this bug.