Click to display the most recently active accounts interface and the error status code is 500

⚠️ 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

NC版本：30.0.1 容器部署
点击显示最近活跃账号接口报错500状态码
/ocs/v2.php/cloud/users/recent?offset=0&limit=25&search= 该接口报错500

错误日志：DbalException
An exception occurred while executing a query: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'nextcloud30.p.configvalue' which is not in SELECT list; this is incompatible with DISTINCT

Steps to reproduce

1.登录nextcloud,右上角点击账号
2.点击最近活跃账号

Expected behavior

接口报错，返回请求期间发生错误。无法继续。

Nextcloud Server version

30

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.3

Web server

Nginx

Database engine version

MySQL

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

Fresh Nextcloud Server install

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

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

Configuration report

{
"system": {
"datadirectory": "REMOVED SENSITIVE VALUE",
"instanceid": "REMOVED SENSITIVE VALUE",
"passwordsalt": "REMOVED SENSITIVE VALUE",
"secret": "REMOVED SENSITIVE VALUE",
"trusted_domains": [
"192.168.74.131:7443"
],
"dbtype": "mysql",
"version": "30.0.1.2",
"overwrite.cli.url": "https://192.168.74.131:7443",
"dbname": "REMOVED SENSITIVE VALUE",
"dbhost": "REMOVED SENSITIVE VALUE",
"dbport": "",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "REMOVED SENSITIVE VALUE",
"dbpassword": "REMOVED SENSITIVE VALUE",
"installed": true
}
}

List of activated Apps

Enabled:

• activity: 3.0.0
• app_api: 4.0.0
• bruteforcesettings: 3.0.0
• circles: 30.0.0-dev
• cloud_federation_api: 1.13.0
• comments: 1.20.1
• contactsinteraction: 1.11.0
• dashboard: 7.10.0
• dav: 1.31.1
• federatedfilesharing: 1.20.0
• federation: 1.20.0
• files: 2.2.0
• files_downloadlimit: 3.0.0
• files_pdfviewer: 3.0.0
• files_reminders: 1.3.0
• files_sharing: 1.22.0
• files_trashbin: 1.20.1
• files_versions: 1.23.0
• firstrunwizard: 3.0.0
• logreader: 3.0.0
• lookup_server_connector: 1.18.0
• nextcloud_announcements: 2.0.0
• notifications: 3.0.0
• oauth2: 1.18.1
• password_policy: 2.0.0
• photos: 3.0.2
• privacy: 2.0.0
• provisioning_api: 1.20.0
• recommendations: 3.0.0
• related_resources: 1.5.0
• serverinfo: 2.0.0
• settings: 1.13.0
• sharebymail: 1.20.0
• support: 2.0.0
• survey_client: 2.0.0
• systemtags: 1.20.0
• text: 4.1.0
• theming: 2.5.0
• twofactor_backupcodes: 1.19.0
• updatenotification: 1.20.0
• user_status: 1.10.0
• viewer: 3.0.0
• weather_status: 1.10.0
• webhook_listeners: 1.1.0-dev
• workflowengine: 2.12.0
  Disabled:
• admin_audit: 1.20.0
• encryption: 2.18.0
• files_external: 1.22.0
• suspicious_login: 8.0.0
• twofactor_nextcloud_notification: 4.0.0
• twofactor_totp: 12.0.0-dev
• user_ldap: 1.21.0

Nextcloud Signing status

No response

Nextcloud Logs

DbalException
An exception occurred while executing a query: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'nextcloud30.p.configvalue' which is not in SELECT list; this is incompatible with DISTINCT

Additional info

No response

Start by tracing the /ocs/v2.php/cloud/users/recent endpoint and reproduce the request with offset=0, limit=25, and an empty search on MySQL. Inspect the query that uses DISTINCT with p.configvalue in ORDER BY; done means the recent-accounts request returns successfully instead of HTTP 500.