{"action":"created","issue":{"url":"https://api.github.com/repos/weecology/retriever/issues/505","repository_url":"https://api.github.com/repos/weecology/retriever","labels_url":"https://api.github.com/repos/weecology/retriever/issues/505/labels{/name}","comments_url":"https://api.github.com/repos/weecology/retriever/issues/505/comments","events_url":"https://api.github.com/repos/weecology/retriever/issues/505/events","html_url":"https://github.com/weecology/retriever/issues/505","id":158573406,"number":505,"title":"Can't install AmnioteLH dataset to MySQL","user":{"login":"goelakash","id":6972804,"avatar_url":"https://avatars.githubusercontent.com/u/6972804?v=3","gravatar_id":"","url":"https://api.github.com/users/goelakash","html_url":"https://github.com/goelakash","followers_url":"https://api.github.com/users/goelakash/followers","following_url":"https://api.github.com/users/goelakash/following{/other_user}","gists_url":"https://api.github.com/users/goelakash/gists{/gist_id}","starred_url":"https://api.github.com/users/goelakash/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/goelakash/subscriptions","organizations_url":"https://api.github.com/users/goelakash/orgs","repos_url":"https://api.github.com/users/goelakash/repos","events_url":"https://api.github.com/users/goelakash/events{/privacy}","received_events_url":"https://api.github.com/users/goelakash/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-06-05T20:40:49Z","updated_at":"2016-06-06T14:41:43Z","closed_at":null,"body":"Here's the output:\r\n\r\n```\r\nretriever install mysql Amniote -u travis -d testdb\r\n=> Installing Amniote life History database\r\nCreating database testdb...\r\nCreating table testdb.main...\r\nINSERT INTO testdb.main (class, ordered, family, genus, species, subspecies, common_name, trait, trait_value) VALUES ('Aves', 'Accipitriformes', 'Accipitridae', 'Accipiter', 'albogularis', null, 'Pied Goshawk', 'litter_or_clutch_size_n', null);\r\n(1406, u\"Data too long for column 'trait' at row 1\")\r\nDone!\r\n```\r\nThe table `main` for this script is also empty in MySQL:\r\n```\r\nmysql> use testdb\r\nReading table information for completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nDatabase changed\r\nmysql> show tables\r\n    -> ;\r\n+------------------+\r\n| Tables_in_testdb |\r\n+------------------+\r\n| main             |\r\n+------------------+\r\n1 row in set (0.00 sec)\r\n\r\nmysql> select * from main;\r\nEmpty set (0.00 sec)\r\n```"},"comment":{"url":"https://api.github.com/repos/weecology/retriever/issues/comments/223979572","html_url":"https://github.com/weecology/retriever/issues/505#issuecomment-223979572","issue_url":"https://api.github.com/repos/weecology/retriever/issues/505","id":223979572,"user":{"login":"ethanwhite","id":744427,"avatar_url":"https://avatars.githubusercontent.com/u/744427?v=3","gravatar_id":"","url":"https://api.github.com/users/ethanwhite","html_url":"https://github.com/ethanwhite","followers_url":"https://api.github.com/users/ethanwhite/followers","following_url":"https://api.github.com/users/ethanwhite/following{/other_user}","gists_url":"https://api.github.com/users/ethanwhite/gists{/gist_id}","starred_url":"https://api.github.com/users/ethanwhite/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ethanwhite/subscriptions","organizations_url":"https://api.github.com/users/ethanwhite/orgs","repos_url":"https://api.github.com/users/ethanwhite/repos","events_url":"https://api.github.com/users/ethanwhite/events{/privacy}","received_events_url":"https://api.github.com/users/ethanwhite/received_events","type":"User","site_admin":false},"created_at":"2016-06-06T14:41:43Z","updated_at":"2016-06-06T14:41:43Z","body":"I get the same result as @goelakash. Ubuntu 16.04, MySQL 5.7.12."}}
{"actor":{"display_login":"ethanwhite"}}