Project

General

Custom queries

Profile

Actions
Copy link

Bug #25251

closed

non-admin user gets 'PG::AmbiguousColumn: ERROR: column reference "puppet_proxy_id" is ambiguous' when trying to view smart-proxy details

Added by Kevin Carrasco over 6 years ago. Updated almost 5 years ago.

Status:
Rejected
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Difficulty:
Triaged:
No
Bugzilla link:
Pull request:
Fixed in Releases:
Found in Releases:
1.19.0
Red Hat JIRA:

Description

When a user without admin privileges navigates the web UI to Infrastructure -> Smart Proxies -> smart-proxy.example.com
We are getting the following error:

ActionView::Template::Error: external method 'search_by_proxy' failed with error: PG::AmbiguousColumn: ERROR:  column reference "puppet_proxy_id" is ambiguous

Attached production log which shows the SQL query and stack trace.

Files

production.log production.log 21.1 KB Kevin Carrasco, 10/19/2018 07:33 PM
desktop-team-filters.csv desktop-team-filters.csv 4.71 KB Kevin Carrasco, 10/22/2018 06:02 PM
#2

Updated by Amit Karsale over 6 years ago

  • Triaged changed from No to Yes
#3

Updated by Lukas Zapletal over 6 years ago

  • Status changed from New to Need more information
  • Triaged changed from Yes to No
#4

Updated by Kevin Carrasco over 6 years ago

#6

Updated by Kevin Carrasco almost 5 years ago

  • Status changed from Need more information to Rejected
Actions
Copy link

Also available in: Atom PDF