Skip to content

Error in 'list_community_roles' API call

This API call simply fails if the last parameter is specified:

https://gitlab.syncad.com/hive/hivemind/-/blob/master/hive/server/hive_api/community.py#L190

I think it has never been tested because this query cannot work: https://gitlab.syncad.com/hive/hivemind/-/blob/master/hive/server/hive_api/community.py#L198

as the 'name' column does not exist on that table.

This is the error reported by this call:

{"id":5,"jsonrpc":"2.0","method":"bridge.list_community_roles","params":{"community":"hive-156509","limit":50,"last":"ykroys"}}

error:

UndefinedColumn: column "name" does not exist↵LINE 1: SELECT role_id FROM hive_roles WHERE name = 'ykroys'