Unable to install Ghost Locall on Windows 10

I can’t install a new Ghost instance on Windows 10, this is the output:

ghost install local
√ Checking system Node.js version
√ Checking current folder permissions
√ Checking memory availability
√ Checking free space
√ Checking for latest Ghost version
√ Setting up install directory
√ Downloading and installing Ghost v3.39.3
√ Finishing install process
√ Configuring Ghost
√ Setting up instance
× Starting Ghost
One or more errors occurred.

1) GhostError

Message:
C:\Users\example\example\versions\3.39.3\node_modules\knex\lib\client.js:235
      throw new Error(`${message}\n${e.message}`);
      ^

Error: Knex: run
$ npm install sqlite3 --save
Cannot find module 'sqlite3'
Require stack:
- C:\Users\example\example\versions\3.39.3\node_modules\knex\lib\dialects\sqlite3\index.js
- C:\Users\example\example\versions\3.39.3\node_modules\knex\lib\knex.js
- C:\Users\example\example\versions\3.39.3\node_modules\knex\lib\index.js
- C:\Users\example\example\versions\3.39.3\node_modules\knex\knex.js
- C:\Users\example\example\versions\3.39.3\core\server\data\db\connection.js
- C:\Users\example\example\versions\3.39.3\core\server\index.js
- C:\Users\example\example\versions\3.39.3\core\index.js
- C:\Users\example\example\versions\3.39.3\index.js
    at Client_SQLite3.initializeDriver (C:\Users\example\example\versions\3.39.3\node_modules\knex\lib\client.js:235:13)
    at Client_SQLite3.Client (C:\Users\example\example\versions\3.39.3\node_modules\knex\lib\client.js:69:10)
    at new Client_SQLite3 (C:\Users\example\example\versions\3.39.3\node_modules\knex\lib\dialects\sqlite3\index.js:17:10)
    at Knex (C:\Users\example\example\versions\3.39.3\node_modules\knex\lib\knex.js:53:28)
    at Object.<anonymous> (C:\Users\example\example\versions\3.39.3\core\server\data\db\connection.js:34:20)
    at Module._compile (internal/modules/cjs/loader.js:1063:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1092:10)
    at Module.load (internal/modules/cjs/loader.js:928:32)
    at Function.Module._load (internal/modules/cjs/loader.js:769:14)
    at Module.require (internal/modules/cjs/loader.js:952:19)
    at require (internal/modules/cjs/helpers.js:88:18)
    at isDatabaseInitialisationRequired (C:\Users\example\example\versions\3.39.3\core\server\index.js:187:16)
    at makeGhost (C:\Users\example\example\versions\3.39.3\core\index.js:13:12)
    at Object.<anonymous> (C:\Users\example\example\versions\3.39.3\index.js:27:1)
    at Module._compile (internal/modules/cjs/loader.js:1063:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1092:10)


Debug Information:
    OS: Microsoft Windows 10 Pro, v10.0.19042
    Node Version: v14.15.1
    Ghost Version: 3.39.3
    Ghost-CLI Version: 1.15.2
    Environment: development
    Command: 'ghost install local'

Additional log info available in: C:\Users\example\.ghost\logs\ghost-cli-debug-2020-12-08T11_29_34_603Z.log

Try running ghost doctor to check your system for known issues.

You can always refer to https://ghost.org/docs/api/ghost-cli/ for troubleshooting.

C:\Users\example\example>ghost doctor
Found a development config but not a production config, running in development mode instead
√ Checking system Node.js version
√ Checking current folder permissions
√ Validating config
√ Checking memory availability
√ Checking binary dependencies
√ Checking free space

C:\Users\example\example>ghost install local
A SystemError occurred.

...

to fix it:

npm install sqlite3 --save

@giacomosilli I also had same problem and I used that command but the problem is it worked for 10 min perfect after that It is stopping on its own and I need to install that command everytime is there any solution???
Or else [I installed that command in ghost directory…should I install it in other place??]

i don’t know, after i gave that command from me it works fine, i don’t have to repeat it every time. Better to wait for feedback from the staff

i used the command npm install sqlite3 --save but while processing python modify setup window pop up and on selecting modify or replace or cancel it gives me error and im stuck on this loop
PS E:\bwinner\website> npm install sqlite3 --save
npm WARN deprecated request@2.88.2: request has been deprecated, see https://github.com/request/request/issues/3142
npm WARN deprecated har-validator@5.1.5: this library is no longer supported

sqlite3@5.0.1 install E:\bwinner\website\node_modules\sqlite3
node-pre-gyp install --fallback-to-build

