SQLite Install from Manage Palette

I am trying to install sqlite from the manage palette of my node red but for some reason is shows an error. I am still new to this so I dont have a lot of experience on how to fix it so if possible please be as detailed as you can. I have checked the other posts here regarding this problem but none of them seems to work or maybe I havent done appropriatly. The error is of this type:

[err] npm
[err]  ERR! code 1
[err] npm ERR! path C:\Users\user\.node-red\node_modules\sqlite3
[err] npm ERR!
[err]  command failed
[err] npm ERR! command C:\WINDOWS\system32\cmd.exe /d /s /c node-pre-gyp install --fallback-to-build
[err] npm ERR! Building the projects in this solution one at a time. To enable parallel build, please add the "/m" switch.
[err] npm ERR!   unpack_sqlite_dep
 [err] npm
 [err]  ERR!   sqlite3.c
 [err] npm ERR!   win_delay_load_hook.cc
 [err] npm ERR!   sqlite3.vcxproj -> C:\Users\user\.node-red\node_modules\sqlite3\build\Release\\sqlite3.lib
 [err] npm ERR!   backup.cc
 [err] npm ERR!
 [err]  c:\users\user\appdata\local\node-gyp\cache\14.15.5\include\node\node.h(67): fatal error C1083: Cannot open include file: 'v8.h': No such file or directory [C:\Users\user\.node-red\node_modules\sqlite3\build\node_sqlite3.vcxproj]
 [err] npm ERR! 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-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi_version=7 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v83' (1)
 [err] npm ERR! node-pre-gyp info it worked if it ends with ok
 [err] npm ERR! node-pre-gyp info using node-pre-gyp@0.11.0
 [err] npm
 [err]  ERR! node-pre-gyp info using node@14.15.5 | win32 | x64
 [err] npm ERR! node-pre-gyp WARN Using request for node-pre-gyp https download 
 [err] npm ERR! node-pre-gyp info check checked for "C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node" (not found)
 [err] npm ERR! node-pre-gyp http GET https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz
 [err] npm ERR! node-pre-gyp http 403 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz
 [err] npm ERR!
[err]  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 
 [err] npm ERR! node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@14.15.5 (node-v83 ABI, unknown) (falling back to source compile with node-gyp) 
 [err] npm ERR! 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 
 [err] npm 
 [err] ERR! gyp info it worked if it ends with ok
 [err] npm ERR! gyp info using node-gyp@7.1.2
 [err] npm ERR! gyp info using node@14.15.5 | win32 | x64
 [err] npm
 [err]  ERR! gyp info ok 
 [err] npm ERR! gyp info it worked if it ends with ok
 [err] npm ERR! gyp info using node-gyp@7.1.2
 [err] npm ERR! gyp info using node@14.15.5 | win32 | x64
 [err] npm 
[err] ERR! gyp info find Python using Python version 3.9.1 found at "C:\Python39\python.exe"
 [err] npm ERR! gyp info find VS using VS2017 (15.9.28307.1401) found at:
 [err] npm ERR! gyp info find VS "C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools"
 [err] npm ERR! gyp info find VS run with --verbose for detailed information
 [err] npm ERR!
 [err]  gyp info spawn C:\Python39\python.exe
 [err] npm ERR! gyp info spawn args [
 [err] npm ERR! gyp info spawn args   'C:\\Users\\user\\AppData\\Roaming\\npm\\node_modules\\npm\\node_modules\\node-gyp\\gyp\\gyp_main.py',
2021-05-10T20:29:10.864Z [err] npm ERR! gyp info spawn args   'binding.gyp',
2021-05-10T20:29:10.864Z [err] npm ERR! gyp info spawn args   '-f',
 [err] npm
 [err]  ERR! gyp info spawn args   'msvs',
 [err] npm ERR! gyp info spawn args   '-I',
 [err] npm ERR! gyp info spawn args   'C:\\Users\\user\\.node-red\\node_modules\\sqlite3\\build\\config.gypi',
 [err] npm ERR! gyp info spawn args   '-I',
 [err] npm 
 [err] ERR! gyp info spawn args   'C:\\Users\\user\\AppData\\Roaming\\npm\\node_modules\\npm\\node_modules\\node-gyp\\addon.gypi',
 [err] npm ERR! gyp info spawn args   '-I',
 [err] npm ERR! gyp info spawn args   'C:\\Users\\user\\AppData\\Local\\node-gyp\\Cache\\14.15.5\\include\\node\\common.gypi',
 [err] npm ERR! gyp info spawn args   '-Dlibrary=shared_library',
 [err] npm ERR! gyp info spawn args   '-Dvisibility=default',
 [err] npm 
 [err] ERR! gyp info spawn args   '-Dnode_root_dir=C:\\Users\\user\\AppData\\Local\\node-gyp\\Cache\\14.15.5',
 [err] npm ERR!
 [err]  gyp info spawn args   '-Dnode_gyp_dir=C:\\Users\\user\\AppData\\Roaming\\npm\\node_modules\\npm\\node_modules\\node-gyp',
 [err] npm ERR! gyp info spawn args   '-Dnode_lib_file=C:\\\\Users\\\\user\\\\AppData\\\\Local\\\\node-gyp\\\\Cache\\\\14.15.5\\\\<(target_arch)\\\\node.lib',
 [err] npm
 [err]  ERR! gyp info spawn args   '-Dmodule_root_dir=C:\\Users\\user\\.node-red\\node_modules\\sqlite3',
 [err] npm
 [err]  ERR! gyp info spawn args   '-Dnode_engine=v8',
 [err] npm ERR! gyp info spawn args   '--depth=.',
 [err] npm ERR! gyp info spawn args   '--no-parallel',
 [err] npm ERR! gyp info spawn args   '--generator-output',
 [err] npm ERR! gyp info spawn args   'C:\\Users\\user\\.node-red\\node_modules\\sqlite3\\build',
 [err] npm ERR! gyp info spawn args   '-Goutput_dir=.'
 [err] npm ERR! gyp info spawn args ]
 [err] npm ERR! gyp info ok 
 [err] npm ERR!
 [err]  gyp info it worked if it ends with ok
 [err] npm ERR! gyp info using node-gyp@7.1.2
 [err] npm ERR! gyp info using node@14.15.5 | win32 | x64
 [err] npm ERR! gyp info spawn C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\MSBuild\15.0\Bin\MSBuild.exe
 [err] npm
 [err]  ERR! gyp info spawn args [
 [err] npm ERR! gyp info spawn args   'build/binding.sln',
 [err] npm ERR! gyp info spawn args   '/clp:Verbosity=minimal',
 [err] npm ERR! gyp info spawn args   '/nologo',
 [err] npm
 [err]  ERR! gyp info spawn args   '/p:Configuration=Release;Platform=x64'
 [err] npm ERR! gyp info spawn args ]
 [err] npm ERR! gyp ERR! build error 
 [err] npm ERR! gyp ERR! stack Error: `C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\MSBuild\15.0\Bin\MSBuild.exe` failed with exit code: 1
 [err] npm
 [err]  ERR! gyp ERR! stack     at ChildProcess.onExit (C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\build.js:194:23)
 [err] npm ERR! gyp ERR! stack     at ChildProcess.emit (events.js:315:20)
 [err] npm ERR!
 [err]  gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:277:12)
 [err] npm ERR!
 [err]  gyp ERR! System Windows_NT 10.0.19041
 [err] npm ERR! 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-red\\node_modules\\sqlite3\\lib\\binding\\node-v83-win32-x64\\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\\Users\\user\\.node-red\\node_modules\\sqlite3\\lib\\binding\\node-v83-win32-x64" "--napi_version=7" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v83"
