{"action":"closed","number":517,"pull_request":{"url":"https://api.github.com/repos/mautic/mautic/pulls/517","id":37069646,"html_url":"https://github.com/mautic/mautic/pull/517","diff_url":"https://github.com/mautic/mautic/pull/517.diff","patch_url":"https://github.com/mautic/mautic/pull/517.patch","issue_url":"https://api.github.com/repos/mautic/mautic/issues/517","number":517,"state":"closed","locked":false,"title":"Prevents doctrine serialized array, bad UTF and mysql from crashing system","user":{"login":"alanhartless","id":63312,"avatar_url":"https://avatars.githubusercontent.com/u/63312?v=3","gravatar_id":"","url":"https://api.github.com/users/alanhartless","html_url":"https://github.com/alanhartless","followers_url":"https://api.github.com/users/alanhartless/followers","following_url":"https://api.github.com/users/alanhartless/following{/other_user}","gists_url":"https://api.github.com/users/alanhartless/gists{/gist_id}","starred_url":"https://api.github.com/users/alanhartless/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alanhartless/subscriptions","organizations_url":"https://api.github.com/users/alanhartless/orgs","repos_url":"https://api.github.com/users/alanhartless/repos","events_url":"https://api.github.com/users/alanhartless/events{/privacy}","received_events_url":"https://api.github.com/users/alanhartless/received_events","type":"User","site_admin":false},"body":"This ensures serialized arrays are UTF8 before saving to prevent it from crashing the system due to the serialized strings becoming corrupt once persisted to the db. \r\n\r\nThis tends to happen with lead imports and bad csv files. Use http://d.dvkrd.co/drop/bad.csv to lest an import with.  Before the PR, the imported leads will cause the dashboard, lead profile and other places to crash.  Truncate the audit_log table and delete the leads from the leads table, apply the patch, clear system cache and try again.  This time the leads should not kill the system.\r\n\r\n","created_at":"2015-06-05T21:00:37Z","updated_at":"2015-06-05T22:50:55Z","closed_at":"2015-06-05T22:50:55Z","merged_at":"2015-06-05T22:50:55Z","merge_commit_sha":"578d3d7c9843a86b22c5c240c89e69a3c346b419","assignee":null,"milestone":{"url":"https://api.github.com/repos/mautic/mautic/milestones/4","html_url":"https://github.com/mautic/mautic/milestones/1.0.6","labels_url":"https://api.github.com/repos/mautic/mautic/milestones/4/labels","id":1119089,"number":4,"title":"1.0.6","description":"","creator":{"login":"alanhartless","id":63312,"avatar_url":"https://avatars.githubusercontent.com/u/63312?v=3","gravatar_id":"","url":"https://api.github.com/users/alanhartless","html_url":"https://github.com/alanhartless","followers_url":"https://api.github.com/users/alanhartless/followers","following_url":"https://api.github.com/users/alanhartless/following{/other_user}","gists_url":"https://api.github.com/users/alanhartless/gists{/gist_id}","starred_url":"https://api.github.com/users/alanhartless/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alanhartless/subscriptions","organizations_url":"https://api.github.com/users/alanhartless/orgs","repos_url":"https://api.github.com/users/alanhartless/repos","events_url":"https://api.github.com/users/alanhartless/events{/privacy}","received_events_url":"https://api.github.com/users/alanhartless/received_events","type":"User","site_admin":false},"open_issues":14,"closed_issues":81,"state":"open","created_at":"2015-05-19T19:31:19Z","updated_at":"2015-06-05T22:50:55Z","due_on":null,"closed_at":null},"commits_url":"https://api.github.com/repos/mautic/mautic/pulls/517/commits","review_comments_url":"https://api.github.com/repos/mautic/mautic/pulls/517/comments","review_comment_url":"https://api.github.com/repos/mautic/mautic/pulls/comments{/number}","comments_url":"https://api.github.com/repos/mautic/mautic/issues/517/comments","statuses_url":"https://api.github.com/repos/mautic/mautic/statuses/ef8bfc555ac55ea2bde230d7e779b8c8ad4a747d","head":{"label":"alanhartless:doctrine-array-fix","ref":"doctrine-array-fix","sha":"ef8bfc555ac55ea2bde230d7e779b8c8ad4a747d","user":{"login":"alanhartless","id":63312,"avatar_url":"https://avatars.githubusercontent.com/u/63312?v=3","gravatar_id":"","url":"https://api.github.com/users/alanhartless","html_url":"https://github.com/alanhartless","followers_url":"https://api.github.com/users/alanhartless/followers","following_url":"https://api.github.com/users/alanhartless/following{/other_user}","gists_url":"https://api.github.com/users/alanhartless/gists{/gist_id}","starred_url":"https://api.github.com/users/alanhartless/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alanhartless/subscriptions","organizations_url":"https://api.github.com/users/alanhartless/orgs","repos_url":"https://api.github.com/users/alanhartless/repos","events_url":"https://api.github.com/users/alanhartless/events{/privacy}","received_events_url":"https://api.github.com/users/alanhartless/received_events","type":"User","site_admin":false},"repo":{"id":31477695,"name":"mautic","full_name":"alanhartless/mautic","owner":{"login":"alanhartless","id":63312,"avatar_url":"https://avatars.githubusercontent.com/u/63312?v=3","gravatar_id":"","url":"https://api.github.com/users/alanhartless","html_url":"https://github.com/alanhartless","followers_url":"https://api.github.com/users/alanhartless/followers","following_url":"https://api.github.com/users/alanhartless/following{/other_user}","gists_url":"https://api.github.com/users/alanhartless/gists{/gist_id}","starred_url":"https://api.github.com/users/alanhartless/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alanhartless/subscriptions","organizations_url":"https://api.github.com/users/alanhartless/orgs","repos_url":"https://api.github.com/users/alanhartless/repos","events_url":"https://api.github.com/users/alanhartless/events{/privacy}","received_events_url":"https://api.github.com/users/alanhartless/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/alanhartless/mautic","description":"Mautic: Open Source Marketing Automation Software.","fork":true,"url":"https://api.github.com/repos/alanhartless/mautic","forks_url":"https://api.github.com/repos/alanhartless/mautic/forks","keys_url":"https://api.github.com/repos/alanhartless/mautic/keys{/key_id}","collaborators_url":"https://api.github.com/repos/alanhartless/mautic/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/alanhartless/mautic/teams","hooks_url":"https://api.github.com/repos/alanhartless/mautic/hooks","issue_events_url":"https://api.github.com/repos/alanhartless/mautic/issues/events{/number}","events_url":"https://api.github.com/repos/alanhartless/mautic/events","assignees_url":"https://api.github.com/repos/alanhartless/mautic/assignees{/user}","branches_url":"https://api.github.com/repos/alanhartless/mautic/branches{/branch}","tags_url":"https://api.github.com/repos/alanhartless/mautic/tags","blobs_url":"https://api.github.com/repos/alanhartless/mautic/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/alanhartless/mautic/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/alanhartless/mautic/git/refs{/sha}","trees_url":"https://api.github.com/repos/alanhartless/mautic/git/trees{/sha}","statuses_url":"https://api.github.com/repos/alanhartless/mautic/statuses/{sha}","languages_url":"https://api.github.com/repos/alanhartless/mautic/languages","stargazers_url":"https://api.github.com/repos/alanhartless/mautic/stargazers","contributors_url":"https://api.github.com/repos/alanhartless/mautic/contributors","subscribers_url":"https://api.github.com/repos/alanhartless/mautic/subscribers","subscription_url":"https://api.github.com/repos/alanhartless/mautic/subscription","commits_url":"https://api.github.com/repos/alanhartless/mautic/commits{/sha}","git_commits_url":"https://api.github.com/repos/alanhartless/mautic/git/commits{/sha}","comments_url":"https://api.github.com/repos/alanhartless/mautic/comments{/number}","issue_comment_url":"https://api.github.com/repos/alanhartless/mautic/issues/comments{/number}","contents_url":"https://api.github.com/repos/alanhartless/mautic/contents/{+path}","compare_url":"https://api.github.com/repos/alanhartless/mautic/compare/{base}...{head}","merges_url":"https://api.github.com/repos/alanhartless/mautic/merges","archive_url":"https://api.github.com/repos/alanhartless/mautic/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/alanhartless/mautic/downloads","issues_url":"https://api.github.com/repos/alanhartless/mautic/issues{/number}","pulls_url":"https://api.github.com/repos/alanhartless/mautic/pulls{/number}","milestones_url":"https://api.github.com/repos/alanhartless/mautic/milestones{/number}","notifications_url":"https://api.github.com/repos/alanhartless/mautic/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/alanhartless/mautic/labels{/name}","releases_url":"https://api.github.com/repos/alanhartless/mautic/releases{/id}","created_at":"2015-02-28T21:38:41Z","updated_at":"2015-05-01T13:26:15Z","pushed_at":"2015-06-05T22:22:44Z","git_url":"git://github.com/alanhartless/mautic.git","ssh_url":"git@github.com:alanhartless/mautic.git","clone_url":"https://github.com/alanhartless/mautic.git","svn_url":"https://github.com/alanhartless/mautic","homepage":"http://mautic.org","size":26310,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"mautic:staging","ref":"staging","sha":"dc86e46b79b4672ad013d8dd0f5376b6696f1b2d","user":{"login":"mautic","id":5257677,"avatar_url":"https://avatars.githubusercontent.com/u/5257677?v=3","gravatar_id":"","url":"https://api.github.com/users/mautic","html_url":"https://github.com/mautic","followers_url":"https://api.github.com/users/mautic/followers","following_url":"https://api.github.com/users/mautic/following{/other_user}","gists_url":"https://api.github.com/users/mautic/gists{/gist_id}","starred_url":"https://api.github.com/users/mautic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mautic/subscriptions","organizations_url":"https://api.github.com/users/mautic/orgs","repos_url":"https://api.github.com/users/mautic/repos","events_url":"https://api.github.com/users/mautic/events{/privacy}","received_events_url":"https://api.github.com/users/mautic/received_events","type":"Organization","site_admin":false},"repo":{"id":12204147,"name":"mautic","full_name":"mautic/mautic","owner":{"login":"mautic","id":5257677,"avatar_url":"https://avatars.githubusercontent.com/u/5257677?v=3","gravatar_id":"","url":"https://api.github.com/users/mautic","html_url":"https://github.com/mautic","followers_url":"https://api.github.com/users/mautic/followers","following_url":"https://api.github.com/users/mautic/following{/other_user}","gists_url":"https://api.github.com/users/mautic/gists{/gist_id}","starred_url":"https://api.github.com/users/mautic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mautic/subscriptions","organizations_url":"https://api.github.com/users/mautic/orgs","repos_url":"https://api.github.com/users/mautic/repos","events_url":"https://api.github.com/users/mautic/events{/privacy}","received_events_url":"https://api.github.com/users/mautic/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/mautic/mautic","description":"Mautic: Open Source Marketing Automation Software.","fork":false,"url":"https://api.github.com/repos/mautic/mautic","forks_url":"https://api.github.com/repos/mautic/mautic/forks","keys_url":"https://api.github.com/repos/mautic/mautic/keys{/key_id}","collaborators_url":"https://api.github.com/repos/mautic/mautic/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/mautic/mautic/teams","hooks_url":"https://api.github.com/repos/mautic/mautic/hooks","issue_events_url":"https://api.github.com/repos/mautic/mautic/issues/events{/number}","events_url":"https://api.github.com/repos/mautic/mautic/events","assignees_url":"https://api.github.com/repos/mautic/mautic/assignees{/user}","branches_url":"https://api.github.com/repos/mautic/mautic/branches{/branch}","tags_url":"https://api.github.com/repos/mautic/mautic/tags","blobs_url":"https://api.github.com/repos/mautic/mautic/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/mautic/mautic/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/mautic/mautic/git/refs{/sha}","trees_url":"https://api.github.com/repos/mautic/mautic/git/trees{/sha}","statuses_url":"https://api.github.com/repos/mautic/mautic/statuses/{sha}","languages_url":"https://api.github.com/repos/mautic/mautic/languages","stargazers_url":"https://api.github.com/repos/mautic/mautic/stargazers","contributors_url":"https://api.github.com/repos/mautic/mautic/contributors","subscribers_url":"https://api.github.com/repos/mautic/mautic/subscribers","subscription_url":"https://api.github.com/repos/mautic/mautic/subscription","commits_url":"https://api.github.com/repos/mautic/mautic/commits{/sha}","git_commits_url":"https://api.github.com/repos/mautic/mautic/git/commits{/sha}","comments_url":"https://api.github.com/repos/mautic/mautic/comments{/number}","issue_comment_url":"https://api.github.com/repos/mautic/mautic/issues/comments{/number}","contents_url":"https://api.github.com/repos/mautic/mautic/contents/{+path}","compare_url":"https://api.github.com/repos/mautic/mautic/compare/{base}...{head}","merges_url":"https://api.github.com/repos/mautic/mautic/merges","archive_url":"https://api.github.com/repos/mautic/mautic/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/mautic/mautic/downloads","issues_url":"https://api.github.com/repos/mautic/mautic/issues{/number}","pulls_url":"https://api.github.com/repos/mautic/mautic/pulls{/number}","milestones_url":"https://api.github.com/repos/mautic/mautic/milestones{/number}","notifications_url":"https://api.github.com/repos/mautic/mautic/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/mautic/mautic/labels{/name}","releases_url":"https://api.github.com/repos/mautic/mautic/releases{/id}","created_at":"2013-08-19T00:36:28Z","updated_at":"2015-06-05T19:03:29Z","pushed_at":"2015-06-05T22:50:55Z","git_url":"git://github.com/mautic/mautic.git","ssh_url":"git@github.com:mautic/mautic.git","clone_url":"https://github.com/mautic/mautic.git","svn_url":"https://github.com/mautic/mautic","homepage":"https://www.mautic.org","size":32739,"stargazers_count":163,"watchers_count":163,"language":"PHP","has_issues":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":53,"mirror_url":null,"open_issues_count":114,"forks":53,"open_issues":114,"watchers":163,"default_branch":"staging"}},"_links":{"self":{"href":"https://api.github.com/repos/mautic/mautic/pulls/517"},"html":{"href":"https://github.com/mautic/mautic/pull/517"},"issue":{"href":"https://api.github.com/repos/mautic/mautic/issues/517"},"comments":{"href":"https://api.github.com/repos/mautic/mautic/issues/517/comments"},"review_comments":{"href":"https://api.github.com/repos/mautic/mautic/pulls/517/comments"},"review_comment":{"href":"https://api.github.com/repos/mautic/mautic/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/mautic/mautic/pulls/517/commits"},"statuses":{"href":"https://api.github.com/repos/mautic/mautic/statuses/ef8bfc555ac55ea2bde230d7e779b8c8ad4a747d"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"login":"dbhurley","id":5251425,"avatar_url":"https://avatars.githubusercontent.com/u/5251425?v=3","gravatar_id":"","url":"https://api.github.com/users/dbhurley","html_url":"https://github.com/dbhurley","followers_url":"https://api.github.com/users/dbhurley/followers","following_url":"https://api.github.com/users/dbhurley/following{/other_user}","gists_url":"https://api.github.com/users/dbhurley/gists{/gist_id}","starred_url":"https://api.github.com/users/dbhurley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dbhurley/subscriptions","organizations_url":"https://api.github.com/users/dbhurley/orgs","repos_url":"https://api.github.com/users/dbhurley/repos","events_url":"https://api.github.com/users/dbhurley/events{/privacy}","received_events_url":"https://api.github.com/users/dbhurley/received_events","type":"User","site_admin":false},"comments":0,"review_comments":0,"commits":1,"additions":485,"deletions":0,"changed_files":3}}