{"action":"created","comment":{"url":"https://api.github.com/repos/aces/Loris/pulls/comments/201862931","pull_request_review_id":136449425,"id":201862931,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIwMTg2MjkzMQ==","diff_hunk":"@@ -161,5 +163,6 @@ UPDATE ConfigSettings\n INSERT INTO ConfigSettings (Name, Description, Visible, AllowMultiple, DataType, Parent, Label, OrderNumber) SELECT 'ComputeDeepQC', 'Determines whether a call is made from LORIS-MRI to the DeepQC app for automatic QC prediction', 1, 0, 'boolean', ID, 'Compute automatic QC', 18 FROM ConfigSettings WHERE Name=\"imaging_pipeline\";\n \n -- default imaging_pipeline settings\n-INSERT INTO Config (ConfigID, Value) SELECT ID, 0 FROM ConfigSettings cs WHERE cs.Name=\"ComputeDeepQC\";INSERT INTO LorisMenuPermissions (MenuID, PermID)\n+INSERT INTO Config (ConfigID, Value) SELECT ID, 0 FROM ConfigSettings cs WHERE cs.Name=\"ComputeDeepQC\";","path":"SQL/Release_patches/19.1_To_20.0_upgrade.sql","position":25,"original_position":25,"commit_id":"c1bfa633750cd8850927f093c4d7e603dc0172cd","original_commit_id":"c1bfa633750cd8850927f093c4d7e603dc0172cd","user":{"login":"ridz1208","id":15268287,"node_id":"MDQ6VXNlcjE1MjY4Mjg3","avatar_url":"https://avatars3.githubusercontent.com/u/15268287?v=4","gravatar_id":"","url":"https://api.github.com/users/ridz1208","html_url":"https://github.com/ridz1208","followers_url":"https://api.github.com/users/ridz1208/followers","following_url":"https://api.github.com/users/ridz1208/following{/other_user}","gists_url":"https://api.github.com/users/ridz1208/gists{/gist_id}","starred_url":"https://api.github.com/users/ridz1208/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ridz1208/subscriptions","organizations_url":"https://api.github.com/users/ridz1208/orgs","repos_url":"https://api.github.com/users/ridz1208/repos","events_url":"https://api.github.com/users/ridz1208/events{/privacy}","received_events_url":"https://api.github.com/users/ridz1208/received_events","type":"User","site_admin":false},"body":"next time I do a concat I'll add it manually, this is very difficult to review","created_at":"2018-07-11T22:47:08Z","updated_at":"2018-07-11T22:47:08Z","html_url":"https://github.com/aces/Loris/pull/3801#discussion_r201862931","pull_request_url":"https://api.github.com/repos/aces/Loris/pulls/3801","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/aces/Loris/pulls/comments/201862931"},"html":{"href":"https://github.com/aces/Loris/pull/3801#discussion_r201862931"},"pull_request":{"href":"https://api.github.com/repos/aces/Loris/pulls/3801"}},"in_reply_to_id":201712516},"pull_request":{"url":"https://api.github.com/repos/aces/Loris/pulls/3801","id":200538817,"node_id":"MDExOlB1bGxSZXF1ZXN0MjAwNTM4ODE3","html_url":"https://github.com/aces/Loris/pull/3801","diff_url":"https://github.com/aces/Loris/pull/3801.diff","patch_url":"https://github.com/aces/Loris/pull/3801.patch","issue_url":"https://api.github.com/repos/aces/Loris/issues/3801","number":3801,"state":"closed","locked":false,"title":"[Release Patch] fix SQL glitches","user":{"login":"ridz1208","id":15268287,"node_id":"MDQ6VXNlcjE1MjY4Mjg3","avatar_url":"https://avatars3.githubusercontent.com/u/15268287?v=4","gravatar_id":"","url":"https://api.github.com/users/ridz1208","html_url":"https://github.com/ridz1208","followers_url":"https://api.github.com/users/ridz1208/followers","following_url":"https://api.github.com/users/ridz1208/following{/other_user}","gists_url":"https://api.github.com/users/ridz1208/gists{/gist_id}","starred_url":"https://api.github.com/users/ridz1208/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ridz1208/subscriptions","organizations_url":"https://api.github.com/users/ridz1208/orgs","repos_url":"https://api.github.com/users/ridz1208/repos","events_url":"https://api.github.com/users/ridz1208/events{/privacy}","received_events_url":"https://api.github.com/users/ridz1208/received_events","type":"User","site_admin":false},"body":"This fixes minor issues in the release patch:\r\n\r\n- missing semi-colon after command\r\n- added `IGNORE` to an isert (value seems to exist already for CCNA)\r\n","created_at":"2018-07-10T22:17:12Z","updated_at":"2018-07-11T22:47:08Z","closed_at":"2018-07-11T14:33:33Z","merged_at":"2018-07-11T14:33:33Z","merge_commit_sha":"0569f2eb8739840ccfd9a29b1ad86b322494c403","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[{"id":152305414,"node_id":"MDU6TGFiZWwxNTIzMDU0MTQ=","url":"https://api.github.com/repos/aces/Loris/labels/Bug%20Fix","name":"Bug Fix","color":"f7c6c7","default":false},{"id":658868975,"node_id":"MDU6TGFiZWw2NTg4Njg5NzU=","url":"https://api.github.com/repos/aces/Loris/labels/Critical%20to%20release","name":"Critical to release","color":"d93f0b","default":false},{"id":153844577,"node_id":"MDU6TGFiZWwxNTM4NDQ1Nzc=","url":"https://api.github.com/repos/aces/Loris/labels/SQL","name":"SQL","color":"bfe5bf","default":false}],"milestone":{"url":"https://api.github.com/repos/aces/Loris/milestones/21","html_url":"https://github.com/aces/Loris/milestone/21","labels_url":"https://api.github.com/repos/aces/Loris/milestones/21/labels","id":2855054,"node_id":"MDk6TWlsZXN0b25lMjg1NTA1NA==","number":21,"title":"20.0.0","description":"","creator":{"login":"ridz1208","id":15268287,"node_id":"MDQ6VXNlcjE1MjY4Mjg3","avatar_url":"https://avatars3.githubusercontent.com/u/15268287?v=4","gravatar_id":"","url":"https://api.github.com/users/ridz1208","html_url":"https://github.com/ridz1208","followers_url":"https://api.github.com/users/ridz1208/followers","following_url":"https://api.github.com/users/ridz1208/following{/other_user}","gists_url":"https://api.github.com/users/ridz1208/gists{/gist_id}","starred_url":"https://api.github.com/users/ridz1208/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ridz1208/subscriptions","organizations_url":"https://api.github.com/users/ridz1208/orgs","repos_url":"https://api.github.com/users/ridz1208/repos","events_url":"https://api.github.com/users/ridz1208/events{/privacy}","received_events_url":"https://api.github.com/users/ridz1208/received_events","type":"User","site_admin":false},"open_issues":17,"closed_issues":165,"state":"open","created_at":"2017-10-20T19:10:53Z","updated_at":"2018-07-11T19:55:11Z","due_on":null,"closed_at":null},"commits_url":"https://api.github.com/repos/aces/Loris/pulls/3801/commits","review_comments_url":"https://api.github.com/repos/aces/Loris/pulls/3801/comments","review_comment_url":"https://api.github.com/repos/aces/Loris/pulls/comments{/number}","comments_url":"https://api.github.com/repos/aces/Loris/issues/3801/comments","statuses_url":"https://api.github.com/repos/aces/Loris/statuses/c1bfa633750cd8850927f093c4d7e603dc0172cd","head":{"label":"ridz1208:2018_07_10_SQL_bugfix","ref":"2018_07_10_SQL_bugfix","sha":"c1bfa633750cd8850927f093c4d7e603dc0172cd","user":{"login":"ridz1208","id":15268287,"node_id":"MDQ6VXNlcjE1MjY4Mjg3","avatar_url":"https://avatars3.githubusercontent.com/u/15268287?v=4","gravatar_id":"","url":"https://api.github.com/users/ridz1208","html_url":"https://github.com/ridz1208","followers_url":"https://api.github.com/users/ridz1208/followers","following_url":"https://api.github.com/users/ridz1208/following{/other_user}","gists_url":"https://api.github.com/users/ridz1208/gists{/gist_id}","starred_url":"https://api.github.com/users/ridz1208/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ridz1208/subscriptions","organizations_url":"https://api.github.com/users/ridz1208/orgs","repos_url":"https://api.github.com/users/ridz1208/repos","events_url":"https://api.github.com/users/ridz1208/events{/privacy}","received_events_url":"https://api.github.com/users/ridz1208/received_events","type":"User","site_admin":false},"repo":{"id":50528288,"node_id":"MDEwOlJlcG9zaXRvcnk1MDUyODI4OA==","name":"Loris","full_name":"ridz1208/Loris","owner":{"login":"ridz1208","id":15268287,"node_id":"MDQ6VXNlcjE1MjY4Mjg3","avatar_url":"https://avatars3.githubusercontent.com/u/15268287?v=4","gravatar_id":"","url":"https://api.github.com/users/ridz1208","html_url":"https://github.com/ridz1208","followers_url":"https://api.github.com/users/ridz1208/followers","following_url":"https://api.github.com/users/ridz1208/following{/other_user}","gists_url":"https://api.github.com/users/ridz1208/gists{/gist_id}","starred_url":"https://api.github.com/users/ridz1208/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ridz1208/subscriptions","organizations_url":"https://api.github.com/users/ridz1208/orgs","repos_url":"https://api.github.com/users/ridz1208/repos","events_url":"https://api.github.com/users/ridz1208/events{/privacy}","received_events_url":"https://api.github.com/users/ridz1208/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/ridz1208/Loris","description":"LORIS is a web-accessible database solution for longitudinal multi-site studies.","fork":true,"url":"https://api.github.com/repos/ridz1208/Loris","forks_url":"https://api.github.com/repos/ridz1208/Loris/forks","keys_url":"https://api.github.com/repos/ridz1208/Loris/keys{/key_id}","collaborators_url":"https://api.github.com/repos/ridz1208/Loris/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/ridz1208/Loris/teams","hooks_url":"https://api.github.com/repos/ridz1208/Loris/hooks","issue_events_url":"https://api.github.com/repos/ridz1208/Loris/issues/events{/number}","events_url":"https://api.github.com/repos/ridz1208/Loris/events","assignees_url":"https://api.github.com/repos/ridz1208/Loris/assignees{/user}","branches_url":"https://api.github.com/repos/ridz1208/Loris/branches{/branch}","tags_url":"https://api.github.com/repos/ridz1208/Loris/tags","blobs_url":"https://api.github.com/repos/ridz1208/Loris/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/ridz1208/Loris/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/ridz1208/Loris/git/refs{/sha}","trees_url":"https://api.github.com/repos/ridz1208/Loris/git/trees{/sha}","statuses_url":"https://api.github.com/repos/ridz1208/Loris/statuses/{sha}","languages_url":"https://api.github.com/repos/ridz1208/Loris/languages","stargazers_url":"https://api.github.com/repos/ridz1208/Loris/stargazers","contributors_url":"https://api.github.com/repos/ridz1208/Loris/contributors","subscribers_url":"https://api.github.com/repos/ridz1208/Loris/subscribers","subscription_url":"https://api.github.com/repos/ridz1208/Loris/subscription","commits_url":"https://api.github.com/repos/ridz1208/Loris/commits{/sha}","git_commits_url":"https://api.github.com/repos/ridz1208/Loris/git/commits{/sha}","comments_url":"https://api.github.com/repos/ridz1208/Loris/comments{/number}","issue_comment_url":"https://api.github.com/repos/ridz1208/Loris/issues/comments{/number}","contents_url":"https://api.github.com/repos/ridz1208/Loris/contents/{+path}","compare_url":"https://api.github.com/repos/ridz1208/Loris/compare/{base}...{head}","merges_url":"https://api.github.com/repos/ridz1208/Loris/merges","archive_url":"https://api.github.com/repos/ridz1208/Loris/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/ridz1208/Loris/downloads","issues_url":"https://api.github.com/repos/ridz1208/Loris/issues{/number}","pulls_url":"https://api.github.com/repos/ridz1208/Loris/pulls{/number}","milestones_url":"https://api.github.com/repos/ridz1208/Loris/milestones{/number}","notifications_url":"https://api.github.com/repos/ridz1208/Loris/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/ridz1208/Loris/labels{/name}","releases_url":"https://api.github.com/repos/ridz1208/Loris/releases{/id}","deployments_url":"https://api.github.com/repos/ridz1208/Loris/deployments","created_at":"2016-01-27T18:25:19Z","updated_at":"2016-01-27T18:25:22Z","pushed_at":"2018-07-11T22:45:14Z","git_url":"git://github.com/ridz1208/Loris.git","ssh_url":"git@github.com:ridz1208/Loris.git","clone_url":"https://github.com/ridz1208/Loris.git","svn_url":"https://github.com/ridz1208/Loris","homepage":"","size":78923,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":4,"license":{"key":"gpl-3.0","name":"GNU General Public License v3.0","spdx_id":"GPL-3.0","url":"https://api.github.com/licenses/gpl-3.0","node_id":"MDc6TGljZW5zZTk="},"forks":0,"open_issues":4,"watchers":0,"default_branch":"bugfix"}},"base":{"label":"aces:20.0-release","ref":"20.0-release","sha":"5a3d049cdbada90566a40811d23188cae020a745","user":{"login":"aces","id":472868,"node_id":"MDEyOk9yZ2FuaXphdGlvbjQ3Mjg2OA==","avatar_url":"https://avatars2.githubusercontent.com/u/472868?v=4","gravatar_id":"","url":"https://api.github.com/users/aces","html_url":"https://github.com/aces","followers_url":"https://api.github.com/users/aces/followers","following_url":"https://api.github.com/users/aces/following{/other_user}","gists_url":"https://api.github.com/users/aces/gists{/gist_id}","starred_url":"https://api.github.com/users/aces/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aces/subscriptions","organizations_url":"https://api.github.com/users/aces/orgs","repos_url":"https://api.github.com/users/aces/repos","events_url":"https://api.github.com/users/aces/events{/privacy}","received_events_url":"https://api.github.com/users/aces/received_events","type":"Organization","site_admin":false},"repo":{"id":1125630,"node_id":"MDEwOlJlcG9zaXRvcnkxMTI1NjMw","name":"Loris","full_name":"aces/Loris","owner":{"login":"aces","id":472868,"node_id":"MDEyOk9yZ2FuaXphdGlvbjQ3Mjg2OA==","avatar_url":"https://avatars2.githubusercontent.com/u/472868?v=4","gravatar_id":"","url":"https://api.github.com/users/aces","html_url":"https://github.com/aces","followers_url":"https://api.github.com/users/aces/followers","following_url":"https://api.github.com/users/aces/following{/other_user}","gists_url":"https://api.github.com/users/aces/gists{/gist_id}","starred_url":"https://api.github.com/users/aces/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aces/subscriptions","organizations_url":"https://api.github.com/users/aces/orgs","repos_url":"https://api.github.com/users/aces/repos","events_url":"https://api.github.com/users/aces/events{/privacy}","received_events_url":"https://api.github.com/users/aces/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/aces/Loris","description":"LORIS is a web-accessible database solution for longitudinal multi-site studies.","fork":false,"url":"https://api.github.com/repos/aces/Loris","forks_url":"https://api.github.com/repos/aces/Loris/forks","keys_url":"https://api.github.com/repos/aces/Loris/keys{/key_id}","collaborators_url":"https://api.github.com/repos/aces/Loris/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/aces/Loris/teams","hooks_url":"https://api.github.com/repos/aces/Loris/hooks","issue_events_url":"https://api.github.com/repos/aces/Loris/issues/events{/number}","events_url":"https://api.github.com/repos/aces/Loris/events","assignees_url":"https://api.github.com/repos/aces/Loris/assignees{/user}","branches_url":"https://api.github.com/repos/aces/Loris/branches{/branch}","tags_url":"https://api.github.com/repos/aces/Loris/tags","blobs_url":"https://api.github.com/repos/aces/Loris/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/aces/Loris/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/aces/Loris/git/refs{/sha}","trees_url":"https://api.github.com/repos/aces/Loris/git/trees{/sha}","statuses_url":"https://api.github.com/repos/aces/Loris/statuses/{sha}","languages_url":"https://api.github.com/repos/aces/Loris/languages","stargazers_url":"https://api.github.com/repos/aces/Loris/stargazers","contributors_url":"https://api.github.com/repos/aces/Loris/contributors","subscribers_url":"https://api.github.com/repos/aces/Loris/subscribers","subscription_url":"https://api.github.com/repos/aces/Loris/subscription","commits_url":"https://api.github.com/repos/aces/Loris/commits{/sha}","git_commits_url":"https://api.github.com/repos/aces/Loris/git/commits{/sha}","comments_url":"https://api.github.com/repos/aces/Loris/comments{/number}","issue_comment_url":"https://api.github.com/repos/aces/Loris/issues/comments{/number}","contents_url":"https://api.github.com/repos/aces/Loris/contents/{+path}","compare_url":"https://api.github.com/repos/aces/Loris/compare/{base}...{head}","merges_url":"https://api.github.com/repos/aces/Loris/merges","archive_url":"https://api.github.com/repos/aces/Loris/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/aces/Loris/downloads","issues_url":"https://api.github.com/repos/aces/Loris/issues{/number}","pulls_url":"https://api.github.com/repos/aces/Loris/pulls{/number}","milestones_url":"https://api.github.com/repos/aces/Loris/milestones{/number}","notifications_url":"https://api.github.com/repos/aces/Loris/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/aces/Loris/labels{/name}","releases_url":"https://api.github.com/repos/aces/Loris/releases{/id}","deployments_url":"https://api.github.com/repos/aces/Loris/deployments","created_at":"2010-11-30T14:57:57Z","updated_at":"2018-07-11T02:47:42Z","pushed_at":"2018-07-11T22:45:15Z","git_url":"git://github.com/aces/Loris.git","ssh_url":"git@github.com:aces/Loris.git","clone_url":"https://github.com/aces/Loris.git","svn_url":"https://github.com/aces/Loris","homepage":"","size":76191,"stargazers_count":64,"watchers_count":64,"language":"PHP","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":91,"mirror_url":null,"archived":false,"open_issues_count":91,"license":{"key":"gpl-3.0","name":"GNU General Public License v3.0","spdx_id":"GPL-3.0","url":"https://api.github.com/licenses/gpl-3.0","node_id":"MDc6TGljZW5zZTk="},"forks":91,"open_issues":91,"watchers":64,"default_branch":"minor"}},"_links":{"self":{"href":"https://api.github.com/repos/aces/Loris/pulls/3801"},"html":{"href":"https://github.com/aces/Loris/pull/3801"},"issue":{"href":"https://api.github.com/repos/aces/Loris/issues/3801"},"comments":{"href":"https://api.github.com/repos/aces/Loris/issues/3801/comments"},"review_comments":{"href":"https://api.github.com/repos/aces/Loris/pulls/3801/comments"},"review_comment":{"href":"https://api.github.com/repos/aces/Loris/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/aces/Loris/pulls/3801/commits"},"statuses":{"href":"https://api.github.com/repos/aces/Loris/statuses/c1bfa633750cd8850927f093c4d7e603dc0172cd"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"ridz1208"}}