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:
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 BYExpected Behavior
The panel should work with both MariaDB and MySQL providers
Steps to Reproduce
- Set
DB_CONNECTIONtomariadb - 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
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.
Source: pterodactyl/panel