Missing node type sqlitedb

[dcaccount]

Hello,

I have installed in my Raspberry pi 4 node-red-node-sqlite from within Node-Red palette manager and I have the following error:

When I check the palette, it shows:

How can I solve it? Please advise.

Thanks a lot, Dan

[dynamicdave]

I had a similar issue with a message saying... "sqlite is missing a file".

I sorted it by running this command on the command line.

npm rebuild sqlite3

It takes quite a while to recompile everything, so be patient.

[Colin]

@dynamicdave

npm rebuild sqlite3

@dcaccount you have to do that from the .node-red folder in case you did not know.

[dcaccount]

@dynamicdave

npm rebuild sqlite3

Hello,
I have done it but now the palette is showing:

Is that correct? Please advise, thanks

[Colin]

Does it work?
Having rebuilt you will have to restart node-red and refresh the browser page.

[edje11]

Same problem here.
I followed the instructions on the node page to get it working again, see chapter Install
https://flows.nodered.org/node/node-red-node-sqlite

[dcaccount]

Yes, the problem is solved but as above shown, I only find the node sqlite and not the node sqlitedb.

All the rest seems OK.

Any idea?

Ps, I have restarted Node-Red

[Colin]

The sqlitedb node is the database config node that you setup when you configure an sqlite node.

[dcaccount]

So is it all OK?

[Colin]

Yes, you can't manually select an sqlitedb node, as I said, it is setup automatically when you configure it inside the sqlite node. This is the sqlite node

This is the sqlitedb config node, note it says that on the top line