{"action":"created","issue":{"url":"https://api.github.com/repos/WikiEducationFoundation/WikiEduDashboard/issues/89","labels_url":"https://api.github.com/repos/WikiEducationFoundation/WikiEduDashboard/issues/89/labels{/name}","comments_url":"https://api.github.com/repos/WikiEducationFoundation/WikiEduDashboard/issues/89/comments","events_url":"https://api.github.com/repos/WikiEducationFoundation/WikiEduDashboard/issues/89/events","html_url":"https://github.com/WikiEducationFoundation/WikiEduDashboard/issues/89","id":76041246,"number":89,"title":"Having both the old and new ids for an article with merged or edited revision history breaks ArticleImporter.update_article_status","user":{"login":"ragesoss","id":848483,"avatar_url":"https://avatars.githubusercontent.com/u/848483?v=3","gravatar_id":"","url":"https://api.github.com/users/ragesoss","html_url":"https://github.com/ragesoss","followers_url":"https://api.github.com/users/ragesoss/followers","following_url":"https://api.github.com/users/ragesoss/following{/other_user}","gists_url":"https://api.github.com/users/ragesoss/gists{/gist_id}","starred_url":"https://api.github.com/users/ragesoss/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ragesoss/subscriptions","organizations_url":"https://api.github.com/users/ragesoss/orgs","repos_url":"https://api.github.com/users/ragesoss/repos","events_url":"https://api.github.com/users/ragesoss/events{/privacy}","received_events_url":"https://api.github.com/users/ragesoss/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/WikiEducationFoundation/WikiEduDashboard/labels/high-importance%20bug","name":"high-importance bug","color":"e11d21"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-05-13T16:17:38Z","updated_at":"2015-05-17T04:24:25Z","closed_at":"2015-05-17T02:16:21Z","body":"In the last two days, this has appeared twice, caused by Article.update:\r\n\r\nActiveRecord::RecordNotUnique: Mysql2::Error: Duplicate entry '46349871' for key 'PRIMARY': UPDATE `articles` SET `id` = 46349871, `updated_at` = '2015-05-13 07:45:38', `views` = 0 WHERE `articles`.`id` = 2262715"},"comment":{"url":"https://api.github.com/repos/WikiEducationFoundation/WikiEduDashboard/issues/comments/102740709","html_url":"https://github.com/WikiEducationFoundation/WikiEduDashboard/issues/89#issuecomment-102740709","issue_url":"https://api.github.com/repos/WikiEducationFoundation/WikiEduDashboard/issues/89","id":102740709,"user":{"login":"ragesoss","id":848483,"avatar_url":"https://avatars.githubusercontent.com/u/848483?v=3","gravatar_id":"","url":"https://api.github.com/users/ragesoss","html_url":"https://github.com/ragesoss","followers_url":"https://api.github.com/users/ragesoss/followers","following_url":"https://api.github.com/users/ragesoss/following{/other_user}","gists_url":"https://api.github.com/users/ragesoss/gists{/gist_id}","starred_url":"https://api.github.com/users/ragesoss/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ragesoss/subscriptions","organizations_url":"https://api.github.com/users/ragesoss/orgs","repos_url":"https://api.github.com/users/ragesoss/repos","events_url":"https://api.github.com/users/ragesoss/events{/privacy}","received_events_url":"https://api.github.com/users/ragesoss/received_events","type":"User","site_admin":false},"created_at":"2015-05-17T04:24:25Z","updated_at":"2015-05-17T04:24:25Z","body":"It looks like the problem was that we're using case-insensitive collation in our database. @ntdb do you think we should change the collation for the places where we store strings, like username and article title?"}}