Greenlight: cannot assign roles on fresh setup

[bvdlingen]

Looks like a new issue has been introduced today. We did a clean deployment and it's not possible to assign roles anymore, see the greenlight log below:

```INFO: [514053ed-13f4-4314-b91b-f1160f3aac74] method=PATCH path=/b/u/gl-pwwgtmgayjfq/edit format=html controller=UsersController action=update status=500 error='ActiveRecord::StatementInvalid: PG::InvalidColumnReference: ERROR:  for SELECT DISTINCT, ORDER BY expressions must appear in select list
LINE 1: ...e_id" WHERE "users_roles"."user_id" = $1 ORDER BY "roles"."p...
                                                             ^
: SELECT DISTINCT "roles"."id" FROM "roles" LEFT OUTER JOIN "role_permissions" ON "role_permissions"."role_id" = "roles"."id" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = $1 ORDER BY "roles"."priority" ASC' duration=215.55 view=0.00 db=2.85 host=greenlight 
FATAL: [514053ed-13f4-4314-b91b-f1160f3aac74]    
FATAL: [514053ed-13f4-4314-b91b-f1160f3aac74] ActiveRecord::StatementInvalid (PG::InvalidColumnReference: ERROR:  for SELECT DISTINCT, ORDER BY expressions must appear in select list
LINE 1: ...e_id" WHERE "users_roles"."user_id" = $1 ORDER BY "roles"."p...
                                                             ^
: SELECT DISTINCT "roles"."id" FROM "roles" LEFT OUTER JOIN "role_permissions" ON "role_permissions"."role_id" = "roles"."id" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = $1 ORDER BY "roles"."priority" ASC): ```

Docker image hash: f966c37dbbae (installed today)

Maybe related to this recent change GRN2-284?
https://github.com/bigbluebutton/greenlight/commit/03cdbd6b69047db3d88228971077facff50a9041

[farhatahmad]

Hi @bvdlingen,

Thanks for reporting it. I've been able to reproduce it, so I'll get a fix in and release a new version

[farhatahmad]

@bvdlingen Should be fixed now. Can you try updating Greenlight and seeing if it works?

[bvdlingen]

Wow that's fast! Looking good, works on my machine!