2021-05-10T20:29:10.866Z [err] npm ERR! gyp ERR! cwd C:\Users\user\.node-red\node_modules\sqlite3
 [err] npm
 [err]  ERR! gyp ERR! node -v v14.15.5
 [err] npm ERR!
 [err]  gyp ERR! node-gyp -v v7.1.2
 [err] npm ERR! gyp ERR! not ok 
[err] npm ERR! node-pre-gyp ERR! build error 
 [err] npm ERR!
 [err]  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-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi_version=7 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v83' (1)
 [err] npm ERR!
 [err]  node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (C:\Users\user\.node-red\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
 [err] npm ERR! node-pre-gyp ERR! stack     at ChildProcess.emit (events.js:315:20)
 [err] npm 
 [err] ERR! node-pre-gyp ERR! stack     at maybeClose (internal/child_process.js:1048:16)
 [err] npm ERR! node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:288:5)
 [err] npm 
 [err] ERR! node-pre-gyp ERR! System Windows_NT 10.0.19041
 [err] npm ERR! node-pre-gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\user\\.node-red\\node_modules\\node-pre-gyp\\bin\\node-pre-gyp" "install" "--fallback-to-build"
 [err] npm ERR!
 [err]  node-pre-gyp ERR! cwd C:\Users\user\.node-red\node_modules\sqlite3
 [err] npm ERR! node-pre-gyp ERR! node -v v14.15.5
 [err] npm ERR!
 [err]  node-pre-gyp ERR! node-pre-gyp -v v0.11.0
 [err] npm ERR! node-pre-gyp ERR! not ok
 [err] 
 npm ERR! A complete log of this run can be found in:
[err] npm ERR!     C:\Users\user\AppData\Local\npm-cache\_logs\2021-05-10T20_29_10_870Z-debug.log
 rc=1

thank you


2021-05-10T20:44:53.594Z Install : node-red-node-sqlite 0.6.0

 npm.cmd install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production node-red-node-sqlite@0.6.0
 [err] npm
 [err]  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
 [err] npm
 [err]  ERR! code 1
 [err] npm ERR! path C:\Users\user\.node-red\node_modules\sqlite3
 [err] npm 
 [err] ERR! command failed
 [err] npm ERR! command C:\WINDOWS\system32\cmd.exe /d /s /c node-pre-gyp install --fallback-to-build
 [err] npm
 [err]  ERR! 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 configure --fallback-to-build --module=C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi_version=7 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v83 --python=C:\Users\user\.windows-build-tools\python27\python.exe --msvs_version=2015' (1)
 [err] npm ERR! node-pre-gyp info it worked if it ends with ok
[err] npm
 [err]  ERR! node-pre-gyp info using node-pre-gyp@0.11.0
 [err] npm ERR! node-pre-gyp info using node@14.15.5 | win32 | x64
 [err] npm ERR! node-pre-gyp WARN Using request for node-pre-gyp https download 
 [err] npm ERR! node-pre-gyp info check checked for "C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node" (not found)
 [err] npm ERR! node-pre-gyp http GET https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz
 [err] npm ERR! node-pre-gyp http 403 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz
 [err] npm ERR! 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 
 [err] npm ERR! node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@14.15.5 (node-v83 ABI, unknown) (falling back to source compile with node-gyp) 
 [err] npm ERR!
 [err]  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 
 [err] npm ERR! gyp info it worked if it ends with ok
 [err] npm ERR! gyp info using node-gyp@7.1.2
 [err] npm ERR! gyp info using node@14.15.5 | win32 | x64
 [err] npm ERR! gyp info ok 
 [err] npm ERR! gyp info it worked if it ends with ok
 [err] npm ERR! gyp info using node-gyp@7.1.2
 [err] npm ERR! gyp info using node@14.15.5 | win32 | x64
 [err] npm ERR! gyp info find Python using Python version 2.7.15 found at "C:\Users\user\.windows-build-tools\python27\python.exe"
