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