Bug #4716: Not able to assign activation key to content view - Katello - Foreman

Bug #4716

Not able to assign activation key to content view

Added by Ivan Necas about 8 years ago. Updated almost 4 years ago.

Status:

Duplicate

Priority:

Normal

Assignee:

Ivan Necas

Category:

Target version:

Katello Recycle Bin

Difficulty:

Triaged:

Bugzilla link:

Pull request:

Fixed in Releases:

Found in Releases:

Red Hat JIRA:

Description

1. create product, repo, content view
2. got to new activation key page
3. select library environment

Expected:

list of content views available

Current

500 from server:

{"displayMessage":"PGError: ERROR:  column reference \"id\" is ambiguous\nLINE 1: SELECT id FROM \"katello_content_views\" INNER JOIN \"katello_c...\n               ^\n: SELECT id FROM \"katello_content_views\" INNER JOIN \"katello_content_view_environments\" ON \"katello_content_view_environments\".\"content_view_id\" = \"katello_content_views\".\"id\" WHERE \"katello_content_views\".\"default\" = 'f' AND \"katello_content_views\".\"organization_id\" = 1 AND (katello_content_view_environments.environment_id = 1)","errors":["PGError: ERROR:  column reference \"id\" is ambiguous\nLINE 1: SELECT id FROM \"katello_content_views\" INNER JOIN \"katello_c...\n               ^\n: SELECT id FROM \"katello_content_views\" INNER JOIN \"katello_content_view_environments\" ON \"katello_content_view_environments\".\"content_view_id\" = \"katello_content_views\".\"id\" WHERE \"katello_content_views\".\"default\" = 'f' AND \"katello_content_views\".\"organization_id\" = 1 AND (katello_content_view_environments.environment_id = 1)"]}