2021-05-10T20:45:02.259Z [err] npm ERR!
2021-05-10T20:45:02.259Z [err]  gyp ERR! find VS 
2021-05-10T20:45:02.259Z [err] npm ERR! gyp ERR! find VS msvs_version was set from command line or npm config
2021-05-10T20:45:02.259Z [err] npm ERR! gyp ERR! find VS - looking for Visual Studio version 2015
2021-05-10T20:45:02.259Z [err] npm ERR! gyp ERR! find VS VCINSTALLDIR not set, not running in VS Command Prompt
2021-05-10T20:45:02.259Z [err] npm ERR! gyp ERR! find VS checking VS2019 (16.8.30717.126) found at:
2021-05-10T20:45:02.259Z [err] npm 
2021-05-10T20:45:02.259Z [err] ERR! gyp ERR! find VS "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community"
2021-05-10T20:45:02.259Z [err] npm ERR! gyp ERR! find VS - found "Visual Studio C++ core features"
2021-05-10T20:45:02.259Z [err] npm ERR!
2021-05-10T20:45:02.259Z [err]  gyp ERR! find VS - missing any VC++ toolset
2021-05-10T20:45:02.259Z [err] npm ERR! gyp ERR! find VS checking VS2017 (15.9.28307.1401) found at:
2021-05-10T20:45:02.259Z [err] npm ERR! gyp ERR! find VS "C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools"
2021-05-10T20:45:02.259Z [err] npm ERR! gyp ERR! find VS - found "Visual Studio C++ core features"
2021-05-10T20:45:02.259Z [err] npm ERR! gyp ERR! find VS - found VC++ toolset: v141
2021-05-10T20:45:02.259Z [err] npm 
2021-05-10T20:45:02.259Z [err] ERR! gyp ERR! find VS - found Windows SDK: 10.0.17763.0
2021-05-10T20:45:02.259Z [err] npm ERR! gyp ERR! find VS - msvs_version does not match this version
2021-05-10T20:45:02.259Z [err] npm 
2021-05-10T20:45:02.259Z [err] ERR! gyp ERR! find VS could not find a version of Visual Studio 2017 or newer to use
2021-05-10T20:45:02.259Z [err] npm ERR! gyp ERR! find VS looking for Visual Studio 2015
2021-05-10T20:45:02.259Z [err] npm 
2021-05-10T20:45:02.259Z [err] ERR! gyp ERR! find VS - not found
2021-05-10T20:45:02.259Z [err] npm ERR! gyp ERR! find VS not looking for VS2013 as it is only supported up to Node.js 8
2021-05-10T20:45:02.259Z [err] npm 
2021-05-10T20:45:02.259Z [err] ERR! gyp ERR! find VS 
2021-05-10T20:45:02.259Z [err] npm ERR! gyp ERR! find VS valid versions for msvs_version:
2021-05-10T20:45:02.259Z [err] npm 
2021-05-10T20:45:02.259Z [err] ERR! gyp ERR! find VS - "2017"
2021-05-10T20:45:02.259Z [err] npm ERR! gyp ERR! find VS - "C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools"
2021-05-10T20:45:02.259Z [err] npm ERR!
2021-05-10T20:45:02.260Z [err]  gyp ERR! find VS 
2021-05-10T20:45:02.260Z [err] npm ERR! gyp ERR! find VS **************************************************************
2021-05-10T20:45:02.260Z [err] npm ERR!
2021-05-10T20:45:02.260Z [err]  gyp ERR! find VS You need to install the latest version of Visual Studio
2021-05-10T20:45:02.260Z [err] npm ERR! gyp ERR! find VS including the "Desktop development with C++" workload.
2021-05-10T20:45:02.260Z [err] npm ERR!
2021-05-10T20:45:02.260Z [err]  gyp ERR! find VS For more information consult the documentation at:
2021-05-10T20:45:02.260Z [err] npm ERR! gyp ERR! find VS https://github.com/nodejs/node-gyp#on-windows
2021-05-10T20:45:02.260Z [err] npm ERR!
2021-05-10T20:45:02.260Z [err]  gyp ERR! find VS **************************************************************
2021-05-10T20:45:02.260Z [err] npm ERR! gyp ERR! find VS 
2021-05-10T20:45:02.260Z [err] npm ERR!
2021-05-10T20:45:02.260Z [err]  gyp ERR! configure error 
2021-05-10T20:45:02.260Z [err] npm ERR! gyp ERR! stack Error: Could not find any Visual Studio installation to use
2021-05-10T20:45:02.260Z [err] npm 
2021-05-10T20:45:02.260Z [err] ERR! gyp ERR! stack     at VisualStudioFinder.fail (C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:121:47)
2021-05-10T20:45:02.260Z [err] npm ERR! gyp ERR! stack     at C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:74:16
2021-05-10T20:45:02.260Z [err] npm 
2021-05-10T20:45:02.260Z [err] ERR! gyp ERR! stack     at VisualStudioFinder.findVisualStudio2013 (C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:351:14)
2021-05-10T20:45:02.260Z [err] npm ERR! gyp ERR! stack     at C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:70:14
2021-05-10T20:45:02.260Z [err] npm ERR!
2021-05-10T20:45:02.260Z [err]  gyp ERR! stack     at C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:372:16
2021-05-10T20:45:02.260Z [err] npm ERR! gyp ERR! stack     at C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\util.js:54:7
2021-05-10T20:45:02.260Z [err] npm ERR!
2021-05-10T20:45:02.260Z [err]  gyp ERR! stack     at C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\util.js:33:16
2021-05-10T20:45:02.260Z [err] npm ERR! gyp ERR! stack     at ChildProcess.exithandler (child_process.js:315:5)
2021-05-10T20:45:02.260Z [err] npm ERR!
2021-05-10T20:45:02.260Z [err]  gyp ERR! stack     at ChildProcess.emit (events.js:315:20)
2021-05-10T20:45:02.260Z [err] npm ERR! gyp ERR! stack     at maybeClose (internal/child_process.js:1048:16)
2021-05-10T20:45:02.260Z [err] npm ERR!
2021-05-10T20:45:02.260Z [err]  gyp ERR! System Windows_NT 10.0.19041
2021-05-10T20:45:02.260Z [err] npm ERR! 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" "configure" "--fallback-to-build" "--module=C:\\Users\\user\\.node-red\\node_modules\\sqlite3\\lib\\binding\\node-v83-win32-x64\\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\\Users\\user\\.node-red\\node_modules\\sqlite3\\lib\\binding\\node-v83-win32-x64" "--napi_version=7" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v83" "--python=C:\\Users\\user\\.windows-build-tools\\python27\\python.exe" "--msvs_version=2015"
2021-05-10T20:45:02.260Z [err] npm 
2021-05-10T20:45:02.260Z [err] ERR! gyp ERR! cwd C:\Users\user\.node-red\node_modules\sqlite3
2021-05-10T20:45:02.260Z [err] npm ERR! gyp ERR! node -v v14.15.5
2021-05-10T20:45:02.260Z [err] npm 
2021-05-10T20:45:02.260Z [err] ERR! gyp ERR! node-gyp -v v7.1.2
2021-05-10T20:45:02.260Z [err] npm ERR! gyp ERR! not ok 
2021-05-10T20:45:02.260Z [err] npm 
2021-05-10T20:45:02.260Z [err] ERR! node-pre-gyp ERR! build error 
2021-05-10T20:45:02.260Z [err] npm ERR! 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 configure --fallback-to-build --module=C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi_version=7 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v83 --python=C:\Users\user\.windows-build-tools\python27\python.exe --msvs_version=2015' (1)
2021-05-10T20:45:02.260Z [err] npm 
2021-05-10T20:45:02.260Z [err] ERR! node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (C:\Users\user\.node-red\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
2021-05-10T20:45:02.260Z [err] npm ERR! node-pre-gyp ERR! stack     at ChildProcess.emit (events.js:315:20)
2021-05-10T20:45:02.260Z [err] npm 
2021-05-10T20:45:02.260Z [err] ERR! node-pre-gyp ERR! stack     at maybeClose (internal/child_process.js:1048:16)
2021-05-10T20:45:02.260Z [err] npm ERR! node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:288:5)
2021-05-10T20:45:02.260Z [err] npm ERR!
2021-05-10T20:45:02.260Z [err]  node-pre-gyp ERR! System Windows_NT 10.0.19041
2021-05-10T20:45:02.260Z [err] npm ERR! node-pre-gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\user\\.node-red\\node_modules\\node-pre-gyp\\bin\\node-pre-gyp" "install" "--fallback-to-build"
2021-05-10T20:45:02.260Z [err] npm ERR!
2021-05-10T20:45:02.260Z [err]  node-pre-gyp ERR! cwd C:\Users\user\.node-red\node_modules\sqlite3
2021-05-10T20:45:02.260Z [err] npm ERR! node-pre-gyp ERR! node -v v14.15.5
2021-05-10T20:45:02.260Z [err] npm ERR!
2021-05-10T20:45:02.260Z [err]  node-pre-gyp ERR! node-pre-gyp -v v0.11.0
2021-05-10T20:45:02.260Z [err] npm ERR! node-pre-gyp ERR! not ok
2021-05-10T20:45:02.276Z [err] 
2021-05-10T20:45:02.276Z [err] npm ERR!
2021-05-10T20:45:02.276Z [err]  A complete log of this run can be found in:
2021-05-10T20:45:02.276Z [err] npm ERR!     C:\Users\user\AppData\Local\npm-cache\_logs\2021-05-10T20_45_02_262Z-debug.log
2021-05-10T20:45:02.297Z rc=1

