{"action":"created","issue":{"url":"https://api.github.com/repos/openMF/mifosx/issues/1573","repository_url":"https://api.github.com/repos/openMF/mifosx","labels_url":"https://api.github.com/repos/openMF/mifosx/issues/1573/labels{/name}","comments_url":"https://api.github.com/repos/openMF/mifosx/issues/1573/comments","events_url":"https://api.github.com/repos/openMF/mifosx/issues/1573/events","html_url":"https://github.com/openMF/mifosx/issues/1573","id":123494231,"number":1573,"title":"SELECT list is not in GROUP BY clause and contains nonaggregated column","user":{"login":"techkey","id":670271,"avatar_url":"https://avatars.githubusercontent.com/u/670271?v=3","gravatar_id":"","url":"https://api.github.com/users/techkey","html_url":"https://github.com/techkey","followers_url":"https://api.github.com/users/techkey/followers","following_url":"https://api.github.com/users/techkey/following{/other_user}","gists_url":"https://api.github.com/users/techkey/gists{/gist_id}","starred_url":"https://api.github.com/users/techkey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/techkey/subscriptions","organizations_url":"https://api.github.com/users/techkey/orgs","repos_url":"https://api.github.com/users/techkey/repos","events_url":"https://api.github.com/users/techkey/events{/privacy}","received_events_url":"https://api.github.com/users/techkey/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-12-22T14:51:16Z","updated_at":"2016-03-01T19:54:43Z","closed_at":null,"body":"Quote:\r\n`As of MySQL 5.7.5, the default SQL mode includes ONLY_FULL_GROUP_BY.`\r\n\r\nFull article here:\r\nhttp://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_only_full_group_by\r\n\r\nThat gives problems in file `V118_7__move_withdrawal_annual_fee_to_charges.sql` on line 235, perhaps in more files."},"comment":{"url":"https://api.github.com/repos/openMF/mifosx/issues/comments/190876352","html_url":"https://github.com/openMF/mifosx/issues/1573#issuecomment-190876352","issue_url":"https://api.github.com/repos/openMF/mifosx/issues/1573","id":190876352,"user":{"login":"theupscale","id":1921829,"avatar_url":"https://avatars.githubusercontent.com/u/1921829?v=3","gravatar_id":"","url":"https://api.github.com/users/theupscale","html_url":"https://github.com/theupscale","followers_url":"https://api.github.com/users/theupscale/followers","following_url":"https://api.github.com/users/theupscale/following{/other_user}","gists_url":"https://api.github.com/users/theupscale/gists{/gist_id}","starred_url":"https://api.github.com/users/theupscale/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/theupscale/subscriptions","organizations_url":"https://api.github.com/users/theupscale/orgs","repos_url":"https://api.github.com/users/theupscale/repos","events_url":"https://api.github.com/users/theupscale/events{/privacy}","received_events_url":"https://api.github.com/users/theupscale/received_events","type":"User","site_admin":false},"created_at":"2016-03-01T19:54:43Z","updated_at":"2016-03-01T19:54:43Z","body":"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 \r\n\r\n[mysqld]\r\nsql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION\r\n\r\nthis will resolve the issue you need to remove the schemas, which is of migration "}}