{"action":"created","issue":{"url":"https://api.github.com/repos/robmorgan/phinx/issues/902","repository_url":"https://api.github.com/repos/robmorgan/phinx","labels_url":"https://api.github.com/repos/robmorgan/phinx/issues/902/labels{/name}","comments_url":"https://api.github.com/repos/robmorgan/phinx/issues/902/comments","events_url":"https://api.github.com/repos/robmorgan/phinx/issues/902/events","html_url":"https://github.com/robmorgan/phinx/issues/902","id":165453421,"number":902,"title":"Datatype mismatch: 7 ERROR:  column \"breakpoint\" is of type boolean but expression is of type integer  ","user":{"login":"mkoula","id":1447985,"avatar_url":"https://avatars.githubusercontent.com/u/1447985?v=3","gravatar_id":"","url":"https://api.github.com/users/mkoula","html_url":"https://github.com/mkoula","followers_url":"https://api.github.com/users/mkoula/followers","following_url":"https://api.github.com/users/mkoula/following{/other_user}","gists_url":"https://api.github.com/users/mkoula/gists{/gist_id}","starred_url":"https://api.github.com/users/mkoula/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mkoula/subscriptions","organizations_url":"https://api.github.com/users/mkoula/orgs","repos_url":"https://api.github.com/users/mkoula/repos","events_url":"https://api.github.com/users/mkoula/events{/privacy}","received_events_url":"https://api.github.com/users/mkoula/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-07-14T00:48:34Z","updated_at":"2016-07-14T23:08:54Z","closed_at":"2016-07-14T17:54:31Z","body":"I am using PostgeSQL and after running commands migrate|status I am getting this error:\r\n`[PDOException]                                                                                                          \r\n  SQLSTATE[42804]: Datatype mismatch: 7 ERROR:  column \"breakpoint\" is of type boolean but expression is of type integer  \r\n  LINE 1: ...tructure', '2016-07-14 02:42:52', '2016-07-14 02:42:52', 0);                                                 \r\n                                                                      ^                                                   \r\n  HINT:  You will need to rewrite or cast the expression.                                                                 \r\n`\r\n\r\nI tried to create new database and run init there and the migrations table has a new column breakpoint of type bool, the old one doesn't, so it's probably connected to some internal phinx upgrade...\r\n\r\n![screen shot 2016-07-14 at 02 51 46](https://cloud.githubusercontent.com/assets/1447985/16824684/0c70fc5a-496e-11e6-86d5-d4adc79cba8a.png)\r\n"},"comment":{"url":"https://api.github.com/repos/robmorgan/phinx/issues/comments/232818421","html_url":"https://github.com/robmorgan/phinx/issues/902#issuecomment-232818421","issue_url":"https://api.github.com/repos/robmorgan/phinx/issues/902","id":232818421,"user":{"login":"mkoula","id":1447985,"avatar_url":"https://avatars.githubusercontent.com/u/1447985?v=3","gravatar_id":"","url":"https://api.github.com/users/mkoula","html_url":"https://github.com/mkoula","followers_url":"https://api.github.com/users/mkoula/followers","following_url":"https://api.github.com/users/mkoula/following{/other_user}","gists_url":"https://api.github.com/users/mkoula/gists{/gist_id}","starred_url":"https://api.github.com/users/mkoula/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mkoula/subscriptions","organizations_url":"https://api.github.com/users/mkoula/orgs","repos_url":"https://api.github.com/users/mkoula/repos","events_url":"https://api.github.com/users/mkoula/events{/privacy}","received_events_url":"https://api.github.com/users/mkoula/received_events","type":"User","site_admin":false},"created_at":"2016-07-14T23:08:54Z","updated_at":"2016-07-14T23:08:54Z","body":"No idea how much work it is. The problem is that the issue is not reported anywhere. I have been searching first and I could not find any resource, especially the error message is not super clear, after I played with the empty database and I saw 'breakpoint' in migration table I realised that will be connected. Nothing on stackoverlow etc. That's why I finally used github... So for other users could be a 👍 "}}
{"actor":{"display_login":"mkoula"}}