Bug 1406433

Development Management has reviewed and declined this request.
You may appeal this decision by reopening this request.

Hello Team,

Addition to this Bugzilla, When non-admin user is login without Administrator Permissions not able to view his own user information from "My account" and "Administrator >> Users ", Getting below error Message.

~~~~~~~~~~
Oops, we're sorry but something went wrong PG::Error: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...ocation')) ORDER BY filters.role_id, filters.id, "roles"."n... ^ : SELECT DISTINCT "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" LEFT JOIN taxable_taxonomies ON (filters.id = taxable_taxonomies.taxable_id AND taxable_type = 'Filter') LEFT JOIN taxonomies ON (taxonomies.id = taxable_taxonomies.taxonomy_id) WHERE "roles"."builtin" = 0 AND "roles"."id" IN (6, 5, 1, 18, 17, 19, 16, 15, 10, 8, 7, 4, 21, 20, 12, 2, 3, 11, 9) AND "cached_user_roles"."user_id" = $1 AND (permissions.resource_type = 'Role') AND (permissions.name = 'view_roles') AND (taxable_taxonomies.id IS NULL OR (taxonomies.type = 'Organization') OR (taxonomies.type = 'Location')) ORDER BY filters.role_id, filters.id, "roles"."name" ASC
~~~~~~~~~~
Please let me know if you need any information.

Regards,
Satish Sherkar

Satish, I believe you just hit BZ 1392513 that should be already fixed in 6.2.7. Please don't combine two different error messages in one BZ, it's hard to track the progress in such case.

Marek and Satish,

I had a call with this customer yesterday to fix https://bugzilla.redhat.com/show_bug.cgi?id=1408135

We explored also what was causing this bug. The response was fine, the issue is that the UI does not reflect properly what the locations/organizations are for users who have none and are 'owners' of hosts.

e.g: 

For an admin api/v2/users returns 4 users (includes the ones without orgs/locs)
For a regular user api/v2/users/ returns 2 users (the other 2 did NOT have orgs/locs)

However, on the UI if you clicked on those users, Location/Organization tabs you'd see "Default Location" - "cannot be unassigned because it's used by a host (or something like that)". On the UI it looks like it's assigned to the user but you can't remove it. On foreman-rake console, it becomes clear that the user does NOT have the taxable_taxonomies association. 

It's the same bug as in https://bugzilla.redhat.com/show_bug.cgi?id=1228365 for hostgroups. We agreed during the call to make this one a duplicate and track the status of this through (https://bugzilla.redhat.com/show_bug.cgi?id=1228365). 

This already has a patch (for other object affected by this 'ghost association', hostgroups) upstream https://github.com/theforeman/foreman/pull/4136 - but it has to be updated to include host.owner.

*** This bug has been marked as a duplicate of bug 1228365 ***