-----------------------------------------------------------
2021-05-10T21:03:52.323Z Install : node-red-node-sqlite 0.6.0

2021-05-10T21:03:52.345Z npm.cmd install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production node-red-node-sqlite@0.6.0
2021-05-10T21:03:59.196Z [err] npm
2021-05-10T21:03:59.197Z [err]  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
2021-05-10T21:04:02.668Z [err] npm
2021-05-10T21:04:02.668Z [err]  ERR! code 1
2021-05-10T21:04:02.668Z [err] npm ERR! path C:\Users\user\.node-red\node_modules\sqlite3
2021-05-10T21:04:02.671Z [err] npm ERR!
2021-05-10T21:04:02.672Z [err]  command failed
2021-05-10T21:04:02.672Z [err] npm ERR! command C:\WINDOWS\system32\cmd.exe /d /s /c node-pre-gyp install --fallback-to-build
2021-05-10T21:04:02.672Z [err] npm ERR! 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 configure --fallback-to-build --module=C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi_version=7 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v83 --python=C:\Users\user\.windows-build-tools\python27\python.exe --msvs_version=2015' (1)
2021-05-10T21:04:02.672Z [err] npm ERR! node-pre-gyp info it worked if it ends with ok
2021-05-10T21:04:02.672Z [err] npm ERR! node-pre-gyp info using node-pre-gyp@0.11.0
2021-05-10T21:04:02.672Z [err] npm 
2021-05-10T21:04:02.672Z [err] ERR! node-pre-gyp info using node@14.15.5 | win32 | x64
2021-05-10T21:04:02.672Z [err] npm ERR! node-pre-gyp WARN Using request for node-pre-gyp https download 
2021-05-10T21:04:02.672Z [err] npm ERR! node-pre-gyp info check checked for "C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node" (not found)
2021-05-10T21:04:02.672Z [err] npm 
2021-05-10T21:04:02.672Z [err] ERR! node-pre-gyp http GET https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz
2021-05-10T21:04:02.672Z [err] npm ERR! node-pre-gyp http 403 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz
2021-05-10T21:04:02.672Z [err] npm ERR! 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 
2021-05-10T21:04:02.672Z [err] npm ERR!
2021-05-10T21:04:02.672Z [err]  node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@14.15.5 (node-v83 ABI, unknown) (falling back to source compile with node-gyp) 
2021-05-10T21:04:02.672Z [err] npm ERR! 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 
2021-05-10T21:04:02.672Z [err] npm ERR! gyp info it worked if it ends with ok
2021-05-10T21:04:02.672Z [err] npm ERR! gyp info using node-gyp@7.1.2
2021-05-10T21:04:02.672Z [err] npm ERR! gyp info using node@14.15.5 | win32 | x64
2021-05-10T21:04:02.672Z [err] npm ERR! gyp info ok 
2021-05-10T21:04:02.672Z [err] npm ERR! gyp info it worked if it ends with ok
2021-05-10T21:04:02.672Z [err] npm ERR! gyp info using node-gyp@7.1.2
2021-05-10T21:04:02.672Z [err] npm ERR! gyp info using node@14.15.5 | win32 | x64
2021-05-10T21:04:02.672Z [err] npm ERR!
2021-05-10T21:04:02.672Z [err]  gyp info find Python using Python version 2.7.15 found at "C:\Users\user\.windows-build-tools\python27\python.exe"
2021-05-10T21:04:02.672Z [err] npm ERR! gyp ERR! find VS 
2021-05-10T21:04:02.672Z [err] npm ERR! gyp ERR! find VS msvs_version was set from command line or npm config
2021-05-10T21:04:02.672Z [err] npm
2021-05-10T21:04:02.672Z [err]  ERR! gyp ERR! find VS - looking for Visual Studio version 2015
2021-05-10T21:04:02.672Z [err] npm ERR! gyp ERR! find VS VCINSTALLDIR not set, not running in VS Command Prompt
2021-05-10T21:04:02.672Z [err] npm ERR!
2021-05-10T21:04:02.672Z [err]  gyp ERR! find VS checking VS2019 (16.8.30717.126) found at:
2021-05-10T21:04:02.672Z [err] npm ERR! gyp ERR! find VS "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community"
2021-05-10T21:04:02.672Z [err] npm ERR! gyp ERR! find VS - found "Visual Studio C++ core features"
2021-05-10T21:04:02.672Z [err] npm
2021-05-10T21:04:02.673Z [err]  ERR! gyp ERR! find VS - missing any VC++ toolset
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! find VS checking VS2017 (15.9.28307.1401) found at:
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! find VS "C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools"
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! find VS - found "Visual Studio C++ core features"
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! find VS - found VC++ toolset: v141
2021-05-10T21:04:02.673Z [err] npm 
2021-05-10T21:04:02.673Z [err] ERR! gyp ERR! find VS - found Windows SDK: 10.0.17763.0
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! find VS - msvs_version does not match this version
2021-05-10T21:04:02.673Z [err] npm 
2021-05-10T21:04:02.673Z [err] ERR! gyp ERR! find VS could not find a version of Visual Studio 2017 or newer to use
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! find VS looking for Visual Studio 2015
2021-05-10T21:04:02.673Z [err] npm 
2021-05-10T21:04:02.673Z [err] ERR! gyp ERR! find VS - not found
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! find VS not looking for VS2013 as it is only supported up to Node.js 8
2021-05-10T21:04:02.673Z [err] npm 
2021-05-10T21:04:02.673Z [err] ERR! gyp ERR! find VS 
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! find VS valid versions for msvs_version:
2021-05-10T21:04:02.673Z [err] npm ERR!
2021-05-10T21:04:02.673Z [err]  gyp ERR! find VS - "2017"
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! find VS - "C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools"
2021-05-10T21:04:02.673Z [err] npm ERR!
2021-05-10T21:04:02.673Z [err]  gyp ERR! find VS 
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! find VS **************************************************************
2021-05-10T21:04:02.673Z [err] npm ERR!
2021-05-10T21:04:02.673Z [err]  gyp ERR! find VS You need to install the latest version of Visual Studio
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! find VS including the "Desktop development with C++" workload.
2021-05-10T21:04:02.673Z [err] npm ERR!
2021-05-10T21:04:02.673Z [err]  gyp ERR! find VS For more information consult the documentation at:
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! find VS https://github.com/nodejs/node-gyp#on-windows
2021-05-10T21:04:02.673Z [err] npm ERR!
2021-05-10T21:04:02.673Z [err]  gyp ERR! find VS **************************************************************
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! find VS 
2021-05-10T21:04:02.673Z [err] npm ERR!
2021-05-10T21:04:02.673Z [err]  gyp ERR! configure error 
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! stack Error: Could not find any Visual Studio installation to use
2021-05-10T21:04:02.673Z [err] npm ERR!
2021-05-10T21:04:02.673Z [err]  gyp ERR! stack     at VisualStudioFinder.fail (C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:121:47)
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! stack     at C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:74:16
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! stack     at VisualStudioFinder.findVisualStudio2013 (C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:351:14)
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! stack     at C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:70:14
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! stack     at C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:372:16
2021-05-10T21:04:02.673Z [err] npm 
2021-05-10T21:04:02.673Z [err] ERR! gyp ERR! stack     at C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\util.js:54:7
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! stack     at C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\util.js:33:16
2021-05-10T21:04:02.673Z [err] npm ERR!
2021-05-10T21:04:02.673Z [err]  gyp ERR! stack     at ChildProcess.exithandler (child_process.js:315:5)
2021-05-10T21:04:02.673Z [err] npm ERR! gyp ERR! stack     at ChildProcess.emit (events.js:315:20)
2021-05-10T21:04:02.673Z [err] npm ERR!
2021-05-10T21:04:02.674Z [err]  gyp ERR! stack     at maybeClose (internal/child_process.js:1048:16)
2021-05-10T21:04:02.674Z [err] npm ERR! gyp ERR! System Windows_NT 10.0.19041
2021-05-10T21:04:02.674Z [err] npm ERR!
2021-05-10T21:04:02.674Z [err]  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" "configure" "--fallback-to-build" "--module=C:\\Users\\user\\.node-red\\node_modules\\sqlite3\\lib\\binding\\node-v83-win32-x64\\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\\Users\\user\\.node-red\\node_modules\\sqlite3\\lib\\binding\\node-v83-win32-x64" "--napi_version=7" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v83" "--python=C:\\Users\\user\\.windows-build-tools\\python27\\python.exe" "--msvs_version=2015"
2021-05-10T21:04:02.674Z [err] npm ERR! gyp ERR! cwd C:\Users\user\.node-red\node_modules\sqlite3
2021-05-10T21:04:02.674Z [err] npm 
2021-05-10T21:04:02.674Z [err] ERR! gyp ERR! node -v v14.15.5
2021-05-10T21:04:02.674Z [err] npm ERR! gyp ERR! node-gyp -v v7.1.2
2021-05-10T21:04:02.674Z [err] npm 
2021-05-10T21:04:02.674Z [err] ERR! gyp ERR! not ok 
2021-05-10T21:04:02.674Z [err] npm ERR! node-pre-gyp ERR! build error 
2021-05-10T21:04:02.674Z [err] npm ERR!
2021-05-10T21:04:02.674Z [err]  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 configure --fallback-to-build --module=C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi_version=7 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v83 --python=C:\Users\user\.windows-build-tools\python27\python.exe --msvs_version=2015' (1)
2021-05-10T21:04:02.674Z [err] npm ERR! node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (C:\Users\user\.node-red\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
2021-05-10T21:04:02.674Z [err] npm 
2021-05-10T21:04:02.674Z [err] ERR! node-pre-gyp ERR! stack     at ChildProcess.emit (events.js:315:20)
2021-05-10T21:04:02.674Z [err] npm ERR! node-pre-gyp ERR! stack     at maybeClose (internal/child_process.js:1048:16)
2021-05-10T21:04:02.674Z [err] npm ERR!
2021-05-10T21:04:02.674Z [err]  node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:288:5)
2021-05-10T21:04:02.674Z [err] npm ERR! node-pre-gyp ERR! System Windows_NT 10.0.19041
2021-05-10T21:04:02.674Z [err] npm ERR!
2021-05-10T21:04:02.674Z [err]  node-pre-gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\user\\.node-red\\node_modules\\node-pre-gyp\\bin\\node-pre-gyp" "install" "--fallback-to-build"
2021-05-10T21:04:02.674Z [err] npm ERR! node-pre-gyp ERR! cwd C:\Users\user\.node-red\node_modules\sqlite3
2021-05-10T21:04:02.674Z [err] npm ERR!
2021-05-10T21:04:02.674Z [err]  node-pre-gyp ERR! node -v v14.15.5
2021-05-10T21:04:02.674Z [err] npm ERR! node-pre-gyp ERR! node-pre-gyp -v v0.11.0
2021-05-10T21:04:02.674Z [err] npm ERR!
2021-05-10T21:04:02.674Z [err]  node-pre-gyp ERR! not ok
2021-05-10T21:04:02.689Z [err] 
2021-05-10T21:04:02.689Z [err] npm ERR! A complete log of this run can be found in:
2021-05-10T21:04:02.689Z [err] npm ERR!     C:\Users\user\AppData\Local\npm-cache\_logs\2021-05-10T21_04_02_675Z-debug.log
2021-05-10T21:04:02.716Z rc=1

