Red Hat Bugzilla – Bug 842010
Content Search - Packages: Entering a string in Repos field and hitting enter returns error
Last modified: 2014-09-18 12:42:09 EDT
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:
Created attachment 599462 [details] trace
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.
I believe this might be fixed in a newer version as part of commit 7fdc9f6ad087f944e029af567487a8cdf2e89724 Moving to on_dev
QE Verified CloudForms System Engine Version: 1.1.12-7.el6cf
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
getting rid of 6.0.0 version since that doesn't exist