How to Update from 2 to 3

  • What’s your URL? This is the easiest way for others to debug your issue
    localhost
  • What version of Ghost are you using?
    from 2.13.2 -> 3.1.0
  • What configuration?
    dev
  • What browser?
    chrome
  • What errors or information do you see in the console?
    Message: sqlite does not support inserting default values. Specify values explicitly or use the useNullAsDefault config flag. (see docs http://knexjs.org/#Builder-insert).

Help: Error occurred while executing the following migration: 05-populate-posts-meta-table.js

  • What steps could someone else take to reproduce the issue you’re having?

Hello guys!
What I have:
*Ghost local
*Ghost on Server (test-server)
*Ghost on Server2 (live - production-server)
(both ubuntu, mysql, nginx)

I wish to UPDATE Ghost from Version 2 to Version 3.
I tried with my local server, but i got instant an error message.
I used -> ghost update 3.1.0 in the console -> something happend, but finally i got a error message something like: Your are not using a compatiple ghost theme. -> Do you want change back to v2.13.2 -> I confirmed.

But i doenst work.

When I use: ghost start (ghost ls shows me =>v3.1.0 /1)

:heavy_check_mark: Checking current folder permissions
:heavy_check_mark: Validating config
:heavy_check_mark: Checking memory availability
:heavy_check_mark: Checking binary dependencies
:heavy_multiplication_x: Starting Ghost: ghost-local-8
A GhostError occurred.

Message: sqlite does not support inserting default values. Specify values explicitly or use the useNullAsDefault config flag. (see docs http://knexjs.org/#Builder-insert).
Help: Error occurred while executing the following migration: 05-populate-posts-meta-table.js

Debug Information:
OS: Mac OS X, v10.14.1
Node Version: v10.13.0
Ghost Version: 3.1.1
Ghost-CLI Version: 1.13.1
Environment: development
Command: ‘ghost start’

log: Debug Information:
OS: Mac OS X, v10.14.1
Node Version: v10.13.0
Ghost Version: 3.1.1
Ghost-CLI Version: 1.13.1
Environment: development
Command: ‘ghost start’
Message: sqlite does not support inserting default values. Specify values explicitly or use the useNullAsDefault config flag. (see docs http$
Help: Error occurred while executing the following migration: 05-populate-posts-meta-table.js
Stack: Error: sqlite does not support inserting default values. Specify values explicitly or use the useNullAsDefault config flag. (see docs$
at ChildProcess.cp.on (/usr/local/lib/node_modules/ghost-cli/lib/utils/local-process.js:63:35)
at ChildProcess.emit (events.js:182:13)
at emit (internal/child_process.js:812:12)
at process._tickCallback (internal/process/next_tick.js:63:19)

I do not understad the error message. Is sqlite not supportet in the new version? (my server using mysql)

I would be very happy, if anyboy could help!
thanks!

Hey guys,

I tried “ghost update --force” on my local maschine. = Same error.
I reinstall a new version of ghost. works great!

on my ubuntu server: Just tried “ghost update” on it works great!
maybe important: before I updated I reset the theme to the casper default theme.

sorry for my bad english! I will work on it!