-----------------------------------------------------------
2021-05-10T21:18:18.226Z Install : node-red-node-sqlite 0.6.0

2021-05-10T21:18:18.232Z npm.cmd install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production node-red-node-sqlite@0.6.0
2021-05-10T21:18:23.256Z [err] npm
2021-05-10T21:18:23.256Z [err]  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
2021-05-10T21:18:26.738Z [err] npm
2021-05-10T21:18:26.738Z [err]  ERR! code 1
2021-05-10T21:18:26.738Z [err] npm ERR! path C:\Users\user\.node-red\node_modules\sqlite3
2021-05-10T21:18:26.741Z [err] npm 
2021-05-10T21:18:26.741Z [err] ERR! command failed
2021-05-10T21:18:26.741Z [err] npm ERR! 
2021-05-10T21:18:26.741Z [err] command C:\WINDOWS\system32\cmd.exe /d /s /c node-pre-gyp install --fallback-to-build
2021-05-10T21:18:26.741Z [err] npm ERR!
2021-05-10T21:18:26.741Z [err]  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 configure --fallback-to-build --module=C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi_version=7 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v83 --python=C:\Users\user\.windows-build-tools\python27\python.exe --msvs_version=2015' (1)
2021-05-10T21:18:26.741Z [err] npm ERR! node-pre-gyp info it worked if it ends with ok
2021-05-10T21:18:26.741Z [err] npm ERR! node-pre-gyp info using node-pre-gyp@0.11.0
2021-05-10T21:18:26.741Z [err] npm ERR! node-pre-gyp info using node@14.15.5 | win32 | x64
2021-05-10T21:18:26.742Z [err] npm ERR! node-pre-gyp WARN Using request for node-pre-gyp https download 
2021-05-10T21:18:26.742Z [err] npm ERR! node-pre-gyp info check checked for "C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node" (not found)
2021-05-10T21:18:26.742Z [err] npm ERR! node-pre-gyp http GET https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz
2021-05-10T21:18:26.742Z [err] npm ERR! node-pre-gyp http 403 https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz
2021-05-10T21:18:26.742Z [err] npm ERR! 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 
2021-05-10T21:18:26.742Z [err] npm ERR! node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@14.15.5 (node-v83 ABI, unknown) (falling back to source compile with node-gyp) 
2021-05-10T21:18:26.742Z [err] npm ERR! 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 
2021-05-10T21:18:26.742Z [err] npm ERR! gyp info it worked if it ends with ok
2021-05-10T21:18:26.742Z [err] npm ERR! gyp info using node-gyp@7.1.2
2021-05-10T21:18:26.742Z [err] npm ERR! gyp info using node@14.15.5 | win32 | x64
2021-05-10T21:18:26.742Z [err] npm ERR! gyp info ok 
2021-05-10T21:18:26.742Z [err] npm ERR! gyp info it worked if it ends with ok
2021-05-10T21:18:26.742Z [err] npm ERR! gyp info using node-gyp@7.1.2
2021-05-10T21:18:26.742Z [err] npm ERR! gyp info using node@14.15.5 | win32 | x64
2021-05-10T21:18:26.742Z [err] npm ERR! gyp info find Python using Python version 2.7.15 found at "C:\Users\user\.windows-build-tools\python27\python.exe"
2021-05-10T21:18:26.742Z [err] npm ERR! gyp ERR! find VS 
2021-05-10T21:18:26.742Z [err] npm ERR! gyp ERR! find VS msvs_version was set from command line or npm config
2021-05-10T21:18:26.742Z [err] npm ERR! gyp ERR! find VS - looking for Visual Studio version 2015
2021-05-10T21:18:26.742Z [err] npm ERR!
2021-05-10T21:18:26.743Z [err]  gyp ERR! find VS VCINSTALLDIR not set, not running in VS Command Prompt
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS checking VS2019 (16.8.30717.126) found at:
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community"
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS - found "Visual Studio C++ core features"
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS - missing any VC++ toolset
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS checking VS2017 (15.9.28307.1401) found at:
2021-05-10T21:18:26.743Z [err] npm 
2021-05-10T21:18:26.743Z [err] ERR! gyp ERR! find VS "C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools"
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS - found "Visual Studio C++ core features"
2021-05-10T21:18:26.743Z [err] npm ERR!
2021-05-10T21:18:26.743Z [err]  gyp ERR! find VS - found VC++ toolset: v141
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS - found Windows SDK: 10.0.17763.0
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS - msvs_version does not match this version
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS could not find a version of Visual Studio 2017 or newer to use
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS looking for Visual Studio 2015
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS - not found
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS not looking for VS2013 as it is only supported up to Node.js 8
2021-05-10T21:18:26.743Z [err] npm 
2021-05-10T21:18:26.743Z [err] ERR! gyp ERR! find VS 
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS valid versions for msvs_version:
2021-05-10T21:18:26.743Z [err] npm ERR!
2021-05-10T21:18:26.743Z [err]  gyp ERR! find VS - "2017"
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS - "C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools"
2021-05-10T21:18:26.743Z [err] npm ERR!
2021-05-10T21:18:26.743Z [err]  gyp ERR! find VS 
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS **************************************************************
2021-05-10T21:18:26.743Z [err] npm ERR!
2021-05-10T21:18:26.743Z [err]  gyp ERR! find VS You need to install the latest version of Visual Studio
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS including the "Desktop development with C++" workload.
2021-05-10T21:18:26.743Z [err] npm ERR!
2021-05-10T21:18:26.743Z [err]  gyp ERR! find VS For more information consult the documentation at:
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS https://github.com/nodejs/node-gyp#on-windows
2021-05-10T21:18:26.743Z [err] npm ERR!
2021-05-10T21:18:26.743Z [err]  gyp ERR! find VS **************************************************************
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! find VS 
2021-05-10T21:18:26.743Z [err] npm ERR!
2021-05-10T21:18:26.743Z [err]  gyp ERR! configure error 
2021-05-10T21:18:26.743Z [err] npm ERR! gyp ERR! stack Error: Could not find any Visual Studio installation to use
2021-05-10T21:18:26.743Z [err] npm ERR!
2021-05-10T21:18:26.744Z [err]  gyp ERR! stack     at VisualStudioFinder.fail (C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:121:47)
2021-05-10T21:18:26.744Z [err] npm ERR! gyp ERR! stack     at C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:74:16
2021-05-10T21:18:26.744Z [err] npm ERR!
2021-05-10T21:18:26.744Z [err]  gyp ERR! stack     at VisualStudioFinder.findVisualStudio2013 (C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:351:14)
2021-05-10T21:18:26.744Z [err] npm ERR! gyp ERR! stack     at C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:70:14
2021-05-10T21:18:26.744Z [err] npm ERR!
2021-05-10T21:18:26.744Z [err]  gyp ERR! stack     at C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:372:16
2021-05-10T21:18:26.744Z [err] npm ERR! gyp ERR! stack     at C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\util.js:54:7
 [err] npm ERR!
 [err]  gyp ERR! stack     at C:\Users\user\AppData\Roaming\npm\node_modules\npm\node_modules\node-gyp\lib\util.js:33:16
 [err] npm ERR! gyp ERR! stack     at ChildProcess.exithandler (child_process.js:315:5)
 [err] npm ERR!
 [err]  gyp ERR! stack     at ChildProcess.emit (events.js:315:20)
 [err] npm ERR! gyp ERR! stack     at maybeClose (internal/child_process.js:1048:16)
 [err] npm ERR!
 [err]  gyp ERR! System Windows_NT 10.0.19041
