# Sqlite nodes not working after update?

**URL:** <https://discourse.nodered.org/t/sqlite-nodes-not-working-after-update/39603>\
**Category:** General\
**Created:** [23 January 2021 13:53 UTC](https://discourse.nodered.org/t/sqlite-nodes-not-working-after-update/39603 "2021-01-23T13:53:11Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![martynwheeler](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/martynwheeler/32/24731_2.png) [@martynwheeler](https://discourse.nodered.org/u/martynwheeler)\
**Post date:** [23 January 2021 13:53 UTC](https://discourse.nodered.org/t/sqlite-nodes-not-working-after-update/39603/1 "2021-01-23T13:53:12Z")

</div>

I have just tried to update sqlite and it gives me the message below. When I restart node-red the existing sqlite nodes are shown with errors? I also cannot see the nodes in the pallete. Everything else is up to date. Hopefully someone can point me in the right direction? Thanks

Here is the output:

pi@raspberrypi5:~/.node-red/node\_modules $ npm install sqlite3  
npm WARN node-red-project@0.0.1 No repository field.  
npm WARN node-red-project@0.0.1 No license field.

- sqlite3@4.1.1  
updated 2 packages in 17s

25 packages are looking for funding  
run `npm fund` for details

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [23 January 2021 14:45 UTC](https://discourse.nodered.org/t/sqlite-nodes-not-working-after-update/39603/2 "2021-01-23T14:45:30Z")

</div>

That isn't an error but a warning.

You need to post the errors from the Node-RED log

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [23 January 2021 14:48 UTC](https://discourse.nodered.org/t/sqlite-nodes-not-working-after-update/39603/3 "2021-01-23T14:48:47Z")

</div>

Hi,

1. Can you confirm you have sqlite3 installed ? `sudo apt-get install sqlite3`
2. how did you try to update sqlite3 node ?
3. Did you run the update command in terminal from `.node-red` folder
4. Did you try sudo infront of the command ? `npm i --unsafe-perm node-red-node-sqlite`
5. What node.js version are you using ? you can check by running `node -v`

---

<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:** [23 January 2021 15:15 UTC](https://discourse.nodered.org/t/sqlite-nodes-not-working-after-update/39603/4 "2021-01-23T15:15:52Z")

</div>

> [@martynwheeler](#):
>
> npm install sqlite3

You appear to have installed the sqlite3 module, but that may not change the version that node-red-node-sqlite uses, assuming you are using that. I suggest installing the node-red-node-sqlite again to make sure it has a compatible version.

---

<div class="post-metadata">

**Author:** ![martynwheeler](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/martynwheeler/32/24731_2.png) [@martynwheeler](https://discourse.nodered.org/u/martynwheeler)\
**Post date:** [23 January 2021 15:16 UTC](https://discourse.nodered.org/t/sqlite-nodes-not-working-after-update/39603/5 "2021-01-23T15:16:54Z")

</div>

Hi There,

1. Yes, sqlite3 is installed
2. I have tried updating from:  
i. the pallet manager  
ii. the command line using npm install sqlite3 in the .node-red directory
3. yes is was in the .node-red folder
4. no, I have not done that, can you explain please?
5. I am running node.js v12.20.1

"You need to post the errors from the Node-RED log" - where is that please?

Thanks,

Martyn

---

<div class="post-metadata">

**Author:** ![martynwheeler](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/martynwheeler/32/24731_2.png) [@martynwheeler](https://discourse.nodered.org/u/martynwheeler)\
**Post date:** [23 January 2021 15:28 UTC](https://discourse.nodered.org/t/sqlite-nodes-not-working-after-update/39603/6 "2021-01-23T15:28:46Z")

</div>

I am trying that now, I suspect that is the problem. I am rebuilding it now.

---

<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:** [23 January 2021 15:29 UTC](https://discourse.nodered.org/t/sqlite-nodes-not-working-after-update/39603/7 "2021-01-23T15:29:25Z")

</div>

Are you trying to upgrade the npm module sqlite3 or are you trying to upgrade node-red-node-sqlite?

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [23 January 2021 15:31 UTC](https://discourse.nodered.org/t/sqlite-nodes-not-working-after-update/39603/8 "2021-01-23T15:31:28Z")

</div>

From the [Documentation](https://flows.nodered.org/node/node-red-node-sqlite) of the node

Run the following command in your Node-RED user directory - typically `~/.node-red`

```auto
npm i --unsafe-perm node-red-node-sqlite

```

**Note** : the install process requires a compile of native code. This can take 15-20 minutes on devices like a Raspberry Pi - please be prepared to wait a long time. Also if node.js is upgraded at any point you will need to rebuild the native part manually, for example.

```auto
cd ~/.node-red
npm rebuild

```

[EDIT] forgot to ask whether you have restarted your node-red server after the update ?

---

<div class="post-metadata">

**Author:** ![martynwheeler](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/martynwheeler/32/24731_2.png) [@martynwheeler](https://discourse.nodered.org/u/martynwheeler)\
**Post date:** [23 January 2021 15:34 UTC](https://discourse.nodered.org/t/sqlite-nodes-not-working-after-update/39603/9 "2021-01-23T15:34:35Z")

</div>

I was just going through updating nodes after updating node-red. The updates were all successful but when I restarted node-red the sqlite node in my flow was not recognised. I have just deleted the node-red-node-sqlite and sqlite3 directories from node red and am rebuilding using

npm i --unsafe-perm node-red-node-sqlite

it is taking a while I will let you know how it goes,,,

---

<div class="post-metadata">

**Author:** ![martynwheeler](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/martynwheeler/32/24731_2.png) [@martynwheeler](https://discourse.nodered.org/u/martynwheeler)\
**Post date:** [23 January 2021 15:51 UTC](https://discourse.nodered.org/t/sqlite-nodes-not-working-after-update/39603/10 "2021-01-23T15:51:01Z")

</div>

okay, so I now have version 0.43 installed and it is working. However, pallete manager is saying there is an update 0.5. I will try again from the pallete manager.

---

<div class="post-metadata">

**Author:** ![martynwheeler](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/martynwheeler/32/24731_2.png) [@martynwheeler](https://discourse.nodered.org/u/martynwheeler)\
**Post date:** [23 January 2021 15:58 UTC](https://discourse.nodered.org/t/sqlite-nodes-not-working-after-update/39603/11 "2021-01-23T15:58:30Z")

</div>

All fixed, I have no idea what I did wrong but everything is good now. Thanks for your help

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [24 March 2021 15:58 UTC](https://discourse.nodered.org/t/sqlite-nodes-not-working-after-update/39603/12 "2021-03-24T15:58:45Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.