Node-sqlite installation issue

0 verbose cli [
0 verbose cli 'C:\Program Files\nodejs\node.exe',
0 verbose cli 'C:\Users\user\AppData\Roaming\npm\node_modules\npm\bin\npm-cli.js',
0 verbose cli 'install',
0 verbose cli 'node-red-node-sqlite'
0 verbose cli ]
1 info using npm@7.7.5
2 info using node@v14.4.0
3 timing npm:load:whichnode Completed in 2ms
4 timing config:load:defaults Completed in 2ms
5 timing config:load:file:C:\Users\user\AppData\Roaming\npm\node_modules\npm\npmrc Completed in 3ms
6 timing config:load:builtin Completed in 3ms
7 timing config:load:cli Completed in 2ms
8 timing config:load:env Completed in 0ms
9 timing config:load:project Completed in 1ms
10 timing config:load:file:C:\Users\user.npmrc Completed in 1ms
11 timing config:load:user Completed in 1ms
12 timing config:load:file:C:\Users\user\AppData\Roaming\npm\etc\npmrc Completed in 0ms
13 timing config:load:global Completed in 0ms
14 timing config:load:validate Completed in 0ms
15 timing config:load:setEnvs Completed in 1ms
16 timing config:load Completed in 11ms
17 timing npm:load:configload Completed in 11ms
18 timing npm:load:setTitle Completed in 0ms
19 timing npm:load:setupLog Completed in 3ms
20 timing npm:load:cleanupLog Completed in 4ms
21 timing npm:load:configScope Completed in 0ms
22 timing npm:load:projectScope Completed in 1ms
23 timing npm:load Completed in 22ms
24 timing config:load:flatten Completed in 4ms
25 timing arborist:ctor Completed in 0ms
26 timing idealTree:init Completed in 163ms
27 timing idealTree:userRequests Completed in 1ms
28 silly idealTree buildDeps
29 silly fetch manifest node-red-node-sqlite@*
30 timing arborist:ctor Completed in 0ms
31 http fetch GET 304 https://registry.npmjs.org/node-red-node-sqlite 606ms (from cache)
32 silly placeDep ROOT node-red-node-sqlite@0.6.0 OK for: want: *
33 silly fetch manifest sqlite3@~4.2.0
34 http fetch GET 304 https://registry.npmjs.org/sqlite3 142ms (from cache)
35 timing idealTree:#root Completed in 759ms
36 silly placeDep node_modules/node-red-node-sqlite sqlite3@4.2.0 OK for: node-red-node-sqlite@0.6.0 want: ~4.2.0
37 silly fetch manifest nan@^2.12.1
38 silly fetch manifest node-pre-gyp@^0.11.0
39 http fetch GET 200 https://registry.npmjs.org/nan 202ms
40 http fetch GET 304 https://registry.npmjs.org/node-pre-gyp 367ms (from cache)
41 timing idealTree:node_modules/node-red-node-sqlite Completed in 389ms
42 silly placeDep ROOT nan@2.14.2 OK for: sqlite3@4.2.0 want: ^2.12.1
43 silly placeDep ROOT node-pre-gyp@0.11.0 OK for: sqlite3@4.2.0 want: ^0.11.0
44 silly fetch manifest nopt@^4.0.1
45 http fetch GET 200 https://registry.npmjs.org/nopt 10ms (from cache)
46 timing idealTree:node_modules/node-red-node-sqlite/node_modules/sqlite3 Completed in 27ms
47 timing idealTree:node_modules/nan Completed in 0ms
48 silly placeDep ROOT nopt@4.0.3 OK for: node-pre-gyp@0.11.0 want: ^4.0.1
49 timing idealTree:node_modules/node-pre-gyp Completed in 2ms
50 timing idealTree:node_modules/nopt Completed in 0ms
51 timing idealTree:buildDeps Completed in 1180ms
52 timing idealTree:fixDepFlags Completed in 6ms
53 timing idealTree Completed in 1354ms
54 timing reify:loadTrees Completed in 1356ms
55 silly reify mark deleted [
55 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\node-pre-gyp',
55 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\node-pre-gyp',
55 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\node-pre-gyp.cmd',
55 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\node-pre-gyp.ps1'
55 silly reify ]
56 silly reify mark deleted [
56 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\nopt',
56 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\nopt',
56 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\nopt.cmd',
56 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\nopt.ps1'
56 silly reify ]
57 timing reify:diffTrees Completed in 22ms
58 silly reify mark retired [
58 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\node-pre-gyp',
58 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\node-pre-gyp',
58 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\node-pre-gyp.cmd',
58 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\node-pre-gyp.ps1'
58 silly reify ]
59 silly reify mark retired [
59 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\nopt',
59 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\nopt',
59 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\nopt.cmd',
59 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\nopt.ps1'
59 silly reify ]
60 silly reify moves {
60 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\node-pre-gyp': 'C:\Users\user\node_modules\sqlite3\node_modules\.node-pre-gyp-8MRd6TOZ',
60 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\node-pre-gyp': 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\.node-pre-gyp-7fHVPUJL',
60 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\node-pre-gyp.cmd': 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\.node-pre-gyp.cmd-pETFo1el',
60 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\node-pre-gyp.ps1': 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\.node-pre-gyp.ps1-JuATphR3',
60 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\nopt': 'C:\Users\user\node_modules\sqlite3\node_modules\.nopt-p5Hypyr7',
60 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\nopt': 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\.nopt-C3KLGhSa',
60 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\nopt.cmd': 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\.nopt.cmd-XY3i4QvG',
60 silly reify 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\nopt.ps1': 'C:\Users\user\node_modules\sqlite3\node_modules\.bin\.nopt.ps1-ykCHTgua'
60 silly reify }
61 timing reify:retireShallow Completed in 16ms
62 timing reify:createSparse Completed in 5ms
63 timing reify:loadBundles Completed in 0ms
64 silly tarball no local data for nan@https://registry.npmjs.org/nan/-/nan-2.14.2.tgz. Extracting by manifest.
65 timing reifyNode:node_modules/nopt Completed in 164ms
66 timing reifyNode:node_modules/node-red-node-sqlite Completed in 191ms
67 warn deprecated node-pre-gyp@0.11.0: Please upgrade to @mapbox/node-pre-gyp: the non-scoped node-pre-gyp package is deprecated and only the @mapbox scoped package will recieve updates in the future
68 timing reifyNode:node_modules/node-pre-gyp Completed in 262ms
69 http fetch GET 200 https://registry.npmjs.org/nan/-/nan-2.14.2.tgz 407ms
70 timing reifyNode:node_modules/nan Completed in 426ms
71 timing reifyNode:node_modules/node-red-node-sqlite/node_modules/sqlite3 Completed in 435ms
72 timing reify:unpack Completed in 436ms
73 timing reify:unretire Completed in 1ms
74 timing build:queue Completed in 4ms
75 timing build:link:node_modules/nopt Completed in 15ms
76 timing build:link:node_modules/node-pre-gyp Completed in 17ms
77 timing build:link Completed in 17ms
78 info run sqlite3@4.2.0 install node_modules/node-red-node-sqlite/node_modules/sqlite3 node-pre-gyp install --fallback-to-build
79 http fetch POST 200 https://registry.npmjs.org/-/npm/v1/security/advisories/bulk 877ms
80 timing auditReport:getReport Completed in 880ms
81 timing auditReport:init Completed in 0ms
82 timing reify:audit Completed in 881ms
83 info run sqlite3@4.2.0 install { code: 1, signal: null }
84 timing reify:rollback:createSparse Completed in 98ms
85 timing reify:rollback:retireShallow Completed in 9ms
86 timing command:install Completed in 12104ms
87 verbose stack Error: command failed
87 verbose stack at ChildProcess. (C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules@npmcli\promise-spawn\index.js:64:27)
87 verbose stack at ChildProcess.emit (events.js:315:20)
87 verbose stack at maybeClose (internal/child_process.js:1051:16)
87 verbose stack at Process.ChildProcess._handle.onexit (internal/child_process.js:287:5)
88 verbose pkgid sqlite3@4.2.0
89 verbose cwd C:\Users\user
90 verbose Windows_NT 10.0.18363
91 verbose argv "C:\Program Files\nodejs\node.exe" "C:\Users\user\AppData\Roaming\npm\node_modules\npm\bin\npm-cli.js" "install" "node-red-node-sqlite"
92 verbose node v14.4.0
93 verbose npm v7.7.5
94 error code 1
95 error path C:\Users\user\node_modules\node-red-node-sqlite\node_modules\sqlite3
96 error command failed
97 error command C:\Windows\system32\cmd.exe /d /s /c node-pre-gyp install --fallback-to-build
98 error Building the projects in this solution one at a time. To enable parallel build, please add the "/m" switch.
98 error unpack_sqlite_dep
98 error Python was not found; run without arguments to install from the Microsoft Store, or disable this shortcut from Settings > Manage App Execution Aliases.
98 error C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\VC\VCTargets\Microsoft.CppCommon.targets(209,5): error MSB6006: "cmd.exe" exited with code 9009. [C:\Users\user\node_modules\node-red-node-sqlite\node_modules\sqlite3\build\deps\action_before_build.vcxproj]
98 error Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js build --fallback-to-build --module=C:\Users\user\node_modules\node-red-node-sqlite\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\user\node_modules\node-red-node-sqlite\node_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi_version=6 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v83' (1)
99 error node-pre-gyp info it worked if it ends with ok
99 error node-pre-gyp info using node-pre-gyp@0.11.0
99 error node-pre-gyp info using node@14.4.0 | win32 | x64
99 error node-pre-gyp WARN Using request for node-pre-gyp https download
99 error node-pre-gyp info check checked for "C:\Users\user\node_modules\node-red-node-sqlite\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node" (not found)
99 error node-pre-gyp http GET https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz
99 error node-pre-gyp http 403 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz
99 error node-pre-gyp WARN Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz
99 error node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@14.4.0 (node-v83 ABI, unknown) (falling back to source compile with node-gyp)
99 error node-pre-gyp http 403 status code downloading tarball https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz
99 error gyp info it worked if it ends with ok
99 error gyp info using node-gyp@7.1.2
99 error gyp info using node@14.4.0 | win32 | x64
99 error gyp info ok
99 error gyp info it worked if it ends with ok
99 error gyp info using node-gyp@7.1.2
99 error gyp info using node@14.4.0 | win32 | x64
99 error gyp info find Python using Python version 3.9.2 found at "C:\Users\user\AppData\Local\Programs\Python\Python39\python.exe"
99 error gyp info find VS using VS2017 (15.9.28307.1177) found at:
99 error gyp info find VS "C:\Program Files (x86)\Microsoft Visual Studio\2017\Community"
99 error gyp info find VS run with --verbose for detailed information
99 error gyp info spawn C:\Users\user\AppData\Local\Programs\Python\Python39\python.exe
99 error gyp info spawn args [
99 error gyp info spawn args 'C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\gyp\gyp_main.py',
99 error gyp info spawn args 'binding.gyp',
99 error gyp info spawn args '-f',
99 error gyp info spawn args 'msvs',
99 error gyp info spawn args '-I',
99 error gyp info spawn args 'C:\Users\user\node_modules\node-red-node-sqlite\node_modules\sqlite3\build\config.gypi',
99 error gyp info spawn args '-I',
99 error gyp info spawn args 'C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\addon.gypi',
99 error gyp info spawn args '-I',
99 error gyp info spawn args 'C:\Users\user\AppData\Local\node-gyp\Cache\14.4.0\include\node\common.gypi',
99 error gyp info spawn args '-Dlibrary=shared_library',
99 error gyp info spawn args '-Dvisibility=default',
99 error gyp info spawn args '-Dnode_root_dir=C:\Users\user\AppData\Local\node-gyp\Cache\14.4.0',
99 error gyp info spawn args '-Dnode_gyp_dir=C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp',
99 error gyp info spawn args '-Dnode_lib_file=C:\\Users\\user\\AppData\\Local\\node-gyp\\Cache\\14.4.0\\<(target_arch)\\node.lib',
99 error gyp info spawn args '-Dmodule_root_dir=C:\Users\user\node_modules\node-red-node-sqlite\node_modules\sqlite3',
99 error gyp info spawn args '-Dnode_engine=v8',
99 error gyp info spawn args '--depth=.',
99 error gyp info spawn args '--no-parallel',
99 error gyp info spawn args '--generator-output',
99 error gyp info spawn args 'C:\Users\user\node_modules\node-red-node-sqlite\node_modules\sqlite3\build',
99 error gyp info spawn args '-Goutput_dir=.'
99 error gyp info spawn args ]
99 error gyp info ok
99 error gyp info it worked if it ends with ok
99 error gyp info using node-gyp@7.1.2
99 error gyp info using node@14.4.0 | win32 | x64
99 error gyp info spawn C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin\MSBuild.exe
99 error gyp info spawn args [
99 error gyp info spawn args 'build/binding.sln',
99 error gyp info spawn args '/clp:Verbosity=minimal',
99 error gyp info spawn args '/nologo',
99 error gyp info spawn args '/p:Configuration=Release;Platform=x64'
99 error gyp info spawn args ]
99 error gyp ERR! build error
99 error gyp ERR! stack Error: C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin\MSBuild.exe failed with exit code: 1
99 error gyp ERR! stack at ChildProcess.onExit (C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\build.js:194:23)
99 error gyp ERR! stack at ChildProcess.emit (events.js:315:20)
99 error gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:276:12)
99 error gyp ERR! System Windows_NT 10.0.18363
99 error gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "build" "--fallback-to-build" "--module=C:\Users\user\node_modules\node-red-node-sqlite\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\Users\user\node_modules\node-red-node-sqlite\node_modules\sqlite3\lib\binding\node-v83-win32-x64" "--napi_version=6" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v83"
99 error gyp ERR! cwd C:\Users\user\node_modules\node-red-node-sqlite\node_modules\sqlite3
99 error gyp ERR! node -v v14.4.0
99 error gyp ERR! node-gyp -v v7.1.2
99 error gyp ERR! not ok
99 error node-pre-gyp ERR! build error
99 error node-pre-gyp ERR! stack Error: Failed to execute 'C:\Program Files\nodejs\node.exe C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js build --fallback-to-build --module=C:\Users\user\node_modules\node-red-node-sqlite\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\user\node_modules\node-red-node-sqlite\node_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi_version=6 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v83' (1)
99 error node-pre-gyp ERR! stack at ChildProcess. (C:\Users\user\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
99 error node-pre-gyp ERR! stack at ChildProcess.emit (events.js:315:20)
99 error node-pre-gyp ERR! stack at maybeClose (internal/child_process.js:1051:16)
99 error node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:287:5)
99 error node-pre-gyp ERR! System Windows_NT 10.0.18363
99 error node-pre-gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Users\user\node_modules\node-pre-gyp\bin\node-pre-gyp" "install" "--fallback-to-build"
99 error node-pre-gyp ERR! cwd C:\Users\user\node_modules\node-red-node-sqlite\node_modules\sqlite3
99 error node-pre-gyp ERR! node -v v14.4.0
99 error node-pre-gyp ERR! node-pre-gyp -v v0.11.0
99 error node-pre-gyp ERR! not ok
100 verbose exit 1

above is my install log. how to solve this issue?

This line gives the clue. It can't find pre-built native code for the package, so it needs to be compiled for your NodeJS version and OS.

Do do that, you need to setup your build environment. The instructions can be found here:

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.