#5708·panel

MariaDB connection fails on grouped queries

Author: PadowYT2Created Aug 21, 2026Updated Aug 21, 2026

Current Behavior

When using a MariaDB connection, errors occur with a queries that works with a MySQL provider. This is one of the error, when trying to view the server list:

bash
SQLSTATE[42000]: Syntax error or access violation: 1055 'panel.servers.external_id' isn't in GROUP BY (Connection: mariadb, Socket: /run/mysqld/mysqld.sock, Database: panel, SQL: select `servers`.* from `servers` left join `subusers` on `subusers`.`server_id` = `servers`.`id` where (`servers`.`owner_id` = 1 or `subusers`.`user_id` = 1) group by `servers`.`id`) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1055 'panel.servers.external_id' isn't in GROUP BY

Expected Behavior

The panel should work with both MariaDB and MySQL providers

Steps to Reproduce

  1. Set DB_CONNECTION to mariadb
  2. Open the server list

Panel Version

1.15.1

Wings Version

1.13.3

Games and/or Eggs Affected

No response

Docker Image

No response

Error Logs

bash

Is there an existing issue for this?

  • I have searched the existing issues before opening this issue. I understand that maintainers may close this issue without communication if I have not provided sufficient information.