{"action":"created","issue":{"url":"https://api.github.com/repos/bolt/bolt/issues/5165","repository_url":"https://api.github.com/repos/bolt/bolt","labels_url":"https://api.github.com/repos/bolt/bolt/issues/5165/labels{/name}","comments_url":"https://api.github.com/repos/bolt/bolt/issues/5165/comments","events_url":"https://api.github.com/repos/bolt/bolt/issues/5165/events","html_url":"https://github.com/bolt/bolt/issues/5165","id":147835985,"number":5165,"title":"[BUG] Not null constraint failed","user":{"login":"mattiaslundback","id":3066568,"avatar_url":"https://avatars.githubusercontent.com/u/3066568?v=3","gravatar_id":"","url":"https://api.github.com/users/mattiaslundback","html_url":"https://github.com/mattiaslundback","followers_url":"https://api.github.com/users/mattiaslundback/followers","following_url":"https://api.github.com/users/mattiaslundback/following{/other_user}","gists_url":"https://api.github.com/users/mattiaslundback/gists{/gist_id}","starred_url":"https://api.github.com/users/mattiaslundback/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mattiaslundback/subscriptions","organizations_url":"https://api.github.com/users/mattiaslundback/orgs","repos_url":"https://api.github.com/users/mattiaslundback/repos","events_url":"https://api.github.com/users/mattiaslundback/events{/privacy}","received_events_url":"https://api.github.com/users/mattiaslundback/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/bolt/bolt/labels/Bug%20verification%20needed","name":"Bug verification needed","color":"d4c5f9"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-04-12T18:31:04Z","updated_at":"2016-04-12T21:09:23Z","closed_at":null,"body":"Trying to move my old Bolt 2.2 database to Bolt 3.0 beta 2. It works, but once I try to add a new entry it breaks with the following error:\r\n\r\n\"An exception occurred while executing 'INSERT INTO bolt_entries (slug, datecreated, datechanged, datepublish, datedepublish, username, ownerid, status, templatefields, title, teaser, image, video) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\"test-1\", \"2016-04-12 20:22:40\", \"2016-04-12 20:22:40\", \"2016-04-12 20:22:30\", null, \"\", \"1\", \"published\", null, \"test\", \"<p>test<\\/p>\\r\\n\", \"[]\", \"[]\"]:\\n\r\n\\n\r\nSQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: bolt_entries.templatefields\"\r\n\r\nIt is possible to make a new page, block or something else. But not new entries. It is still possible to edit old entries.\r\n\r\nIn the old database the Schema is \"CLOB NOT NULL DEFAULT\". In the new database it is \"CLOB DEFAULT NULL\". Somehow I think this is a clue to the problem.\r\n\r\nDetails\r\n-------\r\n\r\n - Relevant Bolt Version: [3.0 beta 2]\r\n - Install type: [ Zip/tarball install]\r\n - PHP version: [ 5.59 ]\r\n - Used webserver: [ Apache ]\r\n - For UX/UI issues: [ browser name and version ]\r\n"},"comment":{"url":"https://api.github.com/repos/bolt/bolt/issues/comments/209103688","html_url":"https://github.com/bolt/bolt/issues/5165#issuecomment-209103688","issue_url":"https://api.github.com/repos/bolt/bolt/issues/5165","id":209103688,"user":{"login":"mattiaslundback","id":3066568,"avatar_url":"https://avatars.githubusercontent.com/u/3066568?v=3","gravatar_id":"","url":"https://api.github.com/users/mattiaslundback","html_url":"https://github.com/mattiaslundback","followers_url":"https://api.github.com/users/mattiaslundback/followers","following_url":"https://api.github.com/users/mattiaslundback/following{/other_user}","gists_url":"https://api.github.com/users/mattiaslundback/gists{/gist_id}","starred_url":"https://api.github.com/users/mattiaslundback/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mattiaslundback/subscriptions","organizations_url":"https://api.github.com/users/mattiaslundback/orgs","repos_url":"https://api.github.com/users/mattiaslundback/repos","events_url":"https://api.github.com/users/mattiaslundback/events{/privacy}","received_events_url":"https://api.github.com/users/mattiaslundback/received_events","type":"User","site_admin":false},"created_at":"2016-04-12T21:09:22Z","updated_at":"2016-04-12T21:09:22Z","body":"And, no. There are no indications that the database need updating when I check manually."}}