first of all I'm using NFO
I got this issue when I go to search tab of my amxbans
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'blublu_amx.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
I tried to solve the issue with
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
but it requires super privilege and NFO doesn't offer it.
so anyone know how I can get around this stupid error.
Since NFO doesnt offer full privilege therefore; this will run before software starts and overwrites it.
$query=$mysql->query("SET SESSION sql_mode = '';");