Code: Select all
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'clanlod_amxbans.amx_bans.admin_nick' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
This only recently started happening so I believe maybe a php update?
Database server I'm using:
Code: Select all
Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.7.27 - Gentoo Linux mysql-5.7.27-r1
Protocol version: 10
User: clanlod@localhost
Server charset: UTF-8 Unicode (utf8)
Webserver I'm using:
Code: Select all
Apache
Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
PHP version: 7.2.24