{"action":"created","issue":{"url":"https://api.github.com/repos/lagotto/lagotto/issues/583","repository_url":"https://api.github.com/repos/lagotto/lagotto","labels_url":"https://api.github.com/repos/lagotto/lagotto/issues/583/labels{/name}","comments_url":"https://api.github.com/repos/lagotto/lagotto/issues/583/comments","events_url":"https://api.github.com/repos/lagotto/lagotto/issues/583/events","html_url":"https://github.com/lagotto/lagotto/issues/583","id":154836624,"number":583,"title":"ActiveRecord::StatementInvalid in notifications#index","user":{"login":"mfenner","id":23151,"avatar_url":"https://avatars.githubusercontent.com/u/23151?v=3","gravatar_id":"","url":"https://api.github.com/users/mfenner","html_url":"https://github.com/mfenner","followers_url":"https://api.github.com/users/mfenner/followers","following_url":"https://api.github.com/users/mfenner/following{/other_user}","gists_url":"https://api.github.com/users/mfenner/gists{/gist_id}","starred_url":"https://api.github.com/users/mfenner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mfenner/subscriptions","organizations_url":"https://api.github.com/users/mfenner/orgs","repos_url":"https://api.github.com/users/mfenner/repos","events_url":"https://api.github.com/users/mfenner/events{/privacy}","received_events_url":"https://api.github.com/users/mfenner/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/lagotto/lagotto/labels/bug","name":"bug","color":"eb6420"},{"url":"https://api.github.com/repos/lagotto/lagotto/labels/duplicate","name":"duplicate","color":"cccccc"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-05-14T05:56:33Z","updated_at":"2016-05-16T22:56:53Z","closed_at":null,"body":"## Error in Event Data Backend\n\n**ActiveRecord::StatementInvalid** in **notifications#index**\nMysql2::Error: Column 'source_id' in field list is ambiguous: SELECT COUNT(DISTINCT `notifications`.`id`) AS count_id, source_id AS source_id FROM `notifications` LEFT OUTER JOIN `sources` ON `sources`.`id` = `notifications`.`source_id` LEFT OUTER JOIN `works` ON `works`.`id` = `notifications`.`work_id` LEFT OUTER JOIN `deposits` ON `deposits`.`id` = `notifications`.`deposit_id` WHERE (unresolved = 1) AND (sources.name = 'datacite_search_link') AND (`notifications`.`source_id` IS NOT NULL) GROUP BY `notifications`.`source_id`  ORDER BY notifications.created_at DESC\n\n[View on Bugsnag](https://bugsnag.com/datacite/event-data-backend/errors/5736bc7abe3f29e6a6c30b50?event_id=5736bc7ad54e5c24669f9dee)\n\n## Stacktrace\n\n    app/controllers/notifications_controller.rb:97 - load_index\n    app/controllers/notifications_controller.rb:7 - index\n\n[View full stacktrace](https://bugsnag.com/datacite/event-data-backend/errors/5736bc7abe3f29e6a6c30b50?event_id=5736bc7ad54e5c24669f9dee)"},"comment":{"url":"https://api.github.com/repos/lagotto/lagotto/issues/comments/219573024","html_url":"https://github.com/lagotto/lagotto/issues/583#issuecomment-219573024","issue_url":"https://api.github.com/repos/lagotto/lagotto/issues/583","id":219573024,"user":{"login":"mfenner","id":23151,"avatar_url":"https://avatars.githubusercontent.com/u/23151?v=3","gravatar_id":"","url":"https://api.github.com/users/mfenner","html_url":"https://github.com/mfenner","followers_url":"https://api.github.com/users/mfenner/followers","following_url":"https://api.github.com/users/mfenner/following{/other_user}","gists_url":"https://api.github.com/users/mfenner/gists{/gist_id}","starred_url":"https://api.github.com/users/mfenner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mfenner/subscriptions","organizations_url":"https://api.github.com/users/mfenner/orgs","repos_url":"https://api.github.com/users/mfenner/repos","events_url":"https://api.github.com/users/mfenner/events{/privacy}","received_events_url":"https://api.github.com/users/mfenner/received_events","type":"User","site_admin":false},"created_at":"2016-05-16T22:56:53Z","updated_at":"2016-05-16T22:56:53Z","body":"An error linked to this issue has been reopened in Bugsnag\n[**ActiveRecord::StatementInvalid** in **notifications#index**](https://bugsnag.com/datacite/event-data-backend/errors/5736bc7abe3f29e6a6c30b50?event_id=573a503571604dce67ab7c78)"}}