[GH-ISSUE #21325] issue: Groupacces to Workspace Models #58109

Closed
opened 2026-05-05 22:20:46 -05:00 by GiteaMirror · 1 comment
Owner

Originally created by @VonNao on GitHub (Feb 12, 2026).
Original GitHub issue: https://github.com/open-webui/open-webui/issues/21325

Check Existing Issues

  • I have searched for any existing and/or related issues.
  • I have searched for any existing and/or related discussions.
  • I have also searched in the CLOSED issues AND CLOSED discussions and found no related items (your issue might already be addressed on the development branch!).
  • I am using the latest version of Open WebUI.

Installation Method

Other

Open WebUI Version

7.2

Ollama Version (if applicable)

No response

Operating System

Kubernetes Talos 1.12.3

Browser (if applicable)

Chrome, Edge, Zen/Firefox

Confirmation

  • I have read and followed all instructions in README.md.
  • I am using the latest version of both Open WebUI and Ollama.
  • I have included the browser console logs.
  • I have included the Docker container logs.
  • I have provided every relevant configuration, setting, and environment variable used in my setup.
  • I have clearly listed every relevant configuration, custom setting, environment variable, and command-line option that influences my setup (such as Docker Compose overrides, .env values, browser settings, authentication configurations, etc).
  • I have documented step-by-step reproduction instructions that are precise, sequential, and leave nothing to interpretation. My steps:
  • Start with the initial platform/version/OS and dependencies used,
  • Specify exact install/launch/configure commands,
  • List URLs visited, user input (incl. example values/emails/passwords if needed),
  • Describe all options and toggles enabled or changed,
  • Include any files or environmental changes,
  • Identify the expected and actual result at each stage,
  • Ensure any reasonably skilled user can follow and hit the same issue.

Expected Behavior

I got some unprivileged user in my environment which are allowed to create models under workspace. The user would like to share this model with others via the access control

Actual Behavior

After pressing the share button the user is stuck in the Pop up and cant select any groups what so ever.

Steps to Reproduce

Install is Openwebui via Kubernetes

3 Replicas of Openwebui
Dragonfly/Rediscluster
3 Node Postgrescluster via CNPG

Users are managed via Keycloak with OIDC

Logs & Screenshots

From the logs of openwebui

File "/usr/local/lib/python3.11/contextlib.py", line 158, in __exit__                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   │
│     self.gen.throw(typ, value, traceback)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 │
│   File "/usr/local/lib/python3.11/site-packages/starlette/_utils.py", line 85, in collapse_excgroups                                                                                                                                                                                                                                                                                                                                                                                                                                                      │
│     raise exc                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             │
│   File "/usr/local/lib/python3.11/site-packages/starlette/middleware/base.py", line 193, in __call__                                                                                                                                                                                                                                                                                                                                                                                                                                                      │
│     response = await self.dispatch_func(request, call_next)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               │
│                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               │
│   File "/app/backend/open_webui/main.py", line 1304, in dispatch                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          │
│     response = await call_next(request)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   │
│                ^^^^^^^^^^^^^^^^^^^^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   │
│   File "/usr/local/lib/python3.11/site-packages/starlette/middleware/base.py", line 168, in call_next                                                                                                                                                                                                                                                                                                                                                                                                                                                     │
│     raise app_exc from app_exc.__cause__ or app_exc.__context__                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           │
│   File "/usr/local/lib/python3.11/site-packages/starlette/middleware/base.py", line 144, in coro                                                                                                                                                                                                                                                                                                                                                                                                                                                          │
│     await self.app(scope, receive_or_disconnect, send_no_error)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           │
│   File "/usr/local/lib/python3.11/site-packages/starlette_compress/__init__.py", line 92, in __call__                                                                                                                                                                                                                                                                                                                                                                                                                                                     │
│     return await self._zstd(scope, receive, send)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         │
│            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         │
│   File "/usr/local/lib/python3.11/site-packages/starlette_compress/_zstd_legacy.py", line 100, in __call__                                                                                                                                                                                                                                                                                                                                                                                                                                                │
│     await self.app(scope, receive, wrapper)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               │
│   File "/usr/local/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 63, in __call__                                                                                                                                                                                                                                                                                                                                                                                                                                                 │
│     await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send)                                                                                                                                                                                                                                                                                                                                                                                                                                                                              │
│   File "/usr/local/lib/python3.11/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app                                                                                                                                                                                                                                                                                                                                                                                                                                                 │
│     raise exc                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             │
│   File "/usr/local/lib/python3.11/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app                                                                                                                                                                                                                                                                                                                                                                                                                                                 │
│     await app(scope, receive, sender)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     │
│   File "/usr/local/lib/python3.11/site-packages/fastapi/middleware/asyncexitstack.py", line 18, in __call__                                                                                                                                                                                                                                                                                                                                                                                                                                               │
│     await self.app(scope, receive, send)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  │
│   File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 716, in __call__                                                                                                                                                                                                                                                                                                                                                                                                                                                              │
│     await self.middleware_stack(scope, receive, send)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     │
│   File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 736, in app                                                                                                                                                                                                                                                                                                                                                                                                                                                                   │
│     await route.handle(scope, receive, send)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              │
│   File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 290, in handle                                                                                                                                                                                                                                                                                                                                                                                                                                                                │
│     await self.app(scope, receive, send)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  │
│   File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 115, in app                                                                                                                                                                                                                                                                                                                                                                                                                                                                     │
│     await wrap_app_handling_exceptions(app, request)(scope, receive, send)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                │
│   File "/usr/local/lib/python3.11/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app                                                                                                                                                                                                                                                                                                                                                                                                                                                 │
│     raise exc                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             │
│   File "/usr/local/lib/python3.11/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app                                                                                                                                                                                                                                                                                                                                                                                                                                                 │
│     await app(scope, receive, sender)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     │
│   File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 101, in app                                                                                                                                                                                                                                                                                                                                                                                                                                                                     │
│     response = await f(request)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           │
│                ^^^^^^^^^^^^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           │
│   File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 355, in app                                                                                                                                                                                                                                                                                                                                                                                                                                                                     │
│     raw_response = await run_endpoint_function(                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           │
│                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           │
│   File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 243, in run_endpoint_function                                                                                                                                                                                                                                                                                                                                                                                                                                                   │
│     return await dependant.call(**values)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 │
│            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 │
│   File "/app/backend/open_webui/routers/groups.py", line 49, in get_groups                                                                                                                                                                                                                                                                                                                                                                                                                                                                                │
│     groups = Groups.get_groups(filter=filter, db=db)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      │
│              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      │
│   File "/app/backend/open_webui/models/groups.py", line 207, in get_groups                                                                                                                                                                                                                                                                                                                                                                                                                                                                                │
│     groups = query.order_by(Group.updated_at.desc()).all()                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                │
│              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                │
│   File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2704, in all                                                                                                                                                                                                                                                                                                                                                                                                                                                               │
│     return self._iter().all()  # type: ignore                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             │
│            ^^^^^^^^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   │
│   File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2857, in _iter                                                                                                                                                                                                                                                                                                                                                                                                                                                             │
│     result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   │
│                                                   ^^^^^^^^^^^^^^^^^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   │
│   File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2351, in execute                                                                                                                                                                                                                                                                                                                                                                                                                                                         │
│     return self._execute_internal(                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        │
│            ^^^^^^^^^^^^^^^^^^^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        │
│   File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2249, in _execute_internal                                                                                                                                                                                                                                                                                                                                                                                                                                               │
│     result: Result[Any] = compile_state_cls.orm_execute_statement(                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        │
│                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        │
│   File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/context.py", line 306, in orm_execute_statement                                                                                                                                                                                                                                                                                                                                                                                                                                            │
│     result = conn.execute(                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                │
│              ^^^^^^^^^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                │
│   File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1419, in execute                                                                                                                                                                                                                                                                                                                                                                                                                                                         │
│     return meth(                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          │
│            ^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          │
│   File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 527, in _execute_on_connection                                                                                                                                                                                                                                                                                                                                                                                                                                          │
│     return connection._execute_clauseelement(                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             │
│            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             │
│   File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement                                                                                                                                                                                                                                                                                                                                                                                                                                          │
│     ret = self._execute_context(                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          │
│           ^^^^^^^^^^^^^^^^^^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          │
│   File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context                                                                                                                                                                                                                                                                                                                                                                                                                                                │
│     return self._exec_single_context(                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     │
│            ^^^^^^^^^^^^^^^^^^^^^^^^^^                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     │
│   File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context                                                                                                                                                                                                                                                                                                                                                                                                                                            │
│     self._handle_dbapi_exception(                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         │
│   File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2363, in _handle_dbapi_exception                                                                                                                                                                                                                                                                                                                                                                                                                                         │
│     raise sqlalchemy_exception.with_traceback(exc_info[2]) from e                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         │
│   File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context                                                                                                                                                                                                                                                                                                                                                                                                                                            │
│     self.dialect.do_execute(                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              │
│   File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute                                                                                                                                                                                                                                                                                                                                                                                                                                                    │
│     cursor.execute(statement, parameters)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 │
│ sqlalchemy.exc.DataError: (psycopg2.errors.InvalidTextRepresentation) invalid input syntax for type boolean: "members"                                                                                                                                                                                                                                                                                                                                                                                                                                    │
│                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           │
│ [SQL: 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".created_at AS group_created_at, "group".updated_at AS group_updated_at                                                                                                                                                                                                                             │
│ FROM "group"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              │
│ WHERE "group".data IS NULL OR CAST((("group".data -> %(data_1)s) ->> %(param_1)s) AS BOOLEAN) IS NULL OR CAST((("group".data -> %(data_1)s) ->> %(param_1)s) AS BOOLEAN) = true OR CAST((("group".data -> %(data_1)s) ->> %(param_1)s) AS VARCHAR) = %(param_2)s AND "group".id IN (SELECT anon_1.group_id                                                                                                                                                                                                                                                │
│ FROM (SELECT group_member.group_id AS group_id                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            │
│ FROM group_member                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         │
│ WHERE group_member.user_id = %(user_id_1)s) AS anon_1) ORDER BY "group".updated_at DESC]                                                                                                                                                                                                                                                                                                                                                                                                                                                                  │
│ [parameters: {'data_1': 'config', 'param_1': 'share', 'param_2': 'members', 'user_id_1': 'some-user-id'}]

I can also see that the api call against /api/v1/groups/?share=true fails with 500

Image Image

Additional Information

No response

Originally created by @VonNao on GitHub (Feb 12, 2026). Original GitHub issue: https://github.com/open-webui/open-webui/issues/21325 ### Check Existing Issues - [x] I have searched for any existing and/or related issues. - [x] I have searched for any existing and/or related discussions. - [x] I have also searched in the CLOSED issues AND CLOSED discussions and found no related items (your issue might already be addressed on the development branch!). - [x] I am using the latest version of Open WebUI. ### Installation Method Other ### Open WebUI Version 7.2 ### Ollama Version (if applicable) _No response_ ### Operating System Kubernetes Talos 1.12.3 ### Browser (if applicable) Chrome, Edge, Zen/Firefox ### Confirmation - [x] I have read and followed all instructions in `README.md`. - [x] I am using the latest version of **both** Open WebUI and Ollama. - [x] I have included the browser console logs. - [x] I have included the Docker container logs. - [x] I have **provided every relevant configuration, setting, and environment variable used in my setup.** - [x] I have clearly **listed every relevant configuration, custom setting, environment variable, and command-line option that influences my setup** (such as Docker Compose overrides, .env values, browser settings, authentication configurations, etc). - [x] I have documented **step-by-step reproduction instructions that are precise, sequential, and leave nothing to interpretation**. My steps: - Start with the initial platform/version/OS and dependencies used, - Specify exact install/launch/configure commands, - List URLs visited, user input (incl. example values/emails/passwords if needed), - Describe all options and toggles enabled or changed, - Include any files or environmental changes, - Identify the expected and actual result at each stage, - Ensure any reasonably skilled user can follow and hit the same issue. ### Expected Behavior I got some unprivileged user in my environment which are allowed to create models under workspace. The user would like to share this model with others via the access control ### Actual Behavior After pressing the share button the user is stuck in the Pop up and cant select any groups what so ever. ### Steps to Reproduce Install is Openwebui via Kubernetes 3 Replicas of Openwebui Dragonfly/Rediscluster 3 Node Postgrescluster via CNPG Users are managed via Keycloak with OIDC ### Logs & Screenshots From the logs of openwebui ``` File "/usr/local/lib/python3.11/contextlib.py", line 158, in __exit__ │ │ self.gen.throw(typ, value, traceback) │ │ File "/usr/local/lib/python3.11/site-packages/starlette/_utils.py", line 85, in collapse_excgroups │ │ raise exc │ │ File "/usr/local/lib/python3.11/site-packages/starlette/middleware/base.py", line 193, in __call__ │ │ response = await self.dispatch_func(request, call_next) │ │ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ │ │ File "/app/backend/open_webui/main.py", line 1304, in dispatch │ │ response = await call_next(request) │ │ ^^^^^^^^^^^^^^^^^^^^^^^^ │ │ File "/usr/local/lib/python3.11/site-packages/starlette/middleware/base.py", line 168, in call_next │ │ raise app_exc from app_exc.__cause__ or app_exc.__context__ │ │ File "/usr/local/lib/python3.11/site-packages/starlette/middleware/base.py", line 144, in coro │ │ await self.app(scope, receive_or_disconnect, send_no_error) │ │ File "/usr/local/lib/python3.11/site-packages/starlette_compress/__init__.py", line 92, in __call__ │ │ return await self._zstd(scope, receive, send) │ │ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ │ │ File "/usr/local/lib/python3.11/site-packages/starlette_compress/_zstd_legacy.py", line 100, in __call__ │ │ await self.app(scope, receive, wrapper) │ │ File "/usr/local/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 63, in __call__ │ │ await wrap_app_handling_exceptions(self.app, conn)(scope, receive, send) │ │ File "/usr/local/lib/python3.11/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app │ │ raise exc │ │ File "/usr/local/lib/python3.11/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app │ │ await app(scope, receive, sender) │ │ File "/usr/local/lib/python3.11/site-packages/fastapi/middleware/asyncexitstack.py", line 18, in __call__ │ │ await self.app(scope, receive, send) │ │ File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 716, in __call__ │ │ await self.middleware_stack(scope, receive, send) │ │ File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 736, in app │ │ await route.handle(scope, receive, send) │ │ File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 290, in handle │ │ await self.app(scope, receive, send) │ │ File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 115, in app │ │ await wrap_app_handling_exceptions(app, request)(scope, receive, send) │ │ File "/usr/local/lib/python3.11/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app │ │ raise exc │ │ File "/usr/local/lib/python3.11/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app │ │ await app(scope, receive, sender) │ │ File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 101, in app │ │ response = await f(request) │ │ ^^^^^^^^^^^^^^^^ │ │ File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 355, in app │ │ raw_response = await run_endpoint_function( │ │ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ │ │ File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 243, in run_endpoint_function │ │ return await dependant.call(**values) │ │ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ │ │ File "/app/backend/open_webui/routers/groups.py", line 49, in get_groups │ │ groups = Groups.get_groups(filter=filter, db=db) │ │ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ │ │ File "/app/backend/open_webui/models/groups.py", line 207, in get_groups │ │ groups = query.order_by(Group.updated_at.desc()).all() │ │ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ │ │ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2704, in all │ │ return self._iter().all() # type: ignore │ │ ^^^^^^^^^^^^ │ │ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2857, in _iter │ │ result: Union[ScalarResult[_T], Result[_T]] = self.session.execute( │ │ ^^^^^^^^^^^^^^^^^^^^^ │ │ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2351, in execute │ │ return self._execute_internal( │ │ ^^^^^^^^^^^^^^^^^^^^^^^ │ │ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2249, in _execute_internal │ │ result: Result[Any] = compile_state_cls.orm_execute_statement( │ │ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ │ │ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/context.py", line 306, in orm_execute_statement │ │ result = conn.execute( │ │ ^^^^^^^^^^^^^ │ │ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1419, in execute │ │ return meth( │ │ ^^^^^ │ │ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 527, in _execute_on_connection │ │ return connection._execute_clauseelement( │ │ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ │ │ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement │ │ ret = self._execute_context( │ │ ^^^^^^^^^^^^^^^^^^^^^^ │ │ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context │ │ return self._exec_single_context( │ │ ^^^^^^^^^^^^^^^^^^^^^^^^^^ │ │ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context │ │ self._handle_dbapi_exception( │ │ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2363, in _handle_dbapi_exception │ │ raise sqlalchemy_exception.with_traceback(exc_info[2]) from e │ │ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context │ │ self.dialect.do_execute( │ │ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute │ │ cursor.execute(statement, parameters) │ │ sqlalchemy.exc.DataError: (psycopg2.errors.InvalidTextRepresentation) invalid input syntax for type boolean: "members" │ │ │ │ [SQL: 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".created_at AS group_created_at, "group".updated_at AS group_updated_at │ │ FROM "group" │ │ WHERE "group".data IS NULL OR CAST((("group".data -> %(data_1)s) ->> %(param_1)s) AS BOOLEAN) IS NULL OR CAST((("group".data -> %(data_1)s) ->> %(param_1)s) AS BOOLEAN) = true OR CAST((("group".data -> %(data_1)s) ->> %(param_1)s) AS VARCHAR) = %(param_2)s AND "group".id IN (SELECT anon_1.group_id │ │ FROM (SELECT group_member.group_id AS group_id │ │ FROM group_member │ │ WHERE group_member.user_id = %(user_id_1)s) AS anon_1) ORDER BY "group".updated_at DESC] │ │ [parameters: {'data_1': 'config', 'param_1': 'share', 'param_2': 'members', 'user_id_1': 'some-user-id'}] ``` I can also see that the api call against /api/v1/groups/?share=true fails with 500 <img width="726" height="332" alt="Image" src="https://github.com/user-attachments/assets/9fd171d3-a482-4374-b8e1-22312f18b4e7" /> <img width="1105" height="145" alt="Image" src="https://github.com/user-attachments/assets/02686da7-4943-4664-aecb-da0d97791108" /> ### Additional Information _No response_
GiteaMirror added the bug label 2026-05-05 22:20:46 -05:00
Author
Owner

@Classic298 commented on GitHub (Feb 12, 2026):

check for duplicates and use the search. Please. - fixed in dev

<!-- gh-comment-id:3889545974 --> @Classic298 commented on GitHub (Feb 12, 2026): **check for duplicates** and use the search. <ins>**Please.**</ins> - fixed in dev
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/open-webui#58109