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)
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.
Node10 is the LTS version
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.
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.
Is there a good way to install a previous version of Node.js and Node-red that was running on that machine?
I may be ok, apparently the old installation was under a different User, so that is still able to run at the moment.
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
Reinstalled node.js 8 and all is working again with the latest Node-Red install. Thank you both for the guidance.