[err] npm ERR! 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" "configure" "--fallback-to-build" "--module=C:\\Users\\user\\.node-red\\node_modules\\sqlite3\\lib\\binding\\node-v83-win32-x64\\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\\Users\\user\\.node-red\\node_modules\\sqlite3\\lib\\binding\\node-v83-win32-x64" "--napi_version=7" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v83" "--python=C:\\Users\\user\\.windows-build-tools\\python27\\python.exe" "--msvs_version=2015"
 [err] npm ERR!
 [err]  gyp ERR! cwd C:\Users\user\.node-red\node_modules\sqlite3
 [err] npm ERR! gyp ERR! node -v v14.15.5
 [err] npm ERR! gyp ERR! node-gyp -v v7.1.2
 [err] npm ERR! gyp ERR! not ok 
 [err] npm ERR! node-pre-gyp ERR! build error 
 [err] npm
 [err]  ERR! 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 configure --fallback-to-build --module=C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\user\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi_version=7 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v83 --python=C:\Users\user\.windows-build-tools\python27\python.exe --msvs_version=2015' (1)
 [err] npm ERR!
 [err]  node-pre-gyp ERR! stack     at ChildProcess.<anonymous> (C:\Users\user\.node-red\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
 [err] npm ERR! node-pre-gyp ERR! stack     at ChildProcess.emit (events.js:315:20)
 [err] npm
 [err]  ERR! node-pre-gyp ERR! stack     at maybeClose (internal/child_process.js:1048:16)
 [err] npm ERR! node-pre-gyp ERR! stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:288:5)
 [err] npm
 [err]  ERR! node-pre-gyp ERR! System Windows_NT 10.0.19041
 [err] npm ERR! node-pre-gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\user\\.node-red\\node_modules\\node-pre-gyp\\bin\\node-pre-gyp" "install" "--fallback-to-build"
 [err] npm
 [err]  ERR! node-pre-gyp ERR! cwd C:\Users\user\.node-red\node_modules\sqlite3
 [err] npm ERR! node-pre-gyp ERR! node -v v14.15.5
 [err] npm
 [err]  ERR! node-pre-gyp ERR! node-pre-gyp -v v0.11.0
 [err] npm ERR! node-pre-gyp ERR! not ok
 [err] 
 [err] npm ERR! A complete log of this run can be found in:
 [err] npm ERR!     C:\Users\user\AppData\Local\npm-cache\_logs\2021-05-10T21_18_26_746Z-debug.log
