{"action":"created","issue":{"url":"https://api.github.com/repos/Block8/PHPCI/issues/540","labels_url":"https://api.github.com/repos/Block8/PHPCI/issues/540/labels{/name}","comments_url":"https://api.github.com/repos/Block8/PHPCI/issues/540/comments","events_url":"https://api.github.com/repos/Block8/PHPCI/issues/540/events","html_url":"https://github.com/Block8/PHPCI/issues/540","id":39416472,"number":540,"title":"Error message when report metadata has invalid json","user":{"login":"Hikariii","id":1484903,"avatar_url":"https://avatars.githubusercontent.com/u/1484903?v=3","gravatar_id":"","url":"https://api.github.com/users/Hikariii","html_url":"https://github.com/Hikariii","followers_url":"https://api.github.com/users/Hikariii/followers","following_url":"https://api.github.com/users/Hikariii/following{/other_user}","gists_url":"https://api.github.com/users/Hikariii/gists{/gist_id}","starred_url":"https://api.github.com/users/Hikariii/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Hikariii/subscriptions","organizations_url":"https://api.github.com/users/Hikariii/orgs","repos_url":"https://api.github.com/users/Hikariii/repos","events_url":"https://api.github.com/users/Hikariii/events{/privacy}","received_events_url":"https://api.github.com/users/Hikariii/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Block8/PHPCI/labels/bug:confirmed","name":"bug:confirmed","color":"e11d21"},{"url":"https://api.github.com/repos/Block8/PHPCI/labels/component:front-end","name":"component:front-end","color":"fbca04"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2014-08-04T12:37:32Z","updated_at":"2015-02-09T10:58:12Z","closed_at":null,"body":"The ```meta_value``` field in the ```build_meta``` table is a text field and not big enough to contain large plugin reports. The data got truncated and I got invalid json.\r\nI solved it by changing the field type for the ```meta_value``` field:\r\n\r\n```sql\r\nALTER TABLE  `build_meta` CHANGE  `meta_value`  `meta_value` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;\r\n```\r\n\r\nI suggest at least error handling for invalid json, so that a user sees that his errors are too much for phpci.\r\n\r\nIt would also be nice to enlarge the field for big reports."},"comment":{"url":"https://api.github.com/repos/Block8/PHPCI/issues/comments/73490627","html_url":"https://github.com/Block8/PHPCI/issues/540#issuecomment-73490627","issue_url":"https://api.github.com/repos/Block8/PHPCI/issues/540","id":73490627,"user":{"login":"Hikariii","id":1484903,"avatar_url":"https://avatars.githubusercontent.com/u/1484903?v=3","gravatar_id":"","url":"https://api.github.com/users/Hikariii","html_url":"https://github.com/Hikariii","followers_url":"https://api.github.com/users/Hikariii/followers","following_url":"https://api.github.com/users/Hikariii/following{/other_user}","gists_url":"https://api.github.com/users/Hikariii/gists{/gist_id}","starred_url":"https://api.github.com/users/Hikariii/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Hikariii/subscriptions","organizations_url":"https://api.github.com/users/Hikariii/orgs","repos_url":"https://api.github.com/users/Hikariii/repos","events_url":"https://api.github.com/users/Hikariii/events{/privacy}","received_events_url":"https://api.github.com/users/Hikariii/received_events","type":"User","site_admin":false},"created_at":"2015-02-09T10:58:12Z","updated_at":"2015-02-09T10:58:12Z","body":"It seems the implementation differs from the PR, but from the release notes and the mysql adapter code it looks like longtext just works:\r\n- https://github.com/robmorgan/phinx#version-history (v0.4.0)\r\n- https://github.com/robmorgan/phinx/blob/v0.4.2.1/src/Phinx/Db/Adapter/MysqlAdapter.php#L720-L735"}}