node-pre-gyp WARN Using request for node-pre-gyp https download
node-pre-gyp WARN Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v5.0.1/napi-v6-win32-x64.tar.gz
node-pre-gyp WARN Pre-built binaries not found for sqlite3@5.0.1 and node@14.15.3 (node-v83 ABI, unknown) (falling back to source compile with node-gyp)
Building the projects in this solution one at a time. To enable parallel build, please add the “-m” switch.
nothing.c
win_delay_load_hook.cc
nothing.vcxproj -> E:\bwinner\website\node_modules\sqlite3\build\Release\nothing.lib
unpack_sqlite_dep
C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\MSBuild\Microsoft\VC\v160\Microsoft.CppCommon.targets(238,5): warning MSB8065: Custom build for item “…\deps\sqlite-autoconf-3320300.tar.gz” s
ucceeded, but specified output “e:\bwinner\website\node_modules\sqlite3\build\release\obj\global_intermediate\sqlite-autoconf-3320300\sqlite3.c” has not been created. This may cause incremental build to work
incorrectly. [E:\bwinner\website\node_modules\sqlite3\build\deps\action_before_build.vcxproj]
sqlite3.c
c1 : fatal error C1083: Cannot open source file: ‘E:\bwinner\website\node_modules\sqlite3\build\Release\obj\global_intermediate\sqlite-autoconf-3320300\sqlite3.c’: No such file or directory [E:\bwinner\websit
e\node_modules\sqlite3\build\deps\sqlite3.vcxproj]
gyp ERR! build error
gyp ERR! stack Error: C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\MSBuild\Current\Bin\MSBuild.exe failed with exit code: 1
gyp ERR! stack at ChildProcess.onExit (C:\Users\vibha\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\build.js:194:23)
gyp ERR! stack at ChildProcess.emit (events.js:315:20)
gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:277:12)
gyp ERR! System Windows_NT 10.0.19042
gyp ERR! command “C:\Program Files\nodejs\node.exe” “C:\Users\vibha\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js” “build” “–fallback-to-build” “–module=E:\bwinner\website\node_modules\sqlite3\lib\binding\napi-v6-win32-x64\node_sqlite3.node” “–module_name=node_sqlite3” “–module_path=E:\bwinner\website\node_modules\sqlite3\lib\binding\napi-v6-win32-x64” “–napi_version=7” “–node_abi_napi=napi” “–napi_build_version=6” “–node_napi_label=napi-v6”
gyp ERR! cwd E:\bwinner\website\node_modules\sqlite3
gyp ERR! node -v v14.15.3
gyp ERR! node-gyp -v v5.1.0
gyp ERR! not ok
node-pre-gyp ERR! build error
node-pre-gyp ERR! stack Error: Failed to execute ‘C:\Program Files\nodejs\node.exe C:\Users\vibha\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js build --fallback-to-build --module=E:\bwinner\website\node_modules\sqlite3\lib\binding\napi-v6-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=E:\bwinner\website\node_modules\sqlite3\lib\binding\napi-v6-win32-x64 --napi_version=7 --node_abi_napi=napi --napi_build_version=6 --node_napi_label=napi-v6’ (1)
node-pre-gyp ERR! stack at ChildProcess. (E:\bwinner\website\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
node-pre-gyp ERR! stack at ChildProcess.emit (events.js:315:20)
node-pre-gyp ERR! stack at maybeClose (internal/child_process.js:1048:16)
node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:288:5)
node-pre-gyp ERR! System Windows_NT 10.0.19042
node-pre-gyp ERR! command “C:\Program Files\nodejs\node.exe” “E:\bwinner\website\node_modules\node-pre-gyp\bin\node-pre-gyp” “install” “–fallback-to-build”
node-pre-gyp ERR! cwd E:\bwinner\website\node_modules\sqlite3
node-pre-gyp ERR! node -v v14.15.3
node-pre-gyp ERR! node-pre-gyp -v v0.11.0
node-pre-gyp ERR! not ok
Failed to execute ‘C:\Program Files\nodejs\node.exe C:\Users\vibha\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js build --fallback-to-build --module=E:\bwinner\website\node_modules\sqlite3\lib\binding\napi-v6-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=E:\bwinner\website\node_modules\sqlite3\lib\binding\napi-v6-win32-x64 --napi_version=7 --node_abi_napi=napi --napi_build_version=6 --node_napi_label=napi-v6’ (1)
npm WARN enoent ENOENT: no such file or directory, open ‘E:\bwinner\website\package.json’
npm WARN website No description
npm WARN website No repository field.
npm WARN website No README data
npm WARN website No license field.

npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! sqlite3@5.0.1 install: node-pre-gyp install --fallback-to-build
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the sqlite3@5.0.1 install script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR! C:\Users\vibha\AppData\Roaming\npm-cache_logs\2021-01-13T17_20_44_694Z-debug.log

try this:

npm install sqlite3 --build-from-source

if that still doesn’t work:

npm install --global --production windows-build-tools
npm install -g node-gyp
npm install sqlite3 --save

I’m having the exact same issue as above and this did unfortunately not work for me.

have you tried to open powershell as administrator? after executing those commands, close and reopen the terminal, and try again