{"action":"created","issue":{"url":"https://api.github.com/repos/molgenis/molgenis/issues/4031","labels_url":"https://api.github.com/repos/molgenis/molgenis/issues/4031/labels{/name}","comments_url":"https://api.github.com/repos/molgenis/molgenis/issues/4031/comments","events_url":"https://api.github.com/repos/molgenis/molgenis/issues/4031/events","html_url":"https://github.com/molgenis/molgenis/pull/4031","id":113455875,"number":4031,"title":"[master] Fix #4002 Model DAS-MODELv1.6.xlsx import error","user":{"login":"dennishendriksen","id":2477186,"avatar_url":"https://avatars.githubusercontent.com/u/2477186?v=3","gravatar_id":"","url":"https://api.github.com/users/dennishendriksen","html_url":"https://github.com/dennishendriksen","followers_url":"https://api.github.com/users/dennishendriksen/followers","following_url":"https://api.github.com/users/dennishendriksen/following{/other_user}","gists_url":"https://api.github.com/users/dennishendriksen/gists{/gist_id}","starred_url":"https://api.github.com/users/dennishendriksen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dennishendriksen/subscriptions","organizations_url":"https://api.github.com/users/dennishendriksen/orgs","repos_url":"https://api.github.com/users/dennishendriksen/repos","events_url":"https://api.github.com/users/dennishendriksen/events{/privacy}","received_events_url":"https://api.github.com/users/dennishendriksen/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"dennishendriksen","id":2477186,"avatar_url":"https://avatars.githubusercontent.com/u/2477186?v=3","gravatar_id":"","url":"https://api.github.com/users/dennishendriksen","html_url":"https://github.com/dennishendriksen","followers_url":"https://api.github.com/users/dennishendriksen/followers","following_url":"https://api.github.com/users/dennishendriksen/following{/other_user}","gists_url":"https://api.github.com/users/dennishendriksen/gists{/gist_id}","starred_url":"https://api.github.com/users/dennishendriksen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dennishendriksen/subscriptions","organizations_url":"https://api.github.com/users/dennishendriksen/orgs","repos_url":"https://api.github.com/users/dennishendriksen/repos","events_url":"https://api.github.com/users/dennishendriksen/events{/privacy}","received_events_url":"https://api.github.com/users/dennishendriksen/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2015-10-26T21:32:53Z","updated_at":"2015-10-27T09:53:51Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/molgenis/molgenis/pulls/4031","html_url":"https://github.com/molgenis/molgenis/pull/4031","diff_url":"https://github.com/molgenis/molgenis/pull/4031.diff","patch_url":"https://github.com/molgenis/molgenis/pull/4031.patch"},"body":"Results in another import error:\r\n```org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [ CREATE TABLE `das_sources_version_coordinates`(`order` INT,`uri` TEXT NOT NULL, `coordinates` VARCHAR(255) NOT NULL, FOREIGN KEY (`uri`) REFERENCES `das_sources_version`(`uri`) ON DELETE CASCADE, FOREIGN KEY (`coordinates`) REFERENCES `das_sources_coordinates`(`uri`) ON DELETE CASCADE) ENGINE=InnoDB;]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'uri' used in key specification without a key length```"},"comment":{"url":"https://api.github.com/repos/molgenis/molgenis/issues/comments/151438904","html_url":"https://github.com/molgenis/molgenis/pull/4031#issuecomment-151438904","issue_url":"https://api.github.com/repos/molgenis/molgenis/issues/4031","id":151438904,"user":{"login":"dennishendriksen","id":2477186,"avatar_url":"https://avatars.githubusercontent.com/u/2477186?v=3","gravatar_id":"","url":"https://api.github.com/users/dennishendriksen","html_url":"https://github.com/dennishendriksen","followers_url":"https://api.github.com/users/dennishendriksen/followers","following_url":"https://api.github.com/users/dennishendriksen/following{/other_user}","gists_url":"https://api.github.com/users/dennishendriksen/gists{/gist_id}","starred_url":"https://api.github.com/users/dennishendriksen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dennishendriksen/subscriptions","organizations_url":"https://api.github.com/users/dennishendriksen/orgs","repos_url":"https://api.github.com/users/dennishendriksen/repos","events_url":"https://api.github.com/users/dennishendriksen/events{/privacy}","received_events_url":"https://api.github.com/users/dennishendriksen/received_events","type":"User","site_admin":false},"created_at":"2015-10-27T09:53:51Z","updated_at":"2015-10-27T09:53:51Z","body":"Yes, that is exactly the error described in the PR text. This PR fixes the import error described in #4002."}}