2021-05-10T21:18:26.792Z rc=1

Did you install the windows build tools as described in the docs for installing on windows?

I have tried it for some reason I get this:

C:\Users\user>npm install --global --production windows-build-tools
npm WARN deprecated har-validator@5.1.5: this library is no longer supported
npm WARN deprecated request@2.88.2: request has been deprecated, see https://github.com/request/request/issues/3142
npm ERR! code 1
npm ERR! path C:\Users\user\AppData\Roaming\npm\node_modules\windows-build-tools
npm ERR! command failed
npm ERR! command C:\WINDOWS\system32\cmd.exe /d /s /c node ./dist/index.js
Downloading python-2.7.15.amd64.msi
npm ERR! [>                                            ] 0.0% (0 B/s)
npm ERR! Downloaded python-2.7.15.amd64.msi. Saved to C:\Users\user\.windows-build-tools\python-2.7.15.amd64.msi.
Downloading vs_BuildTools.exe
npm ERR! [>                                            ] 0.0% (0 B/s)
npm ERR! Downloaded vs_BuildTools.exe. Saved to C:\Users\user\.windows-build-tools\vs_BuildTools.exe.
npm ERR!
npm ERR! Starting installation...
npm ERR! Please restart this script from an administrative PowerShell!
npm ERR! The build tools cannot be installed without administrative rights.
npm ERR! To fix, right-click on PowerShell and run "as Administrator".

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\user\AppData\Local\npm-cache\_logs\2021-05-15T15_36_17_557Z-debug.log

