Bug #15736

Updated by Dominic Cleal over 8 years ago

   
   
   Hello, 

 

   I created user as foreman administrator. when user tried to change his account password he got below error. 
 Please help me 

 Warning! 

 PGError: ERROR: column reference "name" is ambiguous LINE 1: ...e = 'view_roles') ORDER BY filters.role_id, filters.id, name ^ : SELECT "filters".* FROM "filters" INNER JOIN "filterings" ON "filterings"."filter_id" = "filters"."id" INNER JOIN "permissions" ON "permissions"."id" = "filterings"."permission_id" INNER JOIN "roles" ON "filters"."role_id" = "roles"."id" INNER JOIN "cached_user_roles" ON "roles"."id" = "cached_user_roles"."role_id" WHERE "roles"."builtin" = 0 AND "roles"."id" IN (5, 3, 11, 10, 6, 20, 21, 9, 13, 19, 1, 2, 4, 14, 15, 18, 16, 17, 12, 8) AND "cached_user_roles"."user_id" = 4 AND (permissions.resource_type = 'Role') AND (permissions.name = 'view_roles') ORDER BY filters.role_id, filters.id, name 

 Please find the attached screen shot 

 Thanks 
 Laxman

Back