[Bug]: Lazy loading of users in the user overview does not work properly (allways all users included disabled users will requested over ajax)

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

If you open the user overview (top right round circle --> Users), then only 6 users are usually displayed under "Active Users", although on the left next to "Active Users" there is a higher number (the actual number of users). All users were created in an older version of Nextcloud and the instance was only updated to the latest version 28.0.3.

If you click on a self-created group in the user view on the left side, only 7 will be displayed instead of e.g. B. the real 22 users are displayed. There should be 4 users in another group, but when you click on the group, no users at all are displayed.

You can only find users if you search for them.

It seems to me that the problem is related to the lazy loading of the user list. If you make the window so small that you have to scroll even if there are only 6 users displayed, 2 users will always be reloaded until all users are visible at some point. If you can't scroll, you can't force the list to reload.

Update 2024-03-29: The problem is the ajax query: details?offset... This query requests allways all users included disabled users. So if the first offset only delivers disabled users, the group is empty.

Can you disable lazy loading of the user list or is there a temporary workaround? This error only occurred with the upgrade to version 28.0.3 und to 28.0.4

The update was carried out using the command line OCC and via the web interface.

Steps to reproduce

1. top right round circle --> Users
2. now you see that only a small part of users is loaded
3. if you click on the left for a filter like "active users", a group name or someting else, in most cases only a few users will be displayed

Expected behavior

If I go to top right round circle --> Users, I want to see all active users. If I click on the left on a other user group, I want to see all users in this group.

Installation method

Community Web installer on a VPS or web space

Nextcloud Server version

28

Operating system

RHEL/CentOS

PHP engine version

PHP 8.3

Web server

Apache (supported)

Database engine version

MariaDB

Is this bug present after an update or on a fresh install?

Upgraded to a MAJOR version (ex. 22 to 23)

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other

Configuration report

{
    "system": {
        "activity_expire_days": 365,
        "default_language": "de",
        "default_locale": "de_DE",
        "default_phone_region": "DE",
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "div.skenet.de"
        ],
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.local": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379
        },
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "28.0.3.2",
        "overwrite.cli.url": "https:\/\/div.skenet.de",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "lost_password_link": "disabled",
        "auth.webauthn.enabled": false,
        "maintenance": false,
        "theme": "",
        "loglevel": 2,
        "htaccess.RewriteBase": "\/",
        "app_install_overwrite": [
            "files_trackdownloads",
            "files_downloadactivity"
        ],
        "updater.release.channel": "stable",
        "maintenance_window_start": 1,
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpsecure": "ssl",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465"
    }
}

List of activated Apps

Enabled:
  - activity: 2.20.0
  - admin_audit: 1.18.0
  - circles: 28.0.0-dev
  - cloud_federation_api: 1.11.0
  - dav: 1.29.1
  - federatedfilesharing: 1.18.0
  - files: 2.0.0
  - files_pdfviewer: 2.9.0
  - files_reminders: 1.1.0
  - files_sharing: 1.20.0
  - logreader: 2.13.0
  - lookup_server_connector: 1.16.0
  - nextcloud_announcements: 1.17.0
  - notifications: 2.16.0
  - oauth2: 1.16.3
  - password_policy: 1.18.0
  - privacy: 1.12.0
  - provisioning_api: 1.18.0
  - related_resources: 1.3.0
  - serverinfo: 1.18.0
  - settings: 1.10.1
  - theming: 2.3.0
  - twofactor_backupcodes: 1.17.0
  - updatenotification: 1.18.0
  - viewer: 2.2.0
  - workflowengine: 2.10.0
Disabled:
  - bruteforcesettings: 2.8.0 (installed 2.4.0)
  - comments: 1.18.0 (installed 1.11.0)
  - contactsinteraction: 1.9.0 (installed 1.2.0)
  - dashboard: 7.8.0 (installed 7.1.0)
  - encryption: 2.16.0
  - federation: 1.18.0 (installed 1.11.0)
  - files_downloadactivity: 1.16.0 (installed 1.16.0)
  - files_external: 1.20.0
  - files_trackdownloads: 1.11.0 (installed 1.11.0)
  - files_trashbin: 1.18.0 (installed 1.11.0)
  - files_versions: 1.21.0 (installed 1.14.0)
  - firstrunwizard: 2.17.0 (installed 2.10.0)
  - photos: 2.4.0 (installed 1.3.0)
  - recommendations: 2.0.0 (installed 1.0.0)
  - sharebymail: 1.18.0 (installed 1.11.0)
  - support: 1.11.0 (installed 1.4.0)
  - survey_client: 1.16.0 (installed 1.9.0)
  - suspicious_login: 6.0.0
  - systemtags: 1.18.0 (installed 1.11.0)
  - text: 3.9.1 (installed 3.2.0)
  - twofactor_totp: 10.0.0-beta.2
  - user_ldap: 1.19.0
  - user_status: 1.8.1 (installed 1.1.1)
  - weather_status: 1.8.0 (installed 1.1.0)

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

No response

Additional info

No response

Start by reproducing the issue from the Users overview and inspect the details?offset... AJAX request while switching between Active Users and groups. Trace how disabled users affect the offset results; done means each view loads all users matching its selected filter, including groups with fewer users than the page size.