Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1395667

Description of problem:
When searching users using usergroup, Satellite returns following error:

2016-11-16 13:57:58 [app] [W] Action failed
 | ActiveRecord::StatementInvalid: 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" = 'penguins' )))  ORDER BY firstname LIMIT 20 OFFSET 0
 | /opt/rh/rh-ror41/root/usr/share/gems/gems/activerecord-4.1.5/lib/active_record/connection_adapters/postgresql_adapter.rb:822:in `exec'

(full error message with ruby backtrace is enclosed to the BZ)

Version-Release number of selected component (if applicable):
Reproduced on:

• Red Hat Satellite 6.2.3
• Red Hat Satellite 6.2.4
• Foreman nightly

How reproducible:
Always

Steps to Reproduce:

1. Create a usergroup (Administer > User groups > New User Group)
2. Add a user to the user group
3. Sear for users belonging to the user group (Administer > Users > enter 'usergroup = <usergroupname>' in the search field and hit search)

Actual results:
The search will fail and Satellite reports above mentioned error.

Expected results:
All users belonging to the usergroup should be listed.