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

fbroen commented 6 months ago

⚠️ This issue respects the following points: ⚠️

[X] This is a bug, not a question or a configuration/webserver/proxy issue.
[X] This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
[X] Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
[X] 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.

exact_error_nextcloud

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

top right round circle --> Users
now you see that only a small part of users is loaded
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?

[X] 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

fbroen commented 6 months ago

I think I have found the exact problem / bug. Is anyone there from the developer team to look through this report? I added new information about this problem.

bbx-github commented 3 months ago

I can confirm this problem. I have an instance with ~80 active and ~200 disabled users. When I use my normal window size following number of users is displayed:

Active users: 11/80
Disabled users: all/200 (do not fit in window: scrolling down)
group1: 13/50
group2: all/30
group3: all/10

When I shrink my window so that not all users fit in and then I scroll down also for "Active users" and "group1" all users are displayed if I scroll down.

Installation method

installed from tar

Nextcloud Server version

28.0.8 (updated many times using command line updater)

Operating system

debian11

PHP engine version

PHP 8.2

Web server

nginx

Database engine version

MariaDB 10.5

nextcloud / server