Sql_mode ONLY_FULL_GROUP_BY - ERROR
Hi,
I discovered that when MySQL has set up sql_mode to ONLY_FULL_GROUP_BY
there is exception database syntax error when is someone try to login to administrator dashboard.
Hi, If you have fix you can send us pull request we shall take a look!
ah okay ^^
yeah that would make sense that the error even dont appear ^^
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.
Hey,
you have to login to your server and login to mysql service and execute the following:
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
This will get rid off the full group by error.
Due to the many requests in the past for additonal features and components we have decided to develope a premium version. Features like Hashtags, Videos, Polls, Events, Stories, Link Preview, etc included in it.
$199 (Life Time)
Learn More