{"action":"created","issue":{"url":"https://api.github.com/repos/coral-erm/coral/issues/445","repository_url":"https://api.github.com/repos/coral-erm/coral","labels_url":"https://api.github.com/repos/coral-erm/coral/issues/445/labels{/name}","comments_url":"https://api.github.com/repos/coral-erm/coral/issues/445/comments","events_url":"https://api.github.com/repos/coral-erm/coral/issues/445/events","html_url":"https://github.com/coral-erm/coral/issues/445","id":335575912,"node_id":"MDU6SXNzdWUzMzU1NzU5MTI=","number":445,"title":"GROUP BY clause is incompatible with sql_mode=only_full_group_by","user":{"login":"ubun2Junky","id":6493500,"node_id":"MDQ6VXNlcjY0OTM1MDA=","avatar_url":"https://avatars1.githubusercontent.com/u/6493500?v=4","gravatar_id":"","url":"https://api.github.com/users/ubun2Junky","html_url":"https://github.com/ubun2Junky","followers_url":"https://api.github.com/users/ubun2Junky/followers","following_url":"https://api.github.com/users/ubun2Junky/following{/other_user}","gists_url":"https://api.github.com/users/ubun2Junky/gists{/gist_id}","starred_url":"https://api.github.com/users/ubun2Junky/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ubun2Junky/subscriptions","organizations_url":"https://api.github.com/users/ubun2Junky/orgs","repos_url":"https://api.github.com/users/ubun2Junky/repos","events_url":"https://api.github.com/users/ubun2Junky/events{/privacy}","received_events_url":"https://api.github.com/users/ubun2Junky/received_events","type":"User","site_admin":false},"labels":[{"id":338834592,"node_id":"MDU6TGFiZWwzMzg4MzQ1OTI=","url":"https://api.github.com/repos/coral-erm/coral/labels/bug","name":"bug","color":"b60205","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-06-25T21:32:40Z","updated_at":"2018-07-02T09:52:27Z","closed_at":null,"author_association":"NONE","body":"Coral: 3.0\r\nPHP: 7.0\r\nMySQL: 5.7\r\n\r\nInstalled fresh version of Coral on a docker container and I kept on getting the following error displayed on the Management module.  I also had similar errors on the Licensing, Organizations and Statistics Module:\r\n\r\n`Uncaught Exception: There was a problem with the database: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'coral_management.L.shortName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/html/management/admin/classes/common/DBService.php:55 `\r\n\r\nI did manage to remove the error messages by applying the following command on MySQL command line:\r\n`SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));`"},"comment":{"url":"https://api.github.com/repos/coral-erm/coral/issues/comments/401741648","html_url":"https://github.com/coral-erm/coral/issues/445#issuecomment-401741648","issue_url":"https://api.github.com/repos/coral-erm/coral/issues/445","id":401741648,"node_id":"MDEyOklzc3VlQ29tbWVudDQwMTc0MTY0OA==","user":{"login":"veggiematts","id":1679997,"node_id":"MDQ6VXNlcjE2Nzk5OTc=","avatar_url":"https://avatars1.githubusercontent.com/u/1679997?v=4","gravatar_id":"","url":"https://api.github.com/users/veggiematts","html_url":"https://github.com/veggiematts","followers_url":"https://api.github.com/users/veggiematts/followers","following_url":"https://api.github.com/users/veggiematts/following{/other_user}","gists_url":"https://api.github.com/users/veggiematts/gists{/gist_id}","starred_url":"https://api.github.com/users/veggiematts/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/veggiematts/subscriptions","organizations_url":"https://api.github.com/users/veggiematts/orgs","repos_url":"https://api.github.com/users/veggiematts/repos","events_url":"https://api.github.com/users/veggiematts/events{/privacy}","received_events_url":"https://api.github.com/users/veggiematts/received_events","type":"User","site_admin":false},"created_at":"2018-07-02T09:52:27Z","updated_at":"2018-07-02T09:52:27Z","author_association":"CONTRIBUTOR","body":"I can confirm it's also broken with MariaDB 10.0.34 when ONLY_FULL_GROUP_BY is enabled."}}
{"actor":{"display_login":"veggiematts"}}