{"action":"created","issue":{"url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/issues/4201","labels_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/issues/4201/labels{/name}","comments_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/issues/4201/comments","events_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/issues/4201/events","html_url":"https://github.com/openmicroscopy/openmicroscopy/pull/4201","id":107875554,"number":4201,"title":"fix typo in 5.0 to 5.1 SQL upgrade character encoding error","user":{"login":"mtbc","id":2630707,"avatar_url":"https://avatars.githubusercontent.com/u/2630707?v=3","gravatar_id":"","url":"https://api.github.com/users/mtbc","html_url":"https://github.com/mtbc","followers_url":"https://api.github.com/users/mtbc/followers","following_url":"https://api.github.com/users/mtbc/following{/other_user}","gists_url":"https://api.github.com/users/mtbc/gists{/gist_id}","starred_url":"https://api.github.com/users/mtbc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mtbc/subscriptions","organizations_url":"https://api.github.com/users/mtbc/orgs","repos_url":"https://api.github.com/users/mtbc/repos","events_url":"https://api.github.com/users/mtbc/events{/privacy}","received_events_url":"https://api.github.com/users/mtbc/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/labels/develop","name":"develop","color":"02e10c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-09-23T08:56:43Z","updated_at":"2015-09-25T08:31:07Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/pulls/4201","html_url":"https://github.com/openmicroscopy/openmicroscopy/pull/4201","diff_url":"https://github.com/openmicroscopy/openmicroscopy/pull/4201.diff","patch_url":"https://github.com/openmicroscopy/openmicroscopy/pull/4201.patch"},"body":"Accidentally used .vm file quoting syntax. Now with a wrong DB character encoding, upgrade from 5.0 should give an appropriate error message.\r\n\r\n--no-rebase unless 5.1.5"},"comment":{"url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/issues/comments/143160295","html_url":"https://github.com/openmicroscopy/openmicroscopy/pull/4201#issuecomment-143160295","issue_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/issues/4201","id":143160295,"user":{"login":"rleigh-dundee","id":1528953,"avatar_url":"https://avatars.githubusercontent.com/u/1528953?v=3","gravatar_id":"","url":"https://api.github.com/users/rleigh-dundee","html_url":"https://github.com/rleigh-dundee","followers_url":"https://api.github.com/users/rleigh-dundee/followers","following_url":"https://api.github.com/users/rleigh-dundee/following{/other_user}","gists_url":"https://api.github.com/users/rleigh-dundee/gists{/gist_id}","starred_url":"https://api.github.com/users/rleigh-dundee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rleigh-dundee/subscriptions","organizations_url":"https://api.github.com/users/rleigh-dundee/orgs","repos_url":"https://api.github.com/users/rleigh-dundee/repos","events_url":"https://api.github.com/users/rleigh-dundee/events{/privacy}","received_events_url":"https://api.github.com/users/rleigh-dundee/received_events","type":"User","site_admin":false},"created_at":"2015-09-25T08:31:07Z","updated_at":"2015-09-25T08:31:07Z","body":"The change is correct so long as this is never used as a template.  It would be nice if the template files had a '.sql.in' or similar suffix to distinguish them from real sql.\r\n\r\nNote a second instance of the typo:\r\n\r\n```\r\n                RAISE EXCEPTION '%%', 'Directory('||OLD.id||')='||OLD.path||OLD.name||'/ is not empty!';\r\n```\r\n\r\nlater on in this file."}}