{"action":"created","issue":{"url":"https://api.github.com/repos/Canadensys/vascan/issues/39","repository_url":"https://api.github.com/repos/Canadensys/vascan","labels_url":"https://api.github.com/repos/Canadensys/vascan/issues/39/labels{/name}","comments_url":"https://api.github.com/repos/Canadensys/vascan/issues/39/comments","events_url":"https://api.github.com/repos/Canadensys/vascan/issues/39/events","html_url":"https://github.com/Canadensys/vascan/issues/39","id":383582782,"node_id":"MDU6SXNzdWUzODM1ODI3ODI=","number":39,"title":"Checklist builder: Download extensive list as a Darwin Core Archive failed","user":{"login":"JeGoi","id":13801368,"node_id":"MDQ6VXNlcjEzODAxMzY4","avatar_url":"https://avatars1.githubusercontent.com/u/13801368?v=4","gravatar_id":"","url":"https://api.github.com/users/JeGoi","html_url":"https://github.com/JeGoi","followers_url":"https://api.github.com/users/JeGoi/followers","following_url":"https://api.github.com/users/JeGoi/following{/other_user}","gists_url":"https://api.github.com/users/JeGoi/gists{/gist_id}","starred_url":"https://api.github.com/users/JeGoi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JeGoi/subscriptions","organizations_url":"https://api.github.com/users/JeGoi/orgs","repos_url":"https://api.github.com/users/JeGoi/repos","events_url":"https://api.github.com/users/JeGoi/events{/privacy}","received_events_url":"https://api.github.com/users/JeGoi/received_events","type":"User","site_admin":false},"labels":[{"id":39809706,"node_id":"MDU6TGFiZWwzOTgwOTcwNg==","url":"https://api.github.com/repos/Canadensys/vascan/labels/bug","name":"bug","color":"fc2929","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-11-22T15:32:42Z","updated_at":"2018-11-22T15:38:26Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"In Vascan front end, when you try to create a archive from Checklist builder \"Download extensive list as a Darwin Core Archive\", it fails and return an error.\r\nIn Vascan log:\r\n> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vascan_newprod.lookup.status' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"},"comment":{"url":"https://api.github.com/repos/Canadensys/vascan/issues/comments/441065582","html_url":"https://github.com/Canadensys/vascan/issues/39#issuecomment-441065582","issue_url":"https://api.github.com/repos/Canadensys/vascan/issues/39","id":441065582,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MTA2NTU4Mg==","user":{"login":"JeGoi","id":13801368,"node_id":"MDQ6VXNlcjEzODAxMzY4","avatar_url":"https://avatars1.githubusercontent.com/u/13801368?v=4","gravatar_id":"","url":"https://api.github.com/users/JeGoi","html_url":"https://github.com/JeGoi","followers_url":"https://api.github.com/users/JeGoi/followers","following_url":"https://api.github.com/users/JeGoi/following{/other_user}","gists_url":"https://api.github.com/users/JeGoi/gists{/gist_id}","starred_url":"https://api.github.com/users/JeGoi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JeGoi/subscriptions","organizations_url":"https://api.github.com/users/JeGoi/orgs","repos_url":"https://api.github.com/users/JeGoi/repos","events_url":"https://api.github.com/users/JeGoi/events{/privacy}","received_events_url":"https://api.github.com/users/JeGoi/received_events","type":"User","site_admin":false},"created_at":"2018-11-22T15:38:26Z","updated_at":"2018-11-22T15:38:26Z","author_association":"CONTRIBUTOR","body":"It is due to the passage from mysql 5.1 to 5.7\r\n@cgendreau has found : \"However, in MySQL prior to version 5.7 the default behaviour has been more forgiving because it will not complain and then arbitrarily choose any value!\"\r\nIt could be temporarely fixed with:\r\n`sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf`\r\nand add this line after [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\""}}
{"actor":{"display_login":"JeGoi"}}