open-webui-1 | INFO [open_webui.apps.webui.models.auths] authenticate_user: MY_USER
postgres-1 | 2024-11-17 13:01:45.295 UTC [29561] ERROR: operator does not exist: json ~~ text at character 388
postgres-1 | 2024-11-17 13:01:45.295 UTC [29561] HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
postgres-1 | 2024-11-17 13:01:45.295 UTC [29561] STATEMENT: SELECT "group".id AS group_id, "group".user_id AS group_user_id, "group".name AS group_name, "group".description AS group_description, "group".data AS group_data, "group".meta AS group_meta, "group".permissions AS group_permissions, "group".user_ids AS group_user_ids, "group".created_at AS group_created_at, "group".updated_at AS group_updated_at
postgres-1 | FROM "group"
postgres-1 | WHERE ("group".user_ids LIKE '%' || '["5f43aa4d-eb75-4fc5-b4d6-6352192f386d"]' || '%') ORDER BY "group".updated_at DESC
open-webui-1 | DEBUG [open_webui.main] Commit session after request
open-webui-1 | INFO: 172.16.4.34:0 - "POST /api/v1/auths/signin HTTP/1.1" 500 Internal Server Error
Fixed
calling get_groups_by_member_id() using postgres
tested with sqlite and postgres
🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.
## 📋 Pull Request Information
**Original PR:** https://github.com/open-webui/open-webui/pull/6996
**Author:** [@Peter-De-Ath](https://github.com/Peter-De-Ath)
**Created:** 11/17/2024
**Status:** ✅ Merged
**Merged:** 11/17/2024
**Merged by:** [@tjbck](https://github.com/tjbck)
**Base:** `dev` ← **Head:** `fix_get_groups_by_member_id-postgres-sqlite`
---
### 📝 Commits (1)
- [`80e2d4d`](https://github.com/open-webui/open-webui/commit/80e2d4d4ee8388d5ea0c4231f711848d2e9389f0) fix: user ID filtering in GroupTable query
### 📊 Changes
**1 file changed** (+3 additions, -2 deletions)
<details>
<summary>View changed files</summary>
📝 `backend/open_webui/apps/webui/models/groups.py` (+3 -2)
</details>
### 📄 Description
### Description
calling get_groups_by_member_id() using postgres
This was the error produced
```
open-webui-1 | INFO [open_webui.apps.webui.models.auths] authenticate_user: MY_USER
postgres-1 | 2024-11-17 13:01:45.295 UTC [29561] ERROR: operator does not exist: json ~~ text at character 388
postgres-1 | 2024-11-17 13:01:45.295 UTC [29561] HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
postgres-1 | 2024-11-17 13:01:45.295 UTC [29561] STATEMENT: SELECT "group".id AS group_id, "group".user_id AS group_user_id, "group".name AS group_name, "group".description AS group_description, "group".data AS group_data, "group".meta AS group_meta, "group".permissions AS group_permissions, "group".user_ids AS group_user_ids, "group".created_at AS group_created_at, "group".updated_at AS group_updated_at
postgres-1 | FROM "group"
postgres-1 | WHERE ("group".user_ids LIKE '%' || '["5f43aa4d-eb75-4fc5-b4d6-6352192f386d"]' || '%') ORDER BY "group".updated_at DESC
open-webui-1 | DEBUG [open_webui.main] Commit session after request
open-webui-1 | INFO: 172.16.4.34:0 - "POST /api/v1/auths/signin HTTP/1.1" 500 Internal Server Error
```
### Fixed
- calling get_groups_by_member_id() using postgres
tested with sqlite and postgres
---
<sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
📋 Pull Request Information
Original PR: https://github.com/open-webui/open-webui/pull/6996
Author: @Peter-De-Ath
Created: 11/17/2024
Status: ✅ Merged
Merged: 11/17/2024
Merged by: @tjbck
Base:
dev← Head:fix_get_groups_by_member_id-postgres-sqlite📝 Commits (1)
80e2d4dfix: user ID filtering in GroupTable query📊 Changes
1 file changed (+3 additions, -2 deletions)
View changed files
📝
backend/open_webui/apps/webui/models/groups.py(+3 -2)📄 Description
Description
calling get_groups_by_member_id() using postgres
This was the error produced
Fixed
tested with sqlite and postgres
🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.