Project

General

Profile

Actions

Bug #15736

closed

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

Added by laxman veeturi over 7 years ago. Updated almost 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 #1

Updated by Dominic Cleal over 7 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.

Actions #2

Updated by Anonymous almost 7 years ago

  • Status changed from Feedback to Resolved
Actions

Also available in: Atom PDF