Bug 842010

Summary: Content Search - Packages: Entering a string in Repos field and hitting enter returns error
Product: Red Hat Satellite Reporter: Corey Welton <cwelton>
Component: WebUIAssignee: Jason E. Rist <jrist>
Status: CLOSED ERRATA QA Contact: Corey Welton <cwelton>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.0.1CC: asettle, dmacpher, jsherril, mmccune, omaciel, snansi
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
An SQL error returns when selecting "Packages" from the content browser pane and searching for a string in the "Repos" field. This fix corrects the content search controller. The SQL error no longer appears.
 Story Points: ---
Clone Of: Environment:
Last Closed: 2012-12-04 19:47:52 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
trace none

Description Corey Welton 2012-07-20 20:45:54 UTC 
Description of problem:
When user selects a content type of "Packages" from the Content Browse pane and then searches for a string in the Repos field, an error is thrown.

Version-Release number of selected component (if applicable):

Katello Version: 0.2.47-1.git.225.b3aa579.el6_3

How reproducible:


Steps to Reproduce:
1.  Create/Sync a  provider, product and repos.  You might just want to use third party repos as opposed to RH to assure your environment is as close to this one
2.  Content > Content Search 
3.  Choose "Packages" as the content type in the Content Browse pane
4.  In the resulting "Repos" field, enter the string "floob" and submit.
  
Actual results:
PGError: ERROR: column reference "id" is ambiguous LINE 1: SELECT id FROM "repositories" INNER JOIN "environment_produc... ^ : SELECT id FROM "repositories" INNER JOIN "environment_products" ON "environment_products"."id" = "repositories"."environment_product_id" WHERE "environment_products"."environment_id" = 1 (ActiveRecord::StatementInvalid)
Click here for more details.

Expected results:
Something a little more graceful.

Additional info:
Comment 1 Corey Welton 2012-07-20 20:46:34 UTC 
Created attachment 599462 [details]
trace
Comment 2 Corey Welton 2012-07-26 14:11:38 UTC 
I get the same thing when selecting content type of Errata and trying to search for a Repo

    PGError: ERROR: column reference "id" is ambiguous LINE 1: SELECT id FROM "repositories" INNER JOIN "environment_produc... ^ : SELECT id FROM "repositories" INNER JOIN "environment_products" ON "environment_products"."id" = "repositories"."environment_product_id" WHERE "environment_products"."environment_id" = 1 (ActiveRecord::StatementInvalid)
    Click here for more details.
Comment 3 Justin Sherrill 2012-07-26 21:19:42 UTC 
I believe this might be fixed in a newer version as part of commit  7fdc9f6ad087f944e029af567487a8cdf2e89724

Moving to on_dev
Comment 5 Corey Welton 2012-09-18 16:05:59 UTC 
QE Verified

CloudForms System Engine Version: 1.1.12-7.el6cf
Comment 7 errata-xmlrpc 2012-12-04 19:47:52 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHSA-2012-1543.html
Comment 8 Mike McCune 2013-08-16 18:14:57 UTC 
getting rid of 6.0.0 version since that doesn't exist