Bug #15736
closed
"column reference "name" is ambiguous" error on non-admin user account form
Description
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
Files
Updated by Dominic Cleal over 8 years ago
- Subject changed from When user tried to change his password he got error in foreman 1.10 to "column reference "name" is ambiguous" error on non-admin user account form
- Description updated (diff)
- Category set to Rails
- Status changed from New to Feedback
I've not tried to fully reproduce this, but it looks likely that this is fixed in a current version of Foreman, with a newer version of Ruby on Rails. Please try on 1.12.0.
Updated by Anonymous