| Summary: | PG-Error while creating gpg-key | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Sachin Ghai <sghai> | ||||||
| Component: | WebUI | Assignee: | Justin Sherrill <jsherril> | ||||||
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Corey Welton <cwelton> | ||||||
| Severity: | medium | Docs Contact: | |||||||
| Priority: | high | ||||||||
| Version: | Nightly | CC: | cwelton, ehelms, omaciel, sghai | ||||||
| Target Milestone: | Unspecified | Keywords: | Regression, Reopened, 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: | 2014-04-24 17:07:39 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: | |||||||
| Attachments: |
|
||||||||
I am unable to reproduce this. Are you still able to? Not able to reproduce it with following build: katello-1.4.6-1.git.95.3ef5eb8.el6.noarch Please ignore comment3. Its reproducible but with different steps: 1.Go to Contents--> repository-> gpg key --> new gpg-key 2. enter name and browse file to upload 3. select 'Product & Repositories' tab. The reported error is reproducible now when you select 'Product & Repositories' tab. Reproducible with: katello-1.4.6-1.git.95.3ef5eb8.el6.noarch Created attachment 798185 [details]
PG error while selecting "Products & Repositories' tab
Thanks for looking into this Sachin! https://github.com/Katello/katello/pull/2957 QE Verified, no more PG error katello 1.4.6-13.el6sat This was verified and delivered with MDP2. Closing it out. |
Created attachment 788783 [details] PG-error while creating a new gpg-key Description of problem: Creating a gpg-key via webUI throws following error: -- PGError: ERROR: missing FROM-clause entry for table "products" LINE 1: ...vironment_id" = 1 ORDER BY repositories.name ASC, products.n... ^ : SELECT "repositories".* FROM "repositories" WHERE "repositories"."gpg_key_id" = 2 AND "repositories"."environment_id" = 1 ORDER BY repositories.name ASC, products.name ASC (ActiveRecord::StatementInvalid) Click here for more details. -- Version-Release number of selected component (if applicable): katello-1.4.3-1.git.256.b710f10.el6.noarch How reproducible: always Steps to Reproduce: 1.Go to Contents--> repository-> gpg key --> new gpg-key 2. enter name and browse file to upload 3. Actual results: PGError: ERROR: missing FROM-clause entry for table "products" LINE 1: ...vironment_id" = 1 ORDER BY repositories.name ASC, products.n... ^ : SELECT "repositories".* FROM "repositories" WHERE "repositories"."gpg_key_id" = 2 AND "repositories"."environment_id" = 1 ORDER BY repositories.name ASC, products.name ASC (ActiveRecord::StatementInvalid) Expected results: User should be able to add gpg-key without any error Additional info: