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:
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.