Ghost Error Occurred - Knex? Sqlite?

simonmc · May 26, 2020, 5:11am

Not sure what has changed with my local setup, but all three of my Ghost local installs have stopped working and I’m really struggling to get them back up and running.

ghost doctor - No errors for all installs.

This is the error I get when trying to run ‘ghost start’

    OS: Mac OS X, v10.15.4
    Node Version: v12.16.3
    Ghost Version: 3.12.1
    Ghost-CLI Version: 1.14.0
    Environment: development
    Command: 'ghost start'
Message: 
/Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/lib/client.js:225
      throw new Error(`${message}\n${e.message}`);
      ^

Error: Knex: run
$ npm install sqlite3 --save
Cannot find module '/Users/simon/Work/_Discover_/versions/3.12.1/node_modules/sqlite3/lib/binding/node-v72-darwin-x64/node_sqlite3.node'
Require stack:
- /Users/simon/Work/_Discover_/versions/3.12.1/node_modules/sqlite3/lib/sqlite3.js
- /Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/lib/dialects/sqlite3/index.js
- /Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/lib/knex.js
- /Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/lib/index.js
- /Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/knex.js
- /Users/simon/Work/_Discover_/versions/3.12.1/core/server/data/db/connection.js
- /Users/simon/Work/_Discover_/versions/3.12.1/core/server/index.js
- /Users/simon/Work/_Discover_/versions/3.12.1/core/index.js
- /Users/simon/Work/_Discover_/versions/3.12.1/index.js
    at Client_SQLite3.initializeDriver (/Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/lib/client.js:225:13)
    at Client_SQLite3.Client (/Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/lib/client.js:59:10)
    at new Client_SQLite3 (/Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/lib/dialects/sqlite3/index.js:18:10)
    at Knex (/Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/lib/knex.js:52:28)
    at Object.<anonymous> (/Users/simon/Work/_Discover_/versions/3.12.1/core/server/data/db/connection.js:33:20)
    at Module._compile (internal/modules/cjs/loader.js:1133:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1153:10)
    at Module.load (internal/modules/cjs/loader.js:977:32)
    at Function.Module._load (internal/modules/cjs/loader.js:877:14)
    at Module.require (internal/modules/cjs/loader.js:1019:19)
    at require (internal/modules/cjs/helpers.js:77:18)
    at isDatabaseInitialisationRequired (/Users/simon/Work/_Discover_/versions/3.12.1/core/server/index.js:164:16)
    at makeGhost (/Users/simon/Work/_Discover_/versions/3.12.1/core/index.js:13:12)
    at Object.<anonymous> (/Users/simon/Work/_Discover_/versions/3.12.1/index.js:23:1)
    at Module._compile (internal/modules/cjs/loader.js:1133:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1153:10)
    at Module.load (internal/modules/cjs/loader.js:977:32)
    at Function.Module._load (internal/modules/cjs/loader.js:877:14)
    at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)
    at internal/main/run_main_module.js:18:47

Stack: Error: 
/Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/lib/client.js:225
      throw new Error(`${message}\n${e.message}`);
      ^

Error: Knex: run
$ npm install sqlite3 --save
Cannot find module '/Users/simon/Work/_Discover_/versions/3.12.1/node_modules/sqlite3/lib/binding/node-v72-darwin-x64/node_sqlite3.node'
Require stack:
- /Users/simon/Work/_Discover_/versions/3.12.1/node_modules/sqlite3/lib/sqlite3.js
- /Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/lib/dialects/sqlite3/index.js
- /Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/lib/knex.js
- /Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/lib/index.js
- /Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/knex.js
- /Users/simon/Work/_Discover_/versions/3.12.1/core/server/data/db/connection.js
- /Users/simon/Work/_Discover_/versions/3.12.1/core/server/index.js
- /Users/simon/Work/_Discover_/versions/3.12.1/core/index.js
- /Users/simon/Work/_Discover_/versions/3.12.1/index.js
    at Client_SQLite3.initializeDriver (/Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/lib/client.js:225:13)
    at Client_SQLite3.Client (/Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/lib/client.js:59:10)
    at new Client_SQLite3 (/Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/lib/dialects/sqlite3/index.js:18:10)
    at Knex (/Users/simon/Work/_Discover_/versions/3.12.1/node_modules/knex/lib/knex.js:52:28)
    at Object.<anonymous> (/Users/simon/Work/_Discover_/versions/3.12.1/core/server/data/db/connection.js:33:20)
    at Module._compile (internal/modules/cjs/loader.js:1133:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1153:10)
    at Module.load (internal/modules/cjs/loader.js:977:32)
    at Function.Module._load (internal/modules/cjs/loader.js:877:14)
    at Module.require (internal/modules/cjs/loader.js:1019:19)
    at require (internal/modules/cjs/helpers.js:77:18)
    at isDatabaseInitialisationRequired (/Users/simon/Work/_Discover_/versions/3.12.1/core/server/index.js:164:16)
    at makeGhost (/Users/simon/Work/_Discover_/versions/3.12.1/core/index.js:13:12)
    at Object.<anonymous> (/Users/simon/Work/_Discover_/versions/3.12.1/index.js:23:1)
    at Module._compile (internal/modules/cjs/loader.js:1133:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1153:10)
    at Module.load (internal/modules/cjs/loader.js:977:32)
    at Function.Module._load (internal/modules/cjs/loader.js:877:14)
    at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)
    at internal/main/run_main_module.js:18:47

    at ChildProcess.<anonymous> (/usr/local/lib/node_modules/ghost-cli/lib/utils/local-process.js:65:35)
    at ChildProcess.emit (events.js:310:20)
    at Process.ChildProcess._handle.onexit (internal/child_process.js:275:12)

