Sql_mode ONLY_FULL_GROUP_BY - ERROR

Ondrej Janicko Posted in Technical Support 7 years ago

Hi,

I discovered that when MySQL has set up sqlmode to ONLYFULLGROUPBY

there is exception database syntax error when is someone try to login to administrator dashboard.

Replies
Indonesian Arsalan Shah Replied 7 years ago

Hi, If you have fix you can send us pull request we shall take a look!

German Adrian Räuchle Replied 7 years ago

ah okay ^^
yeah that would make sense that the error even dont appear ^^

Slovak Ondrej Janicko Replied 7 years ago

Hi Adrian,

yes I know this.

My notice is generaly for core team that in core OSSN files is syntax error or better say no ANSI SQL standard queryes.

German Adrian Räuchle Replied 7 years ago

Hey,
you have to login to your server and login to mysql service and execute the following:

SET GLOBAL sqlmode=(SELECT REPLACE(@@sqlmode,'ONLYFULLGROUP_BY',''));

This will get rid off the full group by error.