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
Git Clone
Open WebUI Version
v0.6.38
Ollama Version (if applicable)
No response
Operating System
Ubuntu 24.04.3
Browser (if applicable)
No response
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
The admin panel user list should show the correct total user count, and should show 30(PAGE_ITEM_COUNT) items per page
Actual Behavior
shows Users $extremelyHighNumber of $n available users
shows only 5 users on page 1, 2 users on page 2
is also very slow
Steps to Reproduce
have multiple users with multiple groups
open Admin Panel Users Overview
Logs & Screenshots
call to /api/v1/users/?page=1&order_by=created_at&direction=asc only returns 5 items. no relevant log messages.
diff --git a/backend/open_webui/models/users.py b/backend/open_webui/models/users.py
index 256d3bc75..08b48efa5 100644
--- a/backend/open_webui/models/users.py
+++ b/backend/open_webui/models/users.py
@@ -227,9 +227,12 @@ class UsersTable:
) -> dict:
with get_db() as db:
# Join GroupMember so we can order by group_id when requested
- query = db.query(User).outerjoin(
- GroupMember, GroupMember.user_id == User.id
- )
+ query = db.query(User)
+ if filter and filter.get("order_by") and filter.get("order_by").startswith("group_id:"):
+ query = query.outerjoin(GroupMember, GroupMember.user_id == User.id)
if filter:
query_key = filter.get("query")
Originally created by @destination-one on GitHub (Nov 24, 2025).
Original GitHub issue: https://github.com/open-webui/open-webui/issues/19429
### 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
Git Clone
### Open WebUI Version
v0.6.38
### Ollama Version (if applicable)
_No response_
### Operating System
Ubuntu 24.04.3
### Browser (if applicable)
_No response_
### 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
The admin panel user list should show the correct total user count, and should show 30(PAGE_ITEM_COUNT) items per page
### Actual Behavior
- shows Users $extremelyHighNumber of $n available users
- shows only 5 users on page 1, 2 users on page 2
- is also very slow
### Steps to Reproduce
- have multiple users with multiple groups
- open Admin Panel Users Overview
### Logs & Screenshots
call to /api/v1/users/?page=1&order_by=created_at&direction=asc only returns 5 items. no relevant log messages.
### Additional Information
i believe it is caused by https://github.com/open-webui/open-webui/commit/73734b186bdcf79cb689df1a145473b18c294875
a quick workaround:
```diff
diff --git a/backend/open_webui/models/users.py b/backend/open_webui/models/users.py
index 256d3bc75..08b48efa5 100644
--- a/backend/open_webui/models/users.py
+++ b/backend/open_webui/models/users.py
@@ -227,9 +227,12 @@ class UsersTable:
) -> dict:
with get_db() as db:
# Join GroupMember so we can order by group_id when requested
- query = db.query(User).outerjoin(
- GroupMember, GroupMember.user_id == User.id
- )
+ query = db.query(User)
+ if filter and filter.get("order_by") and filter.get("order_by").startswith("group_id:"):
+ query = query.outerjoin(GroupMember, GroupMember.user_id == User.id)
if filter:
query_key = filter.get("query")
```
GiteaMirror
added the bug label 2026-05-21 00:43:51 -05:00
I confirm I have the same issue on my instance and was about to create an Issue but found this one.
I will follow!
The error count looks like a multiplication caused by users being in multiple groups
<!-- gh-comment-id:3572135450 -->
@le-patenteux commented on GitHub (Nov 24, 2025):
I confirm I have the same issue on my instance and was about to create an Issue but found this one.
I will follow!
The error count looks like a multiplication caused by users being in multiple groups
Total amount of users is the sum of all users in groups, even if it is the same individual repeating.
If you remove a user from a group, total drops by 1
<!-- gh-comment-id:3572855521 -->
@le-patenteux commented on GitHub (Nov 24, 2025):
**To reproduce:**
- Have multiple user groups
- Have users in more than one group
Total amount of users is the sum of all users in groups, even if it is the same individual repeating.
If you remove a user from a group, total drops by 1
<!-- gh-comment-id:3572868019 -->
@Classic298 commented on GitHub (Nov 24, 2025):
ok thanks
CAN reproduce BEFORE tim's commit.
Now testing on latest dev... lets see...
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.
Originally created by @destination-one on GitHub (Nov 24, 2025).
Original GitHub issue: https://github.com/open-webui/open-webui/issues/19429
Check Existing Issues
Installation Method
Git Clone
Open WebUI Version
v0.6.38
Ollama Version (if applicable)
No response
Operating System
Ubuntu 24.04.3
Browser (if applicable)
No response
Confirmation
README.md.Expected Behavior
The admin panel user list should show the correct total user count, and should show 30(PAGE_ITEM_COUNT) items per page
Actual Behavior
Steps to Reproduce
Logs & Screenshots
call to /api/v1/users/?page=1&order_by=created_at&direction=asc only returns 5 items. no relevant log messages.
Additional Information
i believe it is caused by https://github.com/open-webui/open-webui/commit/73734b186bdcf79cb689df1a145473b18c294875
a quick workaround:
@le-patenteux commented on GitHub (Nov 24, 2025):
I confirm I have the same issue on my instance and was about to create an Issue but found this one.
I will follow!
The error count looks like a multiplication caused by users being in multiple groups
@tjbck commented on GitHub (Nov 24, 2025):
Should be addressed in dev, testing wanted here.
@Classic298 commented on GitHub (Nov 24, 2025):
cannot reproduce, neither before tim's commit, nor after.
@le-patenteux commented on GitHub (Nov 24, 2025):
To reproduce:
Total amount of users is the sum of all users in groups, even if it is the same individual repeating.
If you remove a user from a group, total drops by 1
@Classic298 commented on GitHub (Nov 24, 2025):
thanks let me test again
@Classic298 commented on GitHub (Nov 24, 2025):
ok thanks
CAN reproduce BEFORE tim's commit.
Now testing on latest dev... lets see...
@Classic298 commented on GitHub (Nov 24, 2025):
And CANNOT reproduce on latest dev
Tim's commit fixed it.