{"action":"created","issue":{"url":"https://api.github.com/repos/TryGhost/Ghost/issues/9900","repository_url":"https://api.github.com/repos/TryGhost/Ghost","labels_url":"https://api.github.com/repos/TryGhost/Ghost/issues/9900/labels{/name}","comments_url":"https://api.github.com/repos/TryGhost/Ghost/issues/9900/comments","events_url":"https://api.github.com/repos/TryGhost/Ghost/issues/9900/events","html_url":"https://github.com/TryGhost/Ghost/issues/9900","id":362782323,"node_id":"MDU6SXNzdWUzNjI3ODIzMjM=","number":9900,"title":"Error: SQLITE_ERROR: table posts has no column named comment_id","user":{"login":"pascalandy","id":6694151,"node_id":"MDQ6VXNlcjY2OTQxNTE=","avatar_url":"https://avatars1.githubusercontent.com/u/6694151?v=4","gravatar_id":"","url":"https://api.github.com/users/pascalandy","html_url":"https://github.com/pascalandy","followers_url":"https://api.github.com/users/pascalandy/followers","following_url":"https://api.github.com/users/pascalandy/following{/other_user}","gists_url":"https://api.github.com/users/pascalandy/gists{/gist_id}","starred_url":"https://api.github.com/users/pascalandy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pascalandy/subscriptions","organizations_url":"https://api.github.com/users/pascalandy/orgs","repos_url":"https://api.github.com/users/pascalandy/repos","events_url":"https://api.github.com/users/pascalandy/events{/privacy}","received_events_url":"https://api.github.com/users/pascalandy/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-09-21T21:37:29Z","updated_at":"2018-09-21T22:07:02Z","closed_at":null,"author_association":"NONE","body":"### To Reproduce\r\n\r\nHi,\r\n\r\nI manage a lot a Ghost instance in Docker. I found a random issue I'd like to share.\r\n\r\nOne website that was running smoothly for months had this error. So I thought it was a random data corruption. Shit happen.\r\n\r\nThen the issue happens again. This time, I started a new website from scratch. I rebooted the container about 8 times in 20 minutes. I didn’t touch the content or log in the admin panel. I was just looking at the logs and see if I could see any glitches.\r\n\r\nI can’t explain why this error appears the comment_id is suddenly disappearing !?\r\n\r\n```\r\nNAME: RollbackError\r\nCODE: SQLITE_ERROR\r\nError: SQLITE_ERROR: table posts has no column named comment_id\r\n```\r\n\r\nSee the [full log here](https://gist.github.com/pascalandy/8a18172090f743b46e15fbff9015f4fe).\r\n\r\n### Technical details:\r\n\r\n* Ghost Version: 2.1.1\r\n* CLI version: 1.9.4\r\n* Node Version: 8.11.4\r\n* Browser/OS: chrome 66, osx 10.13.4\r\n* Server-side: Alpine:3.8 in Docker [using this image](https://travis-ci.org/firepress-org/ghostfire/jobs/428717032)\r\n* Database: sqlite\r\n\r\nCheers!"},"comment":{"url":"https://api.github.com/repos/TryGhost/Ghost/issues/comments/423683766","html_url":"https://github.com/TryGhost/Ghost/issues/9900#issuecomment-423683766","issue_url":"https://api.github.com/repos/TryGhost/Ghost/issues/9900","id":423683766,"node_id":"MDEyOklzc3VlQ29tbWVudDQyMzY4Mzc2Ng==","user":{"login":"kirrg001","id":1160712,"node_id":"MDQ6VXNlcjExNjA3MTI=","avatar_url":"https://avatars0.githubusercontent.com/u/1160712?v=4","gravatar_id":"","url":"https://api.github.com/users/kirrg001","html_url":"https://github.com/kirrg001","followers_url":"https://api.github.com/users/kirrg001/followers","following_url":"https://api.github.com/users/kirrg001/following{/other_user}","gists_url":"https://api.github.com/users/kirrg001/gists{/gist_id}","starred_url":"https://api.github.com/users/kirrg001/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kirrg001/subscriptions","organizations_url":"https://api.github.com/users/kirrg001/orgs","repos_url":"https://api.github.com/users/kirrg001/repos","events_url":"https://api.github.com/users/kirrg001/events{/privacy}","received_events_url":"https://api.github.com/users/kirrg001/received_events","type":"User","site_admin":false},"created_at":"2018-09-21T22:07:02Z","updated_at":"2018-09-21T22:07:02Z","author_association":"CONTRIBUTOR","body":"> Error: SQLITE_ERROR: table posts has no column named comment_id\r\n\r\nThis is a migration error. Happens only if you trigger migrations or if migrations needs to be executed.\r\n\r\n> One website that was running smoothly for months had this error. So I thought it was a random data corruption. Shit happen.\r\n\r\nThis error looks like you migrated from Ghost 1.x to Ghost 2.x, but you were not on the latest Ghost 1.x release.\r\n\r\nLet me know 👍 "}}
{"actor":{"display_login":"kirrg001"}}