[PR #6996] [MERGED] fix get groups by member id postgres #76869

New Issue

GiteaMirror · 2026-05-13T10:10:23-05:00

GiteaMirror commented

2026-05-13 10:10:23 -05:00

📋 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)

80e2d4d fix: 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

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>

GiteaMirror added the pull-request label 2026-05-13 10:10:23 -05:00

GiteaMirror closed this issue

2026-05-13 10:10:25 -05:00

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/open-webui#76869