Upgrade Node-Red - sqldbs install error

#1

I just upgraded Node-Red and was able to install all the previously installed Node packages except node-red-contrib-sqldbs. The log file is attached.

2018-11-01T15_32_44_994Z-debug.log.txt (272.4 KB)

0 Likes

#2

I googled the error
Failed at the sqlite3@3.1.13 install script.
and got https://github.com/mapbox/node-sqlite3/issues/972 which suggests the problem may be an incompatibility with node 10. I suggest rolling back to the LTS version 8.x (which is currently the recommended one for node red) and trying again.

0 Likes

#3

Node10 is the LTS version

0 Likes

#4

Oh, so it is. I had not noticed that happening. Anyway that doesn't affect the likely solution. Either that or use node-sqlite3 version 4 which should be compatible with node 10. But that may not be compatible with node-red-contrib-sqldbs of course. It sounds like an issue needs to be raised against that node.

0 Likes

#5

However since the node has not been update for two years and the issues there have not even been looked at I think maybe raising an issue may be fruitless. Possibly better to do it a different way.

0 Likes

#6

Is there a good way to install a previous version of Node.js and Node-red that was running on that machine?

0 Likes

#7

I may be ok, apparently the old installation was under a different User, so that is still able to run at the moment.

0 Likes

#8

It is not node-red that is the problem just node.js. You should just be able to uninstall node.js in the usual windows way (I presume, I don't use Windows) then follow the instructions for installing on windows
https://nodered.org/docs/platforms/windows
which does say to use node.js 8

0 Likes

#9

Reinstalled node.js 8 and all is working again with the latest Node-Red install. Thank you both for the guidance.

0 Likes

Support for Node.js 10 LTS