Did you see in the instructions is says
" using the command prompt as an Administrator:"

it still shows me this
C:\WINDOWS\system32>npm install --global --production windows-build-tools
npm WARN deprecated har-validator@5.1.5: this library is no longer supported
npm WARN deprecated request@2.88.2: request has been deprecated, see Request’s Past, Present and Future · Issue #3142 · request/request · GitHub
[ ] | reify:resolve: timing reifyNode:node_modules/windows-build-tools/node_modules/ajv Completed in 5

Is that all it shows? It didn't stop at that point surely.


yes it did, and the same happens if I do it in powershell

How long did you wait for it to finish? It is still running.

it was completed in like 5 seconds. I still left it running but nothing is changing

I think it has to download a large amount of microsoft stuff. Depending on your broadband connection it could take hours.

But what is the reason that It says completed in 5 ?

BTW can I ask you a question regarding some troubles Im having in RedMobile ? I am trying to do the same thing there using sqlite of the redmobile, but after creating a table I get a object and not a array.. I hope you can understand it with this example.

@Colin should I try to uninstall node red and then install it from the beginning ? If yes, in which order should I proceed in order to not have any more problems

If you read the help tab for the node you will see it says

Typically the returned payload will be an array of the result rows, (or an error).

Also, if that is a debug node connected to the sqlite node, it should be showing the topic.

Issues with red mobile should be reported to the app developer.

@FrensisX99 - I've edited your posts above so that they now display correctly, but please ensure that if you post any further logs, flows or code that you format them correctly for the forum using this guide - How to share code or flow json

I believe that refers to the particular action described on that line, I assume the rest of the message is off the right hand side of the window.

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