# Upgrade Node-Red - sqldbs install error

**URL:** <https://discourse.nodered.org/t/upgrade-node-red-sqldbs-install-error/4481>\
**Category:** General\
**Created:** [1 November 2018 16:02 UTC](https://discourse.nodered.org/t/upgrade-node-red-sqldbs-install-error/4481 "2018-11-01T16:02:22Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![jfehl](https://avatars.discourse-cdn.com/v4/letter/j/d2c977/32.png) [@jfehl](https://discourse.nodered.org/u/jfehl)\
**Post date:** [1 November 2018 16:02 UTC](https://discourse.nodered.org/t/upgrade-node-red-sqldbs-install-error/4481/1 "2018-11-01T16:02:22Z")

</div>

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](https://discourse.nodered.org/uploads/short-url/rR3jYsplr5LnCSGQy8eDs6tEFgD.txt) (272.4 KB)

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [1 November 2018 16:23 UTC](https://discourse.nodered.org/t/upgrade-node-red-sqldbs-install-error/4481/2 "2018-11-01T16:23:42Z")

</div>

I googled the error  
Failed at the sqlite3@3.1.13 install script.  
and got [https://github.com/mapbox/node-sqlite3/issues/972](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.

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [1 November 2018 16:28 UTC](https://discourse.nodered.org/t/upgrade-node-red-sqldbs-install-error/4481/3 "2018-11-01T16:28:34Z")

</div>

Node10 is the LTS version

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [1 November 2018 16:32 UTC](https://discourse.nodered.org/t/upgrade-node-red-sqldbs-install-error/4481/4 "2018-11-01T16:32:25Z")

</div>

> [@ukmoose](#):
>
> 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.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [1 November 2018 16:36 UTC](https://discourse.nodered.org/t/upgrade-node-red-sqldbs-install-error/4481/5 "2018-11-01T16:36:14Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![jfehl](https://avatars.discourse-cdn.com/v4/letter/j/d2c977/32.png) [@jfehl](https://discourse.nodered.org/u/jfehl)\
**Post date:** [1 November 2018 16:37 UTC](https://discourse.nodered.org/t/upgrade-node-red-sqldbs-install-error/4481/6 "2018-11-01T16:37:15Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![jfehl](https://avatars.discourse-cdn.com/v4/letter/j/d2c977/32.png) [@jfehl](https://discourse.nodered.org/u/jfehl)\
**Post date:** [1 November 2018 16:41 UTC](https://discourse.nodered.org/t/upgrade-node-red-sqldbs-install-error/4481/7 "2018-11-01T16:41:10Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [1 November 2018 16:42 UTC](https://discourse.nodered.org/t/upgrade-node-red-sqldbs-install-error/4481/8 "2018-11-01T16:42:47Z")

</div>

> [@jfehl](#):
>
> Is there a good way to install a previous version of Node.js and Node-red that was running on that machine

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](https://nodered.org/docs/platforms/windows)  
which does say to use node.js 8

---

<div class="post-metadata">

**Author:** ![jfehl](https://avatars.discourse-cdn.com/v4/letter/j/d2c977/32.png) [@jfehl](https://discourse.nodered.org/u/jfehl)\
**Post date:** [1 November 2018 16:59 UTC](https://discourse.nodered.org/t/upgrade-node-red-sqldbs-install-error/4481/9 "2018-11-01T16:59:26Z")

</div>

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