Not able to install SQLite

KratosReus · 15 August 2021 12:09

Hi everyone,

I have been trying to install the SQLite node but it always triggers some errors:

Blockquote----------------------------------------------------------
2021-08-15T12:02:32.722Z Install : node-red-node-sqlite 0.6.0
2021-08-15T12:02:33.034Z npm.cmd install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production --engine-strict node-red-node-sqlite@0.6.0
2021-08-15T12:02:34.382Z [err] npm
2021-08-15T12:02:34.382Z [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-08-15T12:02:35.908Z [out]
2021-08-15T12:02:35.908Z [out] > sqlite3@4.2.0 install C:\Users\Kratos.node-red\node_modules\sqlite3
2021-08-15T12:02:35.908Z [out] > node-pre-gyp install --fallback-to-build
2021-08-15T12:02:35.908Z [out]
2021-08-15T12:02:36.146Z [err] node-pre-gyp
2021-08-15T12:02:36.146Z [err] WARN
2021-08-15T12:02:36.147Z [err] Using request for node-pre-gyp https download
2021-08-15T12:02:36.654Z [err] node-pre-gyp
2021-08-15T12:02:36.654Z [err] WARN Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz
2021-08-15T12:02:36.654Z [err] node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@14.17.3 (node-v83 ABI, unknown) (falling back to source compile with node-gyp)
2021-08-15T12:02:38.016Z [out] Building the projects in this solution one at a time. To enable parallel build, please add the "/m" switch.
2021-08-15T12:02:38.818Z [out] unpack_sqlite_dep
2021-08-15T12:02:38.819Z [out] 'python' is not recognized as an internal or external command,
2021-08-15T12:02:38.819Z [out] operable program or batch file.
2021-08-15T12:02:38.846Z [out] C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\Common7\IDE\VC\VCTargets\Microsoft.CppCommon.targets(209,5): error MSB6006: "cmd.exe" exited with code 1. [C:\Users\Kratos.node-red\node_modules\sqlite3\build\deps\action_before_build.vcxproj]
2021-08-15T12:02:38.886Z [err] gyp
2021-08-15T12:02:38.886Z [err] ERR! build error
2021-08-15T12:02:38.886Z [err] gyp
2021-08-15T12:02:38.886Z [err] ERR! stack
2021-08-15T12:02:38.886Z [err] Error: C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\MSBuild\15.0\Bin\MSBuild.exe failed with exit code: 1
2021-08-15T12:02:38.886Z [err] gyp ERR! stack at ChildProcess.onExit (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\build.js:194:23)
2021-08-15T12:02:38.886Z [err] gyp
2021-08-15T12:02:38.886Z [err] ERR! stack at ChildProcess.emit (events.js:375:28)
2021-08-15T12:02:38.886Z [err] gyp ERR!
2021-08-15T12:02:38.886Z [err] stack at Process.ChildProcess._handle.onexit (internal/child_process.js:277:12)
2021-08-15T12:02:38.886Z [err] gyp
2021-08-15T12:02:38.886Z [err] ERR! System Windows_NT 10.0.19042
2021-08-15T12:02:38.886Z [err] gyp ERR! command
2021-08-15T12:02:38.886Z [err] "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "build" "--fallback-to-build" "--module=C:\Users\Kratos\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\Users\Kratos\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64" "--napi_version=8" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v83"
2021-08-15T12:02:38.886Z [err] gyp ERR!
2021-08-15T12:02:38.886Z [err] cwd C:\Users\Kratos.node-red\node_modules\sqlite3
2021-08-15T12:02:38.886Z [err] gyp ERR! node -v
2021-08-15T12:02:38.886Z [err] v14.17.3
2021-08-15T12:02:38.886Z [err] gyp ERR! node-gyp -v
2021-08-15T12:02:38.886Z [err] v5.1.0
2021-08-15T12:02:38.886Z [err] gyp ERR! not ok
2021-08-15T12:02:38.891Z [err] node-pre-gyp
2021-08-15T12:02:38.891Z [err] ERR! build error
2021-08-15T12:02:38.891Z [err] node-pre-gyp
2021-08-15T12:02:38.891Z [err] ERR! stack Error: Failed to execute 'C:\Program Files\nodejs\node.exe C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js build --fallback-to-build --module=C:\Users\Kratos.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\Kratos.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v83' (1)
2021-08-15T12:02:38.891Z [err] node-pre-gyp ERR!
2021-08-15T12:02:38.891Z [err] stack at ChildProcess. (C:\Users\Kratos.node-red\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
2021-08-15T12:02:38.891Z [err] node-pre-gyp ERR! stack
2021-08-15T12:02:38.891Z [err] at ChildProcess.emit (events.js:375:28)
2021-08-15T12:02:38.891Z [err] node-pre-gyp ERR! stack at maybeClose (internal/child_process.js:1055:16)
2021-08-15T12:02:38.891Z [err] node-pre-gyp
2021-08-15T12:02:38.891Z [err] ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:288:5)
2021-08-15T12:02:38.891Z [err] node-pre-gyp
2021-08-15T12:02:38.891Z [err] ERR! System Windows_NT 10.0.19042
2021-08-15T12:02:38.891Z [err] node-pre-gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Users\Kratos\.node-red\node_modules\node-pre-gyp\bin\node-pre-gyp" "install" "--fallback-to-build"
2021-08-15T12:02:38.891Z [err] node-pre-gyp ERR! cwd C:\Users\Kratos.node-red\node_modules\sqlite3
2021-08-15T12:02:38.891Z [err] node-pre-gyp ERR! node -v v14.17.3
2021-08-15T12:02:38.891Z [err] node-pre-gyp ERR! node-pre-gyp -v v0.11.0
2021-08-15T12:02:38.891Z [err] node-pre-gyp ERR! not ok
2021-08-15T12:02:38.892Z [out] Failed to execute 'C:\Program Files\nodejs\node.exe C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js build --fallback-to-build --module=C:\Users\Kratos.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\Kratos.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v83' (1)
2021-08-15T12:02:39.022Z [err] npm ERR! code
2021-08-15T12:02:39.022Z [err] ELIFECYCLE
2021-08-15T12:02:39.022Z [err] npm ERR! errno 1
2021-08-15T12:02:39.025Z [err] npm ERR!
2021-08-15T12:02:39.025Z [err] sqlite3@4.2.0 install: node-pre-gyp install --fallback-to-build
2021-08-15T12:02:39.025Z [err] npm ERR! Exit status 1
2021-08-15T12:02:39.025Z [err] npm ERR!
2021-08-15T12:02:39.025Z [err] npm
2021-08-15T12:02:39.025Z [err] ERR! Failed at the sqlite3@4.2.0 install script.
2021-08-15T12:02:39.025Z [err] npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
2021-08-15T12:02:39.031Z [err]
2021-08-15T12:02:39.031Z [err] npm ERR! A complete log of this run can be found in:
2021-08-15T12:02:39.031Z [err] npm ERR! C:\Users\Kratos\AppData\Roaming\npm-cache_logs\2021-08-15T12_02_39_028Z-debug.log
2021-08-15T12:02:39.045Z rc=1

Does it mean I need to have a prior version of Node.js installed? What should I do to overcome this issue? I've tried some things I have searched here for but didn't get any luck.

Thanks

knolleary · 15 August 2021 12:28

It's a little buried in the log, but the relevant error is this one:

You will need to have python installed and available on your path.

Steve-Mcl · 15 August 2021 12:29

Python is not found. Did you install windows-build-tools?

UnborN · 15 August 2021 12:30

No need to downgrade your nodejs. But because sqlite3 depends on some binary files that need to be built, your system needs the necessary tools to do that (windows-build-tools). The command to install it :

npm install --global windows-build-tools

@dceejay could these problems with installation of the popular sqlite node be avoided if we bump up the dependancy version of sqlite3 to 5.0.2. It says in the chance log that they rebuilt the binaries ?
Changelog

KratosReus · 15 August 2021 15:17

Hello.

I've uninstalled and installed python already and that error does not appear now but I have a new one related with the visual studio:

Blockquote
2021-08-15T15:08:54.413Z Install : node-red-node-sqlite 0.6.0
2021-08-15T15:08:54.731Z npm.cmd install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production --engine-strict node-red-node-sqlite@0.6.0
2021-08-15T15:08:56.388Z [err] npm
2021-08-15T15:08:56.388Z [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-08-15T15:08:58.079Z [out]
2021-08-15T15:08:58.079Z [out] > sqlite3@4.2.0 install C:\Users\Kratos.node-red\node_modules\sqlite3
2021-08-15T15:08:58.079Z [out] > node-pre-gyp install --fallback-to-build
2021-08-15T15:08:58.079Z [out]
2021-08-15T15:08:58.330Z [err] node-pre-gyp
2021-08-15T15:08:58.330Z [err]
2021-08-15T15:08:58.330Z [err] WARN Using request for node-pre-gyp https download
2021-08-15T15:08:58.843Z [err] node-pre-gyp
2021-08-15T15:08:58.843Z [err] WARN Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.2.0/node-v83-win32-x64.tar.gz
2021-08-15T15:08:58.843Z [err] node-pre-gyp WARN Pre-built binaries not found for sqlite3@4.2.0 and node@14.17.3 (node-v83 ABI, unknown) (falling back to source compile with node-gyp)
2021-08-15T15:08:59.960Z [err] gyp
2021-08-15T15:08:59.960Z [err] ERR! find VS
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS msvs_version was set from command line or npm config
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS
2021-08-15T15:08:59.960Z [err] - looking for Visual Studio version 2015
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS VCINSTALLDIR not set, not running in VS Command Prompt
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS checking VS2019 (16.11.31605.320) found at:
2021-08-15T15:08:59.960Z [err] gyp ERR!
2021-08-15T15:08:59.960Z [err] find VS "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community"
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - found "Visual Studio C++ core features"
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - found VC++ toolset: v142
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - found Windows SDK: 10.0.19041.0
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - msvs_version does not match this version
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS
2021-08-15T15:08:59.960Z [err] checking VS2017 (15.9.28307.1622) found at:
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS "C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools"
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - found "Visual Studio C++ core features"
2021-08-15T15:08:59.960Z [err] gyp ERR!
2021-08-15T15:08:59.960Z [err] find VS - found VC++ toolset: v141
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - found Windows SDK: 10.0.17763.0
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - msvs_version does not match this version
2021-08-15T15:08:59.960Z [err] gyp ERR!
2021-08-15T15:08:59.960Z [err] find VS could not find a version of Visual Studio 2017 or newer to use
2021-08-15T15:08:59.960Z [err] gyp
2021-08-15T15:08:59.960Z [err] ERR! find VS looking for Visual Studio 2015
2021-08-15T15:08:59.960Z [err] gyp ERR!
2021-08-15T15:08:59.960Z [err] find VS - not found
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS not looking for VS2013 as it is only supported up to Node.js 8
2021-08-15T15:08:59.960Z [err] gyp
2021-08-15T15:08:59.960Z [err] ERR! find VS
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS
2021-08-15T15:08:59.960Z [err] valid versions for msvs_version:
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - "2019"
2021-08-15T15:08:59.960Z [err] gyp ERR!
2021-08-15T15:08:59.960Z [err] find VS - "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community"
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS - "2017"
2021-08-15T15:08:59.960Z [err] gyp
2021-08-15T15:08:59.960Z [err] ERR! find VS - "C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools"
2021-08-15T15:08:59.960Z [err] gyp ERR!
2021-08-15T15:08:59.960Z [err] find VS
2021-08-15T15:08:59.960Z [err] gyp ERR! find VS **************************************************************
2021-08-15T15:08:59.960Z [err] gyp
2021-08-15T15:08:59.961Z [err] ERR! find VS You need to install the latest version of Visual Studio
2021-08-15T15:08:59.961Z [err] gyp ERR! find VS
2021-08-15T15:08:59.961Z [err] including the "Desktop development with C++" workload.
2021-08-15T15:08:59.961Z [err] gyp ERR! find VS For more information consult the documentation at:
2021-08-15T15:08:59.961Z [err] gyp ERR!
2021-08-15T15:08:59.961Z [err] find VS GitHub - nodejs/node-gyp: Node.js native addon build tool
2021-08-15T15:08:59.961Z [err] gyp ERR! find VS **************************************************************
2021-08-15T15:08:59.961Z [err] gyp ERR! find VS
2021-08-15T15:08:59.961Z [err] gyp
2021-08-15T15:08:59.961Z [err] ERR! configure error
2021-08-15T15:08:59.961Z [err] gyp ERR!
2021-08-15T15:08:59.961Z [err] stack Error: Could not find any Visual Studio installation to use
2021-08-15T15:08:59.961Z [err] gyp ERR! stack at VisualStudioFinder.fail (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:121:47)
2021-08-15T15:08:59.961Z [err] gyp ERR! stack at C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:74:16
2021-08-15T15:08:59.961Z [err] gyp
2021-08-15T15:08:59.961Z [err] ERR! stack at VisualStudioFinder.findVisualStudio2013 (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:351:14)
2021-08-15T15:08:59.961Z [err] gyp ERR! stack
2021-08-15T15:08:59.961Z [err] at C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:70:14
2021-08-15T15:08:59.961Z [err] gyp ERR! stack at C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\find-visualstudio.js:372:16
2021-08-15T15:08:59.961Z [err] gyp
2021-08-15T15:08:59.961Z [err] ERR! stack at C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\util.js:54:7
2021-08-15T15:08:59.961Z [err] gyp ERR! stack
2021-08-15T15:08:59.961Z [err] at C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\util.js:33:16
2021-08-15T15:08:59.961Z [err] gyp ERR! stack at ChildProcess.exithandler (child_process.js:326:5)
2021-08-15T15:08:59.961Z [err] gyp
2021-08-15T15:08:59.961Z [err] ERR! stack at ChildProcess.emit (events.js:375:28)
2021-08-15T15:08:59.961Z [err] gyp ERR! stack
2021-08-15T15:08:59.961Z [err] at maybeClose (internal/child_process.js:1055:16)
2021-08-15T15:08:59.962Z [err] gyp
2021-08-15T15:08:59.962Z [err] ERR! System Windows_NT 10.0.19042
2021-08-15T15:08:59.962Z [err] gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "configure" "--fallback-to-build" "--module=C:\Users\Kratos\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\Users\Kratos\.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64" "--napi_version=8" "--node_abi_napi=napi" "--napi_build_version=0" "--node_napi_label=node-v83" "--python=python2.7" "--msvs_version=2015"
2021-08-15T15:08:59.962Z [err] gyp
2021-08-15T15:08:59.962Z [err] ERR! cwd C:\Users\Kratos.node-red\node_modules\sqlite3
2021-08-15T15:08:59.962Z [err] gyp
2021-08-15T15:08:59.962Z [err] ERR! node -v v14.17.3
2021-08-15T15:08:59.962Z [err] gyp ERR!
2021-08-15T15:08:59.962Z [err] node-gyp -v v5.1.0
2021-08-15T15:08:59.962Z [err] gyp ERR!
2021-08-15T15:08:59.962Z [err] not ok
2021-08-15T15:08:59.967Z [err] node-pre-gyp
2021-08-15T15:08:59.967Z [err] ERR! build error
2021-08-15T15:08:59.968Z [err] node-pre-gyp
2021-08-15T15:08:59.968Z [err] ERR! stack Error: Failed to execute 'C:\Program Files\nodejs\node.exe C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build --module=C:\Users\Kratos.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\Kratos.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v83 --python=python2.7 --msvs_version=2015' (1)
2021-08-15T15:08:59.968Z [err] node-pre-gyp ERR!
2021-08-15T15:08:59.968Z [err] stack at ChildProcess. (C:\Users\Kratos.node-red\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
2021-08-15T15:08:59.968Z [err] node-pre-gyp ERR! stack at ChildProcess.emit (events.js:375:28)
2021-08-15T15:08:59.968Z [err] node-pre-gyp ERR! stack at maybeClose (internal/child_process.js:1055:16)
2021-08-15T15:08:59.968Z [err] node-pre-gyp
2021-08-15T15:08:59.968Z [err] ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:288:5)
2021-08-15T15:08:59.968Z [err] node-pre-gyp
2021-08-15T15:08:59.968Z [err] ERR! System Windows_NT 10.0.19042
2021-08-15T15:08:59.968Z [err] node-pre-gyp ERR! command "C:\Program Files\nodejs\node.exe" "C:\Users\Kratos\.node-red\node_modules\node-pre-gyp\bin\node-pre-gyp" "install" "--fallback-to-build"
2021-08-15T15:08:59.968Z [err] node-pre-gyp ERR! cwd C:\Users\Kratos.node-red\node_modules\sqlite3
2021-08-15T15:08:59.968Z [err] node-pre-gyp
2021-08-15T15:08:59.968Z [err] ERR! node -v v14.17.3
2021-08-15T15:08:59.968Z [err] node-pre-gyp
2021-08-15T15:08:59.968Z [err] ERR! node-pre-gyp -v v0.11.0
2021-08-15T15:08:59.968Z [err] node-pre-gyp ERR!
2021-08-15T15:08:59.968Z [err] not ok
2021-08-15T15:08:59.968Z [out] Failed to execute 'C:\Program Files\nodejs\node.exe C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js configure --fallback-to-build --module=C:\Users\Kratos.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\Users\Kratos.node-red\node_modules\sqlite3\lib\binding\node-v83-win32-x64 --napi_version=8 --node_abi_napi=napi --napi_build_version=0 --node_napi_label=node-v83 --python=python2.7 --msvs_version=2015' (1)
2021-08-15T15:09:00.095Z [err] npm ERR!
2021-08-15T15:09:00.095Z [err] code ELIFECYCLE
2021-08-15T15:09:00.095Z [err] npm ERR! errno 1
2021-08-15T15:09:00.098Z [err] npm ERR!
2021-08-15T15:09:00.098Z [err] sqlite3@4.2.0 install: node-pre-gyp install --fallback-to-build
2021-08-15T15:09:00.098Z [err] npm ERR! Exit status 1
2021-08-15T15:09:00.098Z [err] npm ERR!
2021-08-15T15:09:00.098Z [err] npm ERR! Failed at the sqlite3@4.2.0 install script.
2021-08-15T15:09:00.098Z [err] npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
2021-08-15T15:09:00.104Z [err]
2021-08-15T15:09:00.104Z [err] npm ERR! A complete log of this run can be found in:
2021-08-15T15:09:00.104Z [err] npm ERR! C:\Users\Kratos\AppData\Roaming\npm-cache_logs\2021-08-15T15_09_00_101Z-debug.log
2021-08-15T15:09:00.117Z rc=1

I've previously installed Visual Studio and tried to install windows-build-tools but since it got stuck at having python installed again, I have gone with "npm install --global --production windows-build-tools --vs2015" instead and it finished with success.

However, I still have those errors.

Thanks in advance to everyone.

Steve-Mcl · 15 August 2021 15:28

I think you need v2017 or later.

Colin · 15 August 2021 15:56

Won't installing the windows build tools as described in the docs fix that?

Steve-Mcl · 15 August 2021 16:02

The op said he installed build tools...

... but looking at the log, I suspect he needs a later version based on...

Colin · 15 August 2021 16:17

Sorry, I missed that, I am on my phone.

dceejay · 15 August 2021 17:04

Hi @UnborN
happy to bump it up as long as someone tests it first. I'm almost finished vacation but cant test right now.

UnborN · 15 August 2021 18:46

it looks ok on Win10. maybe my test was a bit unorthodox but i'll try to detail the steps i followed bellow.

made sure i didnt have installed windows-build-tools by running
npm uninstall --global windows-build-tools
uninstalled the sqlite node from .node-red folder :
npm uninstall node-red-node-sqlite
made sure npm install node-red-node-sqlite fails because of missing build tools
since i didnt have the package in node modules anymore to edit,
i downloaded the .tzg file by following the link from the npm registry
https://registry.npmjs.org/node-red-node-sqlite/-/node-red-node-sqlite-0.6.0.tgz
extracted it on my Desktop and modified its package.json to 5.0.2

"dependencies": {
        "sqlite3": "~5.0.2"
    },

from .node-red folder run :
npm install C:\Users\User\Desktop\node-red-node-sqlite-0.6.0\package
installation of the node went through .. no binary builds since i presume the already compiled binaries for that version and OS were downloaded from mapbox-node-binary ?
restarted node-red and the db connection seems fine with some simple reads.

KratosReus · 15 August 2021 21:07

Hi,

Followed these steps and now I was able to install the sqlite node!

Thank you so much.

UnborN · 15 August 2021 21:13

good but .. the above steps were by no means a way of installing/updating the sqlite node.
It was just a way to test whether the sqlite node would work with a newer sqlite3 dependency 5.0.2

Better wait for a proper update of the node-red-node-sqlite node unless you want to do some tests also so Dave can have some feedback.

system · 14 October 2021 21:13

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

Topic		Replies	Views
Unable to install Node-sqlite General	2	498	4 June 2021
Unable to install SQlite General	6	2779	3 March 2021
Can't install sqlite General	5	644	21 July 2020
Failed to install: node-red-node-sqlite General	14	1768	5 July 2021
Cant install sqlite node in node-red addon (Home Assistant) General	3	597	21 June 2021

Not able to install SQLite

Related Topics