{"action":"closed","issue":{"url":"https://api.github.com/repos/diaspora/diaspora/issues/7032","repository_url":"https://api.github.com/repos/diaspora/diaspora","labels_url":"https://api.github.com/repos/diaspora/diaspora/issues/7032/labels{/name}","comments_url":"https://api.github.com/repos/diaspora/diaspora/issues/7032/comments","events_url":"https://api.github.com/repos/diaspora/diaspora/issues/7032/events","html_url":"https://github.com/diaspora/diaspora/issues/7032","id":173461507,"number":7032,"title":"share visibilties migration not working correctly ","user":{"login":"Zauberstuhl","id":652428,"avatar_url":"https://avatars.githubusercontent.com/u/652428?v=3","gravatar_id":"","url":"https://api.github.com/users/Zauberstuhl","html_url":"https://github.com/Zauberstuhl","followers_url":"https://api.github.com/users/Zauberstuhl/followers","following_url":"https://api.github.com/users/Zauberstuhl/following{/other_user}","gists_url":"https://api.github.com/users/Zauberstuhl/gists{/gist_id}","starred_url":"https://api.github.com/users/Zauberstuhl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Zauberstuhl/subscriptions","organizations_url":"https://api.github.com/users/Zauberstuhl/orgs","repos_url":"https://api.github.com/users/Zauberstuhl/repos","events_url":"https://api.github.com/users/Zauberstuhl/events{/privacy}","received_events_url":"https://api.github.com/users/Zauberstuhl/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/diaspora/diaspora/labels/bug","name":"bug","color":"ff0000"},{"url":"https://api.github.com/repos/diaspora/diaspora/labels/data%20issue","name":"data issue","color":"02d7e1"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/diaspora/diaspora/milestones/27","html_url":"https://github.com/diaspora/diaspora/milestones/0.6.1.0","labels_url":"https://api.github.com/repos/diaspora/diaspora/milestones/27/labels","id":1953864,"number":27,"title":"0.6.1.0","description":"","creator":{"login":"denschub","id":344777,"avatar_url":"https://avatars.githubusercontent.com/u/344777?v=3","gravatar_id":"","url":"https://api.github.com/users/denschub","html_url":"https://github.com/denschub","followers_url":"https://api.github.com/users/denschub/followers","following_url":"https://api.github.com/users/denschub/following{/other_user}","gists_url":"https://api.github.com/users/denschub/gists{/gist_id}","starred_url":"https://api.github.com/users/denschub/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/denschub/subscriptions","organizations_url":"https://api.github.com/users/denschub/orgs","repos_url":"https://api.github.com/users/denschub/repos","events_url":"https://api.github.com/users/denschub/events{/privacy}","received_events_url":"https://api.github.com/users/denschub/received_events","type":"User","site_admin":false},"open_issues":7,"closed_issues":4,"state":"open","created_at":"2016-08-21T22:13:37Z","updated_at":"2016-09-01T20:52:52Z","due_on":"2016-10-23T00:00:00Z","closed_at":null},"comments":3,"created_at":"2016-08-26T14:06:59Z","updated_at":"2016-09-01T20:52:52Z","closed_at":"2016-09-01T20:52:52Z","body":"```\r\n--- a/db/migrate/20160225232049_link_share_visibilities_with_user.rb\r\n+++ b/db/migrate/20160225232049_link_share_visibilities_with_user.rb\r\n\r\n[...]\r\n-    change_column :share_visibilities, :user_id, :integer, null: false\r\n \r\n     ShareVisibility.joins(\"LEFT OUTER JOIN users ON users.id = share_visibilities.user_id\")\r\n       .delete_all(\"users.id is NULL\")\r\n \r\n+    change_column :share_visibilities, :user_id, :integer, null: false\r\n[...]\r\n```\r\nhttps://github.com/diaspora/diaspora/blob/develop/db/migrate/20160225232049_link_share_visibilities_with_user.rb#L27-L30\r\n\r\nIn case you have entries with `user_id == null` this migration fails. deleting all entries with null before chancing the column should fix the problem.\r\n\r\nno :?"}}
{"actor":{"display_login":"SuperTux88"}}