Raised This Month: $119 Target: $400

[FIXED] Amxbans mysql issue (only_full_group_by)

Post New Thread Reply   
Thread Tools Display Modes
Author Message
Join Date: Mar 2019
Location: god knows
Old 03-30-2019 , 13:22   [FIXED] Amxbans mysql issue (only_full_group_by)
Reply With Quote #1

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
but it requires super privilege and NFO doesn't offer it.
so anyone know how I can get around this stupid error.


$query=$mysql->query("SET SESSION sql_mode = '';");
Since NFO doesnt offer full privilege therefore; this will run before software starts and overwrites it.

Last edited by N1ma; 03-30-2019 at 14:34.
N1ma is offline
Junior Member
Join Date: Apr 2014
Old 11-17-2020 , 12:13   Re: [FIXED] Amxbans mysql issue (only_full_group_by)
Reply With Quote #2

i have the same problem but he is banned , mby can someone to tell me where do i have to put this query ?
glmmlg is offline
Send a message via Skype™ to glmmlg

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -4. The time now is 06:28.

Powered by vBulletin®
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Theme made by Freecode