{"action":"closed","number":783,"pull_request":{"url":"https://api.github.com/repos/joomla/jissues/pulls/783","id":68797306,"html_url":"https://github.com/joomla/jissues/pull/783","diff_url":"https://github.com/joomla/jissues/pull/783.diff","patch_url":"https://github.com/joomla/jissues/pull/783.patch","issue_url":"https://api.github.com/repos/joomla/jissues/issues/783","number":783,"state":"closed","locked":false,"title":"Full support for MySQL utf8mb4 (Ref #781)","user":{"login":"mbabker","id":368545,"avatar_url":"https://avatars.githubusercontent.com/u/368545?v=3","gravatar_id":"","url":"https://api.github.com/users/mbabker","html_url":"https://github.com/mbabker","followers_url":"https://api.github.com/users/mbabker/followers","following_url":"https://api.github.com/users/mbabker/following{/other_user}","gists_url":"https://api.github.com/users/mbabker/gists{/gist_id}","starred_url":"https://api.github.com/users/mbabker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mbabker/subscriptions","organizations_url":"https://api.github.com/users/mbabker/orgs","repos_url":"https://api.github.com/users/mbabker/repos","events_url":"https://api.github.com/users/mbabker/events{/privacy}","received_events_url":"https://api.github.com/users/mbabker/received_events","type":"User","site_admin":false},"body":"Pull Request for Issue #781\r\n\r\n#### Summary of Changes\r\n\r\nThis PR brings full support for the MySQL utf8mb4 charset to the application.  Pertinent notes:\r\n\r\n- utf8mb4 support is hardcoded enabled, GitHub is sending emoji characters over so there's no real way to NOT require this anymore\r\n- Likewise that bumps the MySQL platform requirements to 5.5.3+ for the MySQL server\r\n\r\n#### Database Migration\r\n\r\nRun `bin/jtracker database migrate` to execute the migration.\r\n\r\n#### Testing Instructions\r\n\r\nValidate all data is displayed and processed correctly after conversion.","created_at":"2016-05-04T00:39:42Z","updated_at":"2016-06-12T18:53:02Z","closed_at":"2016-06-12T18:53:02Z","merged_at":"2016-06-12T18:53:02Z","merge_commit_sha":"55757d9e856342aad974c843a331531b698f0e23","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/joomla/jissues/pulls/783/commits","review_comments_url":"https://api.github.com/repos/joomla/jissues/pulls/783/comments","review_comment_url":"https://api.github.com/repos/joomla/jissues/pulls/comments{/number}","comments_url":"https://api.github.com/repos/joomla/jissues/issues/783/comments","statuses_url":"https://api.github.com/repos/joomla/jissues/statuses/969c4be122428c408f1a4afbbc7418fd100d353b","head":{"label":"joomla:mysql-utf8mb4","ref":"mysql-utf8mb4","sha":"969c4be122428c408f1a4afbbc7418fd100d353b","user":{"login":"joomla","id":751633,"avatar_url":"https://avatars.githubusercontent.com/u/751633?v=3","gravatar_id":"","url":"https://api.github.com/users/joomla","html_url":"https://github.com/joomla","followers_url":"https://api.github.com/users/joomla/followers","following_url":"https://api.github.com/users/joomla/following{/other_user}","gists_url":"https://api.github.com/users/joomla/gists{/gist_id}","starred_url":"https://api.github.com/users/joomla/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joomla/subscriptions","organizations_url":"https://api.github.com/users/joomla/orgs","repos_url":"https://api.github.com/users/joomla/repos","events_url":"https://api.github.com/users/joomla/events{/privacy}","received_events_url":"https://api.github.com/users/joomla/received_events","type":"Organization","site_admin":false},"repo":{"id":6099080,"name":"jissues","full_name":"joomla/jissues","owner":{"login":"joomla","id":751633,"avatar_url":"https://avatars.githubusercontent.com/u/751633?v=3","gravatar_id":"","url":"https://api.github.com/users/joomla","html_url":"https://github.com/joomla","followers_url":"https://api.github.com/users/joomla/followers","following_url":"https://api.github.com/users/joomla/following{/other_user}","gists_url":"https://api.github.com/users/joomla/gists{/gist_id}","starred_url":"https://api.github.com/users/joomla/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joomla/subscriptions","organizations_url":"https://api.github.com/users/joomla/orgs","repos_url":"https://api.github.com/users/joomla/repos","events_url":"https://api.github.com/users/joomla/events{/privacy}","received_events_url":"https://api.github.com/users/joomla/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/joomla/jissues","description":"Issue Tracking application integrating with GitHub to replace the existing Joomlacode solution.","fork":false,"url":"https://api.github.com/repos/joomla/jissues","forks_url":"https://api.github.com/repos/joomla/jissues/forks","keys_url":"https://api.github.com/repos/joomla/jissues/keys{/key_id}","collaborators_url":"https://api.github.com/repos/joomla/jissues/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/joomla/jissues/teams","hooks_url":"https://api.github.com/repos/joomla/jissues/hooks","issue_events_url":"https://api.github.com/repos/joomla/jissues/issues/events{/number}","events_url":"https://api.github.com/repos/joomla/jissues/events","assignees_url":"https://api.github.com/repos/joomla/jissues/assignees{/user}","branches_url":"https://api.github.com/repos/joomla/jissues/branches{/branch}","tags_url":"https://api.github.com/repos/joomla/jissues/tags","blobs_url":"https://api.github.com/repos/joomla/jissues/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/joomla/jissues/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/joomla/jissues/git/refs{/sha}","trees_url":"https://api.github.com/repos/joomla/jissues/git/trees{/sha}","statuses_url":"https://api.github.com/repos/joomla/jissues/statuses/{sha}","languages_url":"https://api.github.com/repos/joomla/jissues/languages","stargazers_url":"https://api.github.com/repos/joomla/jissues/stargazers","contributors_url":"https://api.github.com/repos/joomla/jissues/contributors","subscribers_url":"https://api.github.com/repos/joomla/jissues/subscribers","subscription_url":"https://api.github.com/repos/joomla/jissues/subscription","commits_url":"https://api.github.com/repos/joomla/jissues/commits{/sha}","git_commits_url":"https://api.github.com/repos/joomla/jissues/git/commits{/sha}","comments_url":"https://api.github.com/repos/joomla/jissues/comments{/number}","issue_comment_url":"https://api.github.com/repos/joomla/jissues/issues/comments{/number}","contents_url":"https://api.github.com/repos/joomla/jissues/contents/{+path}","compare_url":"https://api.github.com/repos/joomla/jissues/compare/{base}...{head}","merges_url":"https://api.github.com/repos/joomla/jissues/merges","archive_url":"https://api.github.com/repos/joomla/jissues/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/joomla/jissues/downloads","issues_url":"https://api.github.com/repos/joomla/jissues/issues{/number}","pulls_url":"https://api.github.com/repos/joomla/jissues/pulls{/number}","milestones_url":"https://api.github.com/repos/joomla/jissues/milestones{/number}","notifications_url":"https://api.github.com/repos/joomla/jissues/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/joomla/jissues/labels{/name}","releases_url":"https://api.github.com/repos/joomla/jissues/releases{/id}","deployments_url":"https://api.github.com/repos/joomla/jissues/deployments","created_at":"2012-10-06T02:12:43Z","updated_at":"2016-05-10T15:44:48Z","pushed_at":"2016-06-12T18:53:02Z","git_url":"git://github.com/joomla/jissues.git","ssh_url":"git@github.com:joomla/jissues.git","clone_url":"https://github.com/joomla/jissues.git","svn_url":"https://github.com/joomla/jissues","homepage":"","size":18617,"stargazers_count":55,"watchers_count":55,"language":"JavaScript","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":50,"mirror_url":null,"open_issues_count":47,"forks":50,"open_issues":47,"watchers":55,"default_branch":"master"}},"base":{"label":"joomla:master","ref":"master","sha":"f50d12ad62890527f17cdda334bc3ce88f3ba97a","user":{"login":"joomla","id":751633,"avatar_url":"https://avatars.githubusercontent.com/u/751633?v=3","gravatar_id":"","url":"https://api.github.com/users/joomla","html_url":"https://github.com/joomla","followers_url":"https://api.github.com/users/joomla/followers","following_url":"https://api.github.com/users/joomla/following{/other_user}","gists_url":"https://api.github.com/users/joomla/gists{/gist_id}","starred_url":"https://api.github.com/users/joomla/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joomla/subscriptions","organizations_url":"https://api.github.com/users/joomla/orgs","repos_url":"https://api.github.com/users/joomla/repos","events_url":"https://api.github.com/users/joomla/events{/privacy}","received_events_url":"https://api.github.com/users/joomla/received_events","type":"Organization","site_admin":false},"repo":{"id":6099080,"name":"jissues","full_name":"joomla/jissues","owner":{"login":"joomla","id":751633,"avatar_url":"https://avatars.githubusercontent.com/u/751633?v=3","gravatar_id":"","url":"https://api.github.com/users/joomla","html_url":"https://github.com/joomla","followers_url":"https://api.github.com/users/joomla/followers","following_url":"https://api.github.com/users/joomla/following{/other_user}","gists_url":"https://api.github.com/users/joomla/gists{/gist_id}","starred_url":"https://api.github.com/users/joomla/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joomla/subscriptions","organizations_url":"https://api.github.com/users/joomla/orgs","repos_url":"https://api.github.com/users/joomla/repos","events_url":"https://api.github.com/users/joomla/events{/privacy}","received_events_url":"https://api.github.com/users/joomla/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/joomla/jissues","description":"Issue Tracking application integrating with GitHub to replace the existing Joomlacode solution.","fork":false,"url":"https://api.github.com/repos/joomla/jissues","forks_url":"https://api.github.com/repos/joomla/jissues/forks","keys_url":"https://api.github.com/repos/joomla/jissues/keys{/key_id}","collaborators_url":"https://api.github.com/repos/joomla/jissues/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/joomla/jissues/teams","hooks_url":"https://api.github.com/repos/joomla/jissues/hooks","issue_events_url":"https://api.github.com/repos/joomla/jissues/issues/events{/number}","events_url":"https://api.github.com/repos/joomla/jissues/events","assignees_url":"https://api.github.com/repos/joomla/jissues/assignees{/user}","branches_url":"https://api.github.com/repos/joomla/jissues/branches{/branch}","tags_url":"https://api.github.com/repos/joomla/jissues/tags","blobs_url":"https://api.github.com/repos/joomla/jissues/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/joomla/jissues/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/joomla/jissues/git/refs{/sha}","trees_url":"https://api.github.com/repos/joomla/jissues/git/trees{/sha}","statuses_url":"https://api.github.com/repos/joomla/jissues/statuses/{sha}","languages_url":"https://api.github.com/repos/joomla/jissues/languages","stargazers_url":"https://api.github.com/repos/joomla/jissues/stargazers","contributors_url":"https://api.github.com/repos/joomla/jissues/contributors","subscribers_url":"https://api.github.com/repos/joomla/jissues/subscribers","subscription_url":"https://api.github.com/repos/joomla/jissues/subscription","commits_url":"https://api.github.com/repos/joomla/jissues/commits{/sha}","git_commits_url":"https://api.github.com/repos/joomla/jissues/git/commits{/sha}","comments_url":"https://api.github.com/repos/joomla/jissues/comments{/number}","issue_comment_url":"https://api.github.com/repos/joomla/jissues/issues/comments{/number}","contents_url":"https://api.github.com/repos/joomla/jissues/contents/{+path}","compare_url":"https://api.github.com/repos/joomla/jissues/compare/{base}...{head}","merges_url":"https://api.github.com/repos/joomla/jissues/merges","archive_url":"https://api.github.com/repos/joomla/jissues/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/joomla/jissues/downloads","issues_url":"https://api.github.com/repos/joomla/jissues/issues{/number}","pulls_url":"https://api.github.com/repos/joomla/jissues/pulls{/number}","milestones_url":"https://api.github.com/repos/joomla/jissues/milestones{/number}","notifications_url":"https://api.github.com/repos/joomla/jissues/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/joomla/jissues/labels{/name}","releases_url":"https://api.github.com/repos/joomla/jissues/releases{/id}","deployments_url":"https://api.github.com/repos/joomla/jissues/deployments","created_at":"2012-10-06T02:12:43Z","updated_at":"2016-05-10T15:44:48Z","pushed_at":"2016-06-12T18:53:02Z","git_url":"git://github.com/joomla/jissues.git","ssh_url":"git@github.com:joomla/jissues.git","clone_url":"https://github.com/joomla/jissues.git","svn_url":"https://github.com/joomla/jissues","homepage":"","size":18617,"stargazers_count":55,"watchers_count":55,"language":"JavaScript","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":50,"mirror_url":null,"open_issues_count":47,"forks":50,"open_issues":47,"watchers":55,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/joomla/jissues/pulls/783"},"html":{"href":"https://github.com/joomla/jissues/pull/783"},"issue":{"href":"https://api.github.com/repos/joomla/jissues/issues/783"},"comments":{"href":"https://api.github.com/repos/joomla/jissues/issues/783/comments"},"review_comments":{"href":"https://api.github.com/repos/joomla/jissues/pulls/783/comments"},"review_comment":{"href":"https://api.github.com/repos/joomla/jissues/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/joomla/jissues/pulls/783/commits"},"statuses":{"href":"https://api.github.com/repos/joomla/jissues/statuses/969c4be122428c408f1a4afbbc7418fd100d353b"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"login":"elkuku","id":33978,"avatar_url":"https://avatars.githubusercontent.com/u/33978?v=3","gravatar_id":"","url":"https://api.github.com/users/elkuku","html_url":"https://github.com/elkuku","followers_url":"https://api.github.com/users/elkuku/followers","following_url":"https://api.github.com/users/elkuku/following{/other_user}","gists_url":"https://api.github.com/users/elkuku/gists{/gist_id}","starred_url":"https://api.github.com/users/elkuku/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elkuku/subscriptions","organizations_url":"https://api.github.com/users/elkuku/orgs","repos_url":"https://api.github.com/users/elkuku/repos","events_url":"https://api.github.com/users/elkuku/events{/privacy}","received_events_url":"https://api.github.com/users/elkuku/received_events","type":"User","site_admin":false},"comments":1,"review_comments":2,"commits":7,"additions":119,"deletions":46,"changed_files":8}}
{"actor":{"display_login":"elkuku"}}