Project

General

Profile

Actions

Bug #15736

closed

"column reference "name" is ambiguous" error on non-admin user account form

Added by laxman veeturi over 8 years ago. Updated over 7 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
-
Category:
Rails
Target version:
-
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

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

foreman_error.PNG View foreman_error.PNG 43.7 KB laxman veeturi, 07/19/2016 10:18 AM
Actions

Also available in: Atom PDF