Ghost: Error: SQLITE_ERROR: table posts has no column named comment_id

To Reproduce

Hi,

I manage a lot a Ghost instance in Docker. I found a random issue I’d like to share.

One website that was running smoothly for months had this error. So I thought it was a random data corruption. Shit happen.

Then 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.

I can’t explain why this error appears the comment_id is suddenly disappearing !?

NAME: RollbackError
CODE: SQLITE_ERROR
Error: SQLITE_ERROR: table posts has no column named comment_id

See the full log here.

Technical details:

Ghost Version: 2.1.1
CLI version: 1.9.4
Node Version: 8.11.4
Browser/OS: chrome 66, osx 10.13.4
Server-side: Alpine:3.8 in Docker using this image
Database: sqlite

Cheers!

About this issue

Original URL
State: closed
Created 6 years ago
Comments: 28 (14 by maintainers)

Most upvoted comments

@pascalandy urgh frustrating 😦 Would love to help, but not sure how!

kirrg001 on Oct 25, 2018

I didn’t had the issue since. I’ll close this for the moment. Thank you for caring 😃

pascalandy on Oct 2, 2018

I did the same process using Ghost 2.1.3. It’s all good now. My guess is that v2.1.1 had some bug triggering the migration process.

Step to reproduce:

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.

I’ll close this issue. Thanks!

pascalandy on Sep 22, 2018