Getting error `Oops, we're sorry but something went wrong PG::Error: ERROR: column "member_type" does not exist` while searching user by usergroup.
Issue
-
While searching for a user under
Administertab on Satellite 6 WebUI, it throws the below error:Oops, we're sorry but something went wrong PG::Error: ERROR: column "member_type" does not exist LINE 3: ...."id" = "cached_usergroup_members"."user_id" AND member_typ... ^ : SELECT DISTINCT "users"."id", firstname AS alias_0 FROM "users" LEFT OUTER JOIN "cached_usergroup_members" ON "cached_usergroup_members"."user_id" = "users"."id" LEFT OUTER JOIN "usergroups" ON "usergroups"."id" = "cached_usergroup_members"."usergroup_id" LEFT OUTER JOIN "auth_sources" ON "auth_sources"."id" = "users"."auth_source_id" WHERE "users"."id" IN (4, 1, 2, 3) AND ("users"."auth_source_id" NOT IN (2)) AND (("users"."id" IN (SELECT "users"."id" FROM "users" INNER JOIN "cached_usergroup_members" ON "users"."id" = "cached_usergroup_members"."user_id" AND member_type = 'User' INNER JOIN "usergroups" ON "cached_usergroup_members"."usergroup_id" = "usergroups"."id" WHERE "usergroups"."name" = 'group_name' ))) ORDER BY firstname LIMIT 20 OFFSET 0
Environment
- Red Hat Satellite 6.2
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.