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?