Node-red version and "Cannot find module 'sqlite3'"

General
1

I am using node-red on Windows 10. When I check the installed packages in "Manage palette" this is displayed for node-red itself:

node-red

0.19.4

  • Not currently supported on Windows.
  • Error: Cannot find module 'sqlite3' (line:23)

If I execute the command "npm info node-red version" from the power shell console, the following is displayed:
0.19.5

When starting node-red, following messages are displayed:

Welcome to Node-RED

22 Feb 07:32:25 - [info] Node-RED version: v0.19.4
22 Feb 07:32:25 - [info] Node.js version: v8.12.0
22 Feb 07:32:25 - [info] Windows_NT 10.0.17134 x64 LE
22 Feb 07:32:27 - [info] Loading palette nodes
22 Feb 07:32:30 - [warn] rpi-gpio : Raspberry Pi specific node set inactive
22 Feb 07:32:46 - [info] Dashboard version 2.13.2 started at /ui
22 Feb 07:32:55 - [warn] ------------------------------------------------------
22 Feb 07:32:55 - [warn] [node-red/tail] Not currently supported on Windows.
22 Feb 07:32:55 - [warn] [node-red/litedb] Error: Cannot find module 'sqlite3' (line:23)
22 Feb 07:32:55 - [warn] ------------------------------------------------------
22 Feb 07:32:55 - [info] Settings file : \Users*.node-red\settings.js
22 Feb 07:32:55 - [info] HTTP Static : C:\Users*.node-red\public
22 Feb 07:32:55 - [info] Context store : 'default' [module=memory]
22 Feb 07:32:55 - [info] User directory : \Users*.node-red
22 Feb 07:32:55 - [warn] Projects disabled : editorTheme.projects.enabled=false
22 Feb 07:32:55 - [info] Flows file : \Users*.node-red\flows_***.json
22 Feb 07:32:55 - [info] Server now running at http://127.0.0.1:1880/
22 Feb 07:32:55 - [warn]

Why is not used the latest node-red version (0.19.5)?

2

The Manage Palette feature is for managing the individual node modules you have installed. It does not manage the main node-red module itself - that you have to update yourself.

The [node-red/litedb] Error: Cannot find module 'sqlite3' (line:23) error must be related to a custom node you have added under ~/.node-red/.node-red/nodes - because litedb is not a node we provide and the fact it has node-red/ as a prefix means its been loaded as a local node file, not a properly installed module.

3

Thx for reply.
But why does the node-red version 0.19.4 start instead of the 0.19.5 version?

Later edit: I reinstalled the 0.19.5 version.
Now I see in Manage Palette only the warning that the version is not supported on Windows (why actually ?)

0.19.5

  • Not currently supported on Windows.
4

That error is specific to the Tail node. The startup log you shared earlier shows where the error came from. When the palette manager displays the error it loses that bit of context which can be confusing.