Bug 1653325

Summary: Activation keys search in webui throws PG error
Product: Red Hat Satellite Reporter: Ales Dujicek <adujicek>
Component: SearchAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED DUPLICATE QA Contact: Katello QA List <katello-qa-list>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: UnspecifiedCC: akarsale, kgaikwad, mhulan, sghai
Target Milestone: UnspecifiedKeywords: Regression
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-11-27 12:20:11 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:
Embargoed:

Description Ales Dujicek 2018-11-26 14:42:12 UTC 
Description of problem:

Content > Activation Keys (/activation_keys)

enter key name to search field
click Search button

error:

external method 'find_by_subscription_id' failed with error: PG::InvalidTextRepresentation: ERROR: invalid input syntax for integer: "keyname" LINE 1: ...ivation_keys"."pool_id" WHERE (katello_pools.id = 'keyname') ^ : SELECT "katello_activation_keys"."id" FROM "katello_activation_keys" INNER JOIN "katello_pool_activation_keys" ON "katello_pool_activation_keys"."activation_key_id" = "katello_activation_keys"."id" INNER JOIN "katello_pools" ON "katello_pools"."id" = "katello_pool_activation_keys"."pool_id" WHERE (katello_pools.id = 'keyname')

Version-Release number of selected component (if applicable):
Sat 6.5 snap 5
satellite-6.5.0-5.beta.el7sat.noarch
katello-3.9.0-1.el7sat.noarch
Comment 4 Ales Dujicek 2018-11-27 12:20:11 UTC 
correct, it is the same thing

*** This bug has been marked as a duplicate of bug 1653251 ***