{"action":"created","issue":{"url":"https://api.github.com/repos/petities/petitions.eu/issues/117","labels_url":"https://api.github.com/repos/petities/petitions.eu/issues/117/labels{/name}","comments_url":"https://api.github.com/repos/petities/petitions.eu/issues/117/comments","events_url":"https://api.github.com/repos/petities/petitions.eu/issues/117/events","html_url":"https://github.com/petities/petitions.eu/issues/117","id":122474418,"number":117,"title":"latin conversion failed. on test production","user":{"login":"spreeker","id":59697,"avatar_url":"https://avatars.githubusercontent.com/u/59697?v=3","gravatar_id":"","url":"https://api.github.com/users/spreeker","html_url":"https://github.com/spreeker","followers_url":"https://api.github.com/users/spreeker/followers","following_url":"https://api.github.com/users/spreeker/following{/other_user}","gists_url":"https://api.github.com/users/spreeker/gists{/gist_id}","starred_url":"https://api.github.com/users/spreeker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spreeker/subscriptions","organizations_url":"https://api.github.com/users/spreeker/orgs","repos_url":"https://api.github.com/users/spreeker/repos","events_url":"https://api.github.com/users/spreeker/events{/privacy}","received_events_url":"https://api.github.com/users/spreeker/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"johankok","id":72483,"avatar_url":"https://avatars.githubusercontent.com/u/72483?v=3","gravatar_id":"","url":"https://api.github.com/users/johankok","html_url":"https://github.com/johankok","followers_url":"https://api.github.com/users/johankok/followers","following_url":"https://api.github.com/users/johankok/following{/other_user}","gists_url":"https://api.github.com/users/johankok/gists{/gist_id}","starred_url":"https://api.github.com/users/johankok/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/johankok/subscriptions","organizations_url":"https://api.github.com/users/johankok/orgs","repos_url":"https://api.github.com/users/johankok/repos","events_url":"https://api.github.com/users/johankok/events{/privacy}","received_events_url":"https://api.github.com/users/johankok/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/petities/petitions.eu/milestones/1","html_url":"https://github.com/petities/petitions.eu/milestones/all%20production%20features","labels_url":"https://api.github.com/repos/petities/petitions.eu/milestones/1/labels","id":1406639,"number":1,"title":"all production features","description":"All features that need to be implemented so we can transition to new website.","creator":{"login":"spreeker","id":59697,"avatar_url":"https://avatars.githubusercontent.com/u/59697?v=3","gravatar_id":"","url":"https://api.github.com/users/spreeker","html_url":"https://github.com/spreeker","followers_url":"https://api.github.com/users/spreeker/followers","following_url":"https://api.github.com/users/spreeker/following{/other_user}","gists_url":"https://api.github.com/users/spreeker/gists{/gist_id}","starred_url":"https://api.github.com/users/spreeker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spreeker/subscriptions","organizations_url":"https://api.github.com/users/spreeker/orgs","repos_url":"https://api.github.com/users/spreeker/repos","events_url":"https://api.github.com/users/spreeker/events{/privacy}","received_events_url":"https://api.github.com/users/spreeker/received_events","type":"User","site_admin":false},"open_issues":9,"closed_issues":29,"state":"open","created_at":"2015-11-11T14:36:12Z","updated_at":"2015-12-17T14:10:26Z","due_on":"2015-12-06T23:00:00Z","closed_at":null},"comments":7,"created_at":"2015-12-16T10:39:05Z","updated_at":"2015-12-18T09:18:47Z","closed_at":null,"body":"Many petitions show wrong data in fields.\r\n\r\nI think below command has not been done. or Maybe the order is important and should be done before the database is switched to utf8.\r\n\r\nConvert lating8 special characters to utf8\r\n\r\n    mysqldump --add-drop-table database_name | iconv -f latin1 -t utf8 | mysql database_name"},"comment":{"url":"https://api.github.com/repos/petities/petitions.eu/issues/comments/165721209","html_url":"https://github.com/petities/petitions.eu/issues/117#issuecomment-165721209","issue_url":"https://api.github.com/repos/petities/petitions.eu/issues/117","id":165721209,"user":{"login":"johankok","id":72483,"avatar_url":"https://avatars.githubusercontent.com/u/72483?v=3","gravatar_id":"","url":"https://api.github.com/users/johankok","html_url":"https://github.com/johankok","followers_url":"https://api.github.com/users/johankok/followers","following_url":"https://api.github.com/users/johankok/following{/other_user}","gists_url":"https://api.github.com/users/johankok/gists{/gist_id}","starred_url":"https://api.github.com/users/johankok/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/johankok/subscriptions","organizations_url":"https://api.github.com/users/johankok/orgs","repos_url":"https://api.github.com/users/johankok/repos","events_url":"https://api.github.com/users/johankok/events{/privacy}","received_events_url":"https://api.github.com/users/johankok/received_events","type":"User","site_admin":false},"created_at":"2015-12-18T09:18:47Z","updated_at":"2015-12-18T09:18:47Z","body":"* Recreated database,\r\n* Imported the `fixed_backup` file,\r\n* ``cap production deploy:migrate`` completed with success.\r\n\r\nThe problem was not fixed. I still see those incorrect characters. Do you have any suggestions?"}}