{"action":"opened","issue":{"url":"https://api.github.com/repos/bbernhard/imagemonkey-core/issues/111","repository_url":"https://api.github.com/repos/bbernhard/imagemonkey-core","labels_url":"https://api.github.com/repos/bbernhard/imagemonkey-core/issues/111/labels{/name}","comments_url":"https://api.github.com/repos/bbernhard/imagemonkey-core/issues/111/comments","events_url":"https://api.github.com/repos/bbernhard/imagemonkey-core/issues/111/events","html_url":"https://github.com/bbernhard/imagemonkey-core/issues/111","id":316923979,"number":111,"title":"fix dataset statistics","user":{"login":"bbernhard","id":5710631,"avatar_url":"https://avatars3.githubusercontent.com/u/5710631?v=4","gravatar_id":"","url":"https://api.github.com/users/bbernhard","html_url":"https://github.com/bbernhard","followers_url":"https://api.github.com/users/bbernhard/followers","following_url":"https://api.github.com/users/bbernhard/following{/other_user}","gists_url":"https://api.github.com/users/bbernhard/gists{/gist_id}","starred_url":"https://api.github.com/users/bbernhard/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bbernhard/subscriptions","organizations_url":"https://api.github.com/users/bbernhard/orgs","repos_url":"https://api.github.com/users/bbernhard/repos","events_url":"https://api.github.com/users/bbernhard/events{/privacy}","received_events_url":"https://api.github.com/users/bbernhard/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-04-23T18:13:57Z","updated_at":"2018-04-23T18:13:57Z","closed_at":null,"author_association":"OWNER","body":"The introduction of the `uuid` column in the `image_validation` table resulted in the creation of a lot of entries in the `image_validation_history` table. As the table is used as main source for the activity chart, we get some messed up statistics. \r\n\r\nWe should delete all rows in the `image_validation_history` table that correspond to the 22-04-2018 and are related to the introduction of the `uuid` column.\r\n\r\n![statistics_whoops](https://user-images.githubusercontent.com/5710631/39145043-d6b27c46-4732-11e8-89b0-93dbed01e35d.png)\r\n\r\n\r\njust for clarification: all the data in the dataset is correct - it's only the statistics table that's messed up. "}}
{"actor":{"display_login":"bbernhard"}}