Any advice for debugging would be greatly appreciated

I have installed a new local installation using the following code and it all works fine so not sure why all the old ones are busted?:

vikaspotluri123 · May 26, 2020, 5:26am

Hey @simonmc

Thanks for posting the debug info! It looks like Ghost is having trouble finding the sqlite library to interact with your database. Can you try running ghost buster to clear the module cache, and then ghost update 3.12.1 --force to reinstall this version of ghost?

simonmc · May 26, 2020, 5:59am

You are a legend @vikaspotluri123 ! Thanks.
The ghost update worked a treat on all installs.

Hannah · May 26, 2020, 11:24am

@simonmc did you upgrade your Node.js version? If you do that, you have to run the commands @vikaspotluri123 gave you afterwards.

Ghost uses binary modules compiled against the node version, so if you upgrade node they need to be reinstalled.

vikaspotluri123 · May 26, 2020, 4:27pm

The CLI should detect if the node version changes and prompt you to fix it - here’s the error it will output:

simonmc · May 26, 2020, 11:22pm

That was exactly what I’d done. Thanks for the tip!

simonmc · May 26, 2020, 11:23pm

Thanks for your help!

Hannah · May 27, 2020, 7:28am

Hey @simonmc if you have a moment could you share the exact details of how you have Node installed and how you updated Node?

Ghost-CLI should give you a specific error if the binary dependencies need reinstalling, as shown above so we’d love to create a full reproduction case to get this fixed.

Your help would make it possible for us to fix this right away.

Thanks!

Praveen_Angyan · November 8, 2020, 8:31am

I had the same issue. Basically I installed ghost-cli, it warned me that my node version was not supported. I upgraded node and then got this same error. I did not receive a warning that the binaries needed to be upgraded.

I think this was the only troubleshooting step I had to take in what was otherwise a very smooth installation.

Praveen_Angyan · November 11, 2020, 12:52am

I installed a brand new Ubuntu (20.02) installation using WSL 2 for Windows.
I installed node:
curl -sL https://deb.nodesource.com/setup_15.x | sudo -E bash -
sudo apt-get install -y nodejs
Then I installed Ghost CLI:
npm install ghost-cli@latest -g
Then I tried to install Ghost:
ghost install local
I got an error that node 15.x is not supported
I installed nvm next
curl -o- https://raw.githubusercontent.com/nvm-sh/nvm/v0.37.0/install.sh | bash
I installed node v14.15.0
nvm install 14.15.0
I then tried to install ghost again
ghost install local

That’s when I got the crash message. There was no mention of binaries.

9. I had to run npm install sqlite3 --save and then everything worked.

whollacsek · November 24, 2020, 12:01pm

I have the same issue with the same steps as you

Topic		Replies	Views
Can't start Ghost locally - cannot find module 'sqlite3' Installation	4	1287	September 15, 2022
Please help me...how can I solved this Installation	5	779	January 30, 2021
Cannot install Ghost due to SQlite3 error Developer help	6	732	April 21, 2022
Sql - Sqlite3 error - Unable to rub Ghost locally Installation	1	755	April 17, 2021
Ghost local installation fail because of SQlite3 Installation	7	1625	April 23, 2022

Ghost Error Occurred - Knex? Sqlite?

Any advice for debugging would be greatly appreciated

Related topics