How to Update from 2 to 3

Developer help Installation
1
  • 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 SQL Query Builder for Javascript | Knex.js).

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 SQL Query Builder for Javascript | Knex.js).
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!

2

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!

3

In case anyone stumbles on this old gem here’s how I remedied in a local environment (macOS) on an old version of ghost 1

First I got

You are about to migrate to Ghost 2.0. Your blog is not on the latest Ghost 1.0 version.
Help: Instead run "ghost update --v1".

But after some fiddling it prompted me to update the cli so If you haven’t in awhile

npm install -g npm

Then

npm install -g ghost-cli@latest

And finally

ghost update

Your theme may need to be migrated but the CLI is incredibly friendly :slightly_smiling_face:

This is what I got:

⚠ Your theme has 1 error

? View error and warning details? Yes

Errors
    File: error-404.hbs
    - Replace {{error.code}} with {{error.statusCode}}

    File: error.hbs
    - Replace {{error.code}} with {{error.statusCode}}

Which can be fixed with search/replace.