{"action":"created","comment":{"url":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/comments/56675632","id":56675632,"diff_hunk":"@@ -5,10 +5,14 @@\n \n \n def get_prereg_reviewers():\n-    return MyUser.objects.filter(\n-        groups__name='prereg_group'\n-    ).annotate(\n-        fuller_name=Concat('first_name', Value(' '), 'last_name')\n-    ).values_list(\n-        'email', 'fuller_name'\n-    )\n+    # Note - fixes django.db.utils.OperationalError: no such table' error if ever one erases a db table and tries to remigrate\n+    try:\n+        return MyUser.objects.filter(\n+            groups__name='prereg_group'\n+        ).annotate(\n+            fuller_name=Concat('first_name', Value(' '), 'last_name')\n+        ).values_list(\n+            'email', 'fuller_name'\n+        )\n+    except Exception:","path":"admin/pre_reg/utils.py","position":20,"original_position":20,"commit_id":"efb51ffac31fe79a0ad508dded1764e3100bf8fd","original_commit_id":"efb51ffac31fe79a0ad508dded1764e3100bf8fd","user":{"login":"whit537","id":134455,"avatar_url":"https://avatars.githubusercontent.com/u/134455?v=3","gravatar_id":"","url":"https://api.github.com/users/whit537","html_url":"https://github.com/whit537","followers_url":"https://api.github.com/users/whit537/followers","following_url":"https://api.github.com/users/whit537/following{/other_user}","gists_url":"https://api.github.com/users/whit537/gists{/gist_id}","starred_url":"https://api.github.com/users/whit537/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/whit537/subscriptions","organizations_url":"https://api.github.com/users/whit537/orgs","repos_url":"https://api.github.com/users/whit537/repos","events_url":"https://api.github.com/users/whit537/events{/privacy}","received_events_url":"https://api.github.com/users/whit537/received_events","type":"User","site_admin":false},"body":"Even if this error handling is legitimate, bare `except`s are bad because they hide legitimate errors.","created_at":"2016-03-18T15:40:36Z","updated_at":"2016-03-18T15:40:36Z","html_url":"https://github.com/CenterForOpenScience/osf.io/pull/4992#discussion_r56675632","pull_request_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/4992","_links":{"self":{"href":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/comments/56675632"},"html":{"href":"https://github.com/CenterForOpenScience/osf.io/pull/4992#discussion_r56675632"},"pull_request":{"href":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/4992"}}},"pull_request":{"url":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/4992","id":58343251,"html_url":"https://github.com/CenterForOpenScience/osf.io/pull/4992","diff_url":"https://github.com/CenterForOpenScience/osf.io/pull/4992.diff","patch_url":"https://github.com/CenterForOpenScience/osf.io/pull/4992.patch","issue_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/issues/4992","number":4992,"state":"open","locked":false,"title":"User Registration and Admin Updates","user":{"login":"zkraime","id":11323460,"avatar_url":"https://avatars.githubusercontent.com/u/11323460?v=3","gravatar_id":"","url":"https://api.github.com/users/zkraime","html_url":"https://github.com/zkraime","followers_url":"https://api.github.com/users/zkraime/followers","following_url":"https://api.github.com/users/zkraime/following{/other_user}","gists_url":"https://api.github.com/users/zkraime/gists{/gist_id}","starred_url":"https://api.github.com/users/zkraime/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zkraime/subscriptions","organizations_url":"https://api.github.com/users/zkraime/orgs","repos_url":"https://api.github.com/users/zkraime/repos","events_url":"https://api.github.com/users/zkraime/events{/privacy}","received_events_url":"https://api.github.com/users/zkraime/received_events","type":"User","site_admin":false},"body":"originally: #4718 and https://github.com/CenterForOpenScience/osf.io/pull/4796\r\n","created_at":"2016-02-04T20:23:04Z","updated_at":"2016-03-18T15:40:36Z","closed_at":null,"merged_at":null,"merge_commit_sha":"1bfb67cef4732decc4ca3fc0d2368930ba10c281","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/4992/commits","review_comments_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/4992/comments","review_comment_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/comments{/number}","comments_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/issues/4992/comments","statuses_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/statuses/efb51ffac31fe79a0ad508dded1764e3100bf8fd","head":{"label":"zkraime:feature/admin/user_registration","ref":"feature/admin/user_registration","sha":"efb51ffac31fe79a0ad508dded1764e3100bf8fd","user":{"login":"zkraime","id":11323460,"avatar_url":"https://avatars.githubusercontent.com/u/11323460?v=3","gravatar_id":"","url":"https://api.github.com/users/zkraime","html_url":"https://github.com/zkraime","followers_url":"https://api.github.com/users/zkraime/followers","following_url":"https://api.github.com/users/zkraime/following{/other_user}","gists_url":"https://api.github.com/users/zkraime/gists{/gist_id}","starred_url":"https://api.github.com/users/zkraime/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zkraime/subscriptions","organizations_url":"https://api.github.com/users/zkraime/orgs","repos_url":"https://api.github.com/users/zkraime/repos","events_url":"https://api.github.com/users/zkraime/events{/privacy}","received_events_url":"https://api.github.com/users/zkraime/received_events","type":"User","site_admin":false},"repo":{"id":35900852,"name":"osf.io","full_name":"zkraime/osf.io","owner":{"login":"zkraime","id":11323460,"avatar_url":"https://avatars.githubusercontent.com/u/11323460?v=3","gravatar_id":"","url":"https://api.github.com/users/zkraime","html_url":"https://github.com/zkraime","followers_url":"https://api.github.com/users/zkraime/followers","following_url":"https://api.github.com/users/zkraime/following{/other_user}","gists_url":"https://api.github.com/users/zkraime/gists{/gist_id}","starred_url":"https://api.github.com/users/zkraime/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zkraime/subscriptions","organizations_url":"https://api.github.com/users/zkraime/orgs","repos_url":"https://api.github.com/users/zkraime/repos","events_url":"https://api.github.com/users/zkraime/events{/privacy}","received_events_url":"https://api.github.com/users/zkraime/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/zkraime/osf.io","description":"Facilitating Open Science","fork":true,"url":"https://api.github.com/repos/zkraime/osf.io","forks_url":"https://api.github.com/repos/zkraime/osf.io/forks","keys_url":"https://api.github.com/repos/zkraime/osf.io/keys{/key_id}","collaborators_url":"https://api.github.com/repos/zkraime/osf.io/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/zkraime/osf.io/teams","hooks_url":"https://api.github.com/repos/zkraime/osf.io/hooks","issue_events_url":"https://api.github.com/repos/zkraime/osf.io/issues/events{/number}","events_url":"https://api.github.com/repos/zkraime/osf.io/events","assignees_url":"https://api.github.com/repos/zkraime/osf.io/assignees{/user}","branches_url":"https://api.github.com/repos/zkraime/osf.io/branches{/branch}","tags_url":"https://api.github.com/repos/zkraime/osf.io/tags","blobs_url":"https://api.github.com/repos/zkraime/osf.io/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/zkraime/osf.io/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/zkraime/osf.io/git/refs{/sha}","trees_url":"https://api.github.com/repos/zkraime/osf.io/git/trees{/sha}","statuses_url":"https://api.github.com/repos/zkraime/osf.io/statuses/{sha}","languages_url":"https://api.github.com/repos/zkraime/osf.io/languages","stargazers_url":"https://api.github.com/repos/zkraime/osf.io/stargazers","contributors_url":"https://api.github.com/repos/zkraime/osf.io/contributors","subscribers_url":"https://api.github.com/repos/zkraime/osf.io/subscribers","subscription_url":"https://api.github.com/repos/zkraime/osf.io/subscription","commits_url":"https://api.github.com/repos/zkraime/osf.io/commits{/sha}","git_commits_url":"https://api.github.com/repos/zkraime/osf.io/git/commits{/sha}","comments_url":"https://api.github.com/repos/zkraime/osf.io/comments{/number}","issue_comment_url":"https://api.github.com/repos/zkraime/osf.io/issues/comments{/number}","contents_url":"https://api.github.com/repos/zkraime/osf.io/contents/{+path}","compare_url":"https://api.github.com/repos/zkraime/osf.io/compare/{base}...{head}","merges_url":"https://api.github.com/repos/zkraime/osf.io/merges","archive_url":"https://api.github.com/repos/zkraime/osf.io/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/zkraime/osf.io/downloads","issues_url":"https://api.github.com/repos/zkraime/osf.io/issues{/number}","pulls_url":"https://api.github.com/repos/zkraime/osf.io/pulls{/number}","milestones_url":"https://api.github.com/repos/zkraime/osf.io/milestones{/number}","notifications_url":"https://api.github.com/repos/zkraime/osf.io/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/zkraime/osf.io/labels{/name}","releases_url":"https://api.github.com/repos/zkraime/osf.io/releases{/id}","deployments_url":"https://api.github.com/repos/zkraime/osf.io/deployments","created_at":"2015-05-19T18:32:41Z","updated_at":"2015-05-19T18:32:45Z","pushed_at":"2016-03-15T03:46:00Z","git_url":"git://github.com/zkraime/osf.io.git","ssh_url":"git@github.com:zkraime/osf.io.git","clone_url":"https://github.com/zkraime/osf.io.git","svn_url":"https://github.com/zkraime/osf.io","homepage":"http://osf.io","size":121412,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"develop"}},"base":{"label":"CenterForOpenScience:develop","ref":"develop","sha":"219c0fce2123489ae21abbac4a7f0d2b4b583985","user":{"login":"CenterForOpenScience","id":3344584,"avatar_url":"https://avatars.githubusercontent.com/u/3344584?v=3","gravatar_id":"","url":"https://api.github.com/users/CenterForOpenScience","html_url":"https://github.com/CenterForOpenScience","followers_url":"https://api.github.com/users/CenterForOpenScience/followers","following_url":"https://api.github.com/users/CenterForOpenScience/following{/other_user}","gists_url":"https://api.github.com/users/CenterForOpenScience/gists{/gist_id}","starred_url":"https://api.github.com/users/CenterForOpenScience/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CenterForOpenScience/subscriptions","organizations_url":"https://api.github.com/users/CenterForOpenScience/orgs","repos_url":"https://api.github.com/users/CenterForOpenScience/repos","events_url":"https://api.github.com/users/CenterForOpenScience/events{/privacy}","received_events_url":"https://api.github.com/users/CenterForOpenScience/received_events","type":"Organization","site_admin":false},"repo":{"id":10199599,"name":"osf.io","full_name":"CenterForOpenScience/osf.io","owner":{"login":"CenterForOpenScience","id":3344584,"avatar_url":"https://avatars.githubusercontent.com/u/3344584?v=3","gravatar_id":"","url":"https://api.github.com/users/CenterForOpenScience","html_url":"https://github.com/CenterForOpenScience","followers_url":"https://api.github.com/users/CenterForOpenScience/followers","following_url":"https://api.github.com/users/CenterForOpenScience/following{/other_user}","gists_url":"https://api.github.com/users/CenterForOpenScience/gists{/gist_id}","starred_url":"https://api.github.com/users/CenterForOpenScience/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CenterForOpenScience/subscriptions","organizations_url":"https://api.github.com/users/CenterForOpenScience/orgs","repos_url":"https://api.github.com/users/CenterForOpenScience/repos","events_url":"https://api.github.com/users/CenterForOpenScience/events{/privacy}","received_events_url":"https://api.github.com/users/CenterForOpenScience/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/CenterForOpenScience/osf.io","description":"Facilitating Open Science","fork":false,"url":"https://api.github.com/repos/CenterForOpenScience/osf.io","forks_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/forks","keys_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/keys{/key_id}","collaborators_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/teams","hooks_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/hooks","issue_events_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/issues/events{/number}","events_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/events","assignees_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/assignees{/user}","branches_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/branches{/branch}","tags_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/tags","blobs_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/git/refs{/sha}","trees_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/git/trees{/sha}","statuses_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/statuses/{sha}","languages_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/languages","stargazers_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/stargazers","contributors_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/contributors","subscribers_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/subscribers","subscription_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/subscription","commits_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/commits{/sha}","git_commits_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/git/commits{/sha}","comments_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/comments{/number}","issue_comment_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/issues/comments{/number}","contents_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/contents/{+path}","compare_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/compare/{base}...{head}","merges_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/merges","archive_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/downloads","issues_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/issues{/number}","pulls_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls{/number}","milestones_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/milestones{/number}","notifications_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/labels{/name}","releases_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/releases{/id}","deployments_url":"https://api.github.com/repos/CenterForOpenScience/osf.io/deployments","created_at":"2013-05-21T15:53:37Z","updated_at":"2016-03-17T02:55:06Z","pushed_at":"2016-03-18T15:36:06Z","git_url":"git://github.com/CenterForOpenScience/osf.io.git","ssh_url":"git@github.com:CenterForOpenScience/osf.io.git","clone_url":"https://github.com/CenterForOpenScience/osf.io.git","svn_url":"https://github.com/CenterForOpenScience/osf.io","homepage":"http://osf.io","size":269613,"stargazers_count":202,"watchers_count":202,"language":"Python","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":158,"mirror_url":null,"open_issues_count":204,"forks":158,"open_issues":204,"watchers":202,"default_branch":"develop"}},"_links":{"self":{"href":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/4992"},"html":{"href":"https://github.com/CenterForOpenScience/osf.io/pull/4992"},"issue":{"href":"https://api.github.com/repos/CenterForOpenScience/osf.io/issues/4992"},"comments":{"href":"https://api.github.com/repos/CenterForOpenScience/osf.io/issues/4992/comments"},"review_comments":{"href":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/4992/comments"},"review_comment":{"href":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/CenterForOpenScience/osf.io/pulls/4992/commits"},"statuses":{"href":"https://api.github.com/repos/CenterForOpenScience/osf.io/statuses/efb51ffac31fe79a0ad508dded1764e3100bf8fd"}}}}