Raised This Month: $119 Target: $400
 29% 

[FIXED] Amxbans mysql issue (only_full_group_by)


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
N1ma
BANNED
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

Code:
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
Code:
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.

FIXED IT

Code:
$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
glmmlg
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
Reply


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