-
Notifications
You must be signed in to change notification settings - Fork 748
SELECT list is not in GROUP BY clause and contains nonaggregated column #1573
Comments
Well, its easy to resolve all you have to do is create a file in your home directory, where you have to define your my.cnf for mysql and append this [mysqld] this will resolve the issue you need to remove the schemas, which is of migration |
What if someone doesn't have access to my.cnf, like remote hosts such as GoDaddy? |
This is an infrastructure issue related to changes done in mysql , either you have to change the query or configuration. Choice is yours. |
You can request that mysql 5.5 or 5.6 be provided for you since the changes started with mysql 5.7 |
@techkey thank you for your interest in Mifos. This Git repository is no longer actively maintained, but we would love to see your contributions over in https://github.com/apache/fineract, which is the exact same code as this one. Just FYI, that apache/fineract project doesn't use Git Hub Issues but instead they use issues in the FINERACT project in the Apache JIRA, here: https://issues.apache.org/jira. You may also be interested in having a look at http://fineract.apache.org for a better overview and more resources. I'm closing this old open issue to avoid any future confusion to others. /Cc FYI @openMF/admins @openMF/core-team @meonkeys @myrle-krantz |
Quote:
As of MySQL 5.7.5, the default SQL mode includes ONLY_FULL_GROUP_BY.
Full article here:
http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_only_full_group_by
That gives problems in file
V118_7__move_withdrawal_annual_fee_to_charges.sql
on line 235, perhaps in more files.The text was updated successfully, but these errors were encountered: