{"action":"created","issue":{"url":"https://api.github.com/repos/cachethq/Cachet/issues/287","labels_url":"https://api.github.com/repos/cachethq/Cachet/issues/287/labels{/name}","comments_url":"https://api.github.com/repos/cachethq/Cachet/issues/287/comments","events_url":"https://api.github.com/repos/cachethq/Cachet/issues/287/events","html_url":"https://github.com/cachethq/Cachet/issues/287","id":53400678,"number":287,"title":"[PostgreSQL] Can't add a component without group (500 error)","user":{"login":"willdurand","id":217628,"avatar_url":"https://avatars.githubusercontent.com/u/217628?v=3","gravatar_id":"","url":"https://api.github.com/users/willdurand","html_url":"https://github.com/willdurand","followers_url":"https://api.github.com/users/willdurand/followers","following_url":"https://api.github.com/users/willdurand/following{/other_user}","gists_url":"https://api.github.com/users/willdurand/gists{/gist_id}","starred_url":"https://api.github.com/users/willdurand/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/willdurand/subscriptions","organizations_url":"https://api.github.com/users/willdurand/orgs","repos_url":"https://api.github.com/users/willdurand/repos","events_url":"https://api.github.com/users/willdurand/events{/privacy}","received_events_url":"https://api.github.com/users/willdurand/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-01-05T14:25:27Z","updated_at":"2015-01-05T15:20:44Z","closed_at":null,"body":"See: #285 \r\n\r\n```\r\n2015-01-05T14:05:04.774106+00:00 app[web.1]: Next exception 'Illuminate\\Database\\QueryException' with message 'SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: \"\" (SQL: insert into \"components\" (\"name\", \"status\", \"description\", \"group_id\", \"link\", \"tags\", \"user_id\", \"updated_at\", \"created_at\") values (Website, 1, foo, , http://example.org, , 1, 2015-01-05 14:05:04, 2015-01-05 14:05:04) returning \"id\")' in /app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:625\r\n2015-01-05T14:05:04.774174+00:00 app[web.1]: #28 /app/bootstrap/compiled.php(11017): Illuminate\\Cookie\\Guard->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n2015-01-05T14:05:04.774012+00:00 app[web.1]: #11 /app/bootstrap/compiled.php(6878): Illuminate\\Database\\Eloquent\\Model->insertAndSetId(Object(Illuminate\\Database\\Eloquent\\Builder), Array)\r\n2015-01-05T14:05:04.774034+00:00 app[web.1]: #22 /app/bootstrap/compiled.php(5040): Illuminate\\Routing\\Route->run(Object(Illuminate\\Http\\Request))\r\n2015-01-05T14:05:04.774151+00:00 app[web.1]: #19 /app/bootstrap/compiled.php(5373): call_user_func_array(Object(Closure), Array)\r\n2015-01-05T14:05:04.774120+00:00 app[web.1]: #4 /app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1896): Illuminate\\Database\\Query\\Processors\\PostgresProcessor->processInsertGetId(Object(Illuminate\\Database\\Query\\Builder), 'insert into \"co...', Array, 'id')\r\n2015-01-05T14:05:04.774122+00:00 app[web.1]: #5 [internal function]: Illuminate\\Database\\Query\\Builder->insertGetId(Array, 'id')\r\n2015-01-05T14:05:04.774131+00:00 app[web.1]: #9 /app/bootstrap/compiled.php(6878): Illuminate\\Database\\Eloquent\\Model->insertAndSetId(Object(Illuminate\\Database\\Eloquent\\Builder), Array)\r\n2015-01-05T14:05:04.774142+00:00 app[web.1]: #15 /app/bootstrap/compiled.php(5822): Illuminate\\Routing\\Controller->callAction('createComponent...', Array)\r\n2015-01-05T14:05:04.774153+00:00 app[web.1]: #20 /app/bootstrap/compiled.php(5040): Illuminate\\Routing\\Route->run(Object(Illuminate\\Http\\Request))\r\n2015-01-05T14:05:04.774176+00:00 app[web.1]: #29 /app/bootstrap/compiled.php(657): Stack\\StackedHttpKernel->handle(Object(Illuminate\\Http\\Request))\r\n2015-01-05T14:05:04.782753+00:00 app[web.1]: 193.49.118.103 - \"POST /dashboard/components/add HTTP/1.1\" 500 4409 \"http://spotlist-status.herokuapp.com/dashboard/components/add\" \"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36\"\r\n2015-01-05T14:05:04.774129+00:00 app[web.1]: #8 /app/bootstrap/compiled.php(6888): Illuminate\\Database\\Eloquent\\Builder->insertGetId(Array, 'id')\r\n2015-01-05T14:05:04.774137+00:00 app[web.1]: #12 /app/src/Http/Controllers/DashComponentController.php(128): Illuminate\\Database\\Eloquent\\Model::create(Array)\r\n2015-01-05T14:05:04.774149+00:00 app[web.1]: #18 [internal function]: Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()\r\n2015-01-05T14:05:04.774158+00:00 app[web.1]: #23 /app/bootstrap/compiled.php(715): Dingo\\Api\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\r\n2015-01-05T14:05:04.774166+00:00 app[web.1]: #24 /app/bootstrap/compiled.php(696): Illuminate\\Foundation\\Application->dispatch(Object(Illuminate\\Http\\Request))\r\n2015-01-05T14:05:04.774170+00:00 app[web.1]: #26 /app/bootstrap/compiled.php(8407): Illuminate\\Session\\Middleware->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n2015-01-05T14:05:04.774172+00:00 app[web.1]: #27 /app/bootstrap/compiled.php(8354): Illuminate\\Cookie\\Queue->handle(Object(Illuminate\\Http\\Request), 1, true)\r\n2015-01-05T14:05:04.774140+00:00 app[web.1]: #14 /app/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(231): call_user_func_array(Array, Array)\r\n2015-01-05T14:05:04.774139+00:00 app[web.1]: #13 [internal function]: CachetHQ\\Cachet\\Http\\Controllers\\DashComponentController->createComponentAction()\r\n```\r\n\r\nI filled in:\r\n\r\n![screen shot 2015-01-05 at 15 06 11](https://cloud.githubusercontent.com/assets/217628/5614009/6aaa7f86-94ec-11e4-81be-9314083c23f2.png)\r\n"},"comment":{"url":"https://api.github.com/repos/cachethq/Cachet/issues/comments/68721925","html_url":"https://github.com/cachethq/Cachet/issues/287#issuecomment-68721925","issue_url":"https://api.github.com/repos/cachethq/Cachet/issues/287","id":68721925,"user":{"login":"GrahamCampbell","id":2829600,"avatar_url":"https://avatars.githubusercontent.com/u/2829600?v=3","gravatar_id":"","url":"https://api.github.com/users/GrahamCampbell","html_url":"https://github.com/GrahamCampbell","followers_url":"https://api.github.com/users/GrahamCampbell/followers","following_url":"https://api.github.com/users/GrahamCampbell/following{/other_user}","gists_url":"https://api.github.com/users/GrahamCampbell/gists{/gist_id}","starred_url":"https://api.github.com/users/GrahamCampbell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GrahamCampbell/subscriptions","organizations_url":"https://api.github.com/users/GrahamCampbell/orgs","repos_url":"https://api.github.com/users/GrahamCampbell/repos","events_url":"https://api.github.com/users/GrahamCampbell/events{/privacy}","received_events_url":"https://api.github.com/users/GrahamCampbell/received_events","type":"User","site_admin":false},"created_at":"2015-01-05T15:20:44Z","updated_at":"2015-01-05T15:20:44Z","body":"it does, but ours isn't nullable?"}}