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

yykgit commented 1 month 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

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?

[x] 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", "trusteddomains": [ "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

sbe-arg commented 4 weeks ago

same here on 3 servers running 30.0.1

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 'nextcloud.p.configvalue' which is not in SELECT list; this is incompatible with DISTINCT

benjaminfrombe commented 3 weeks ago

same here ..

sbe-arg commented 3 weeks ago

Its in the list of fixes coming on 30.0.2 apparently so we need to wait.

nextcloud / server