# Missing node type sqlitedb

**URL:** <https://discourse.nodered.org/t/missing-node-type-sqlitedb/36984>\
**Category:** General\
**Created:** [4 December 2020 10:24 UTC](https://discourse.nodered.org/t/missing-node-type-sqlitedb/36984 "2020-12-04T10:24:42Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![dcaccount](https://avatars.discourse-cdn.com/v4/letter/d/e36b37/32.png) [@dcaccount](https://discourse.nodered.org/u/dcaccount)\
**Post date:** [4 December 2020 10:24 UTC](https://discourse.nodered.org/t/missing-node-type-sqlitedb/36984/1 "2020-12-04T10:24:42Z")

</div>

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:

 ![Schermata 2020-12-04 alle 11.21.58](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/4/b4272d46dcdac1ea33d3b78e15a227ca0f18e8d1.png)

When I check the palette, it shows:

 ![Schermata 2020-12-04 alle 11.22.17](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/0/70b165b9873fa0cf0ab1ec322bca73d608334e90.png)

How can I solve it? Please advise.

Thanks a lot, Dan

---

<div class="post-metadata">

**Author:** ![dynamicdave](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dynamicdave/32/96_2.png) [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)\
**Post date:** [4 December 2020 10:45 UTC](https://discourse.nodered.org/t/missing-node-type-sqlitedb/36984/2 "2020-12-04T10:45:53Z")

</div>

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.

---

<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:** [4 December 2020 10:51 UTC](https://discourse.nodered.org/t/missing-node-type-sqlitedb/36984/3 "2020-12-04T10:51:42Z")

</div>

> [@dynamicdave](#):
>
> npm rebuild sqlite3

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

---

<div class="post-metadata">

**Author:** ![dcaccount](https://avatars.discourse-cdn.com/v4/letter/d/e36b37/32.png) [@dcaccount](https://discourse.nodered.org/u/dcaccount)\
**Post date:** [4 December 2020 11:04 UTC](https://discourse.nodered.org/t/missing-node-type-sqlitedb/36984/4 "2020-12-04T11:04:24Z")

</div>

> [@dynamicdave](#):
>
> npm rebuild sqlite3

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

 ![Schermata 2020-12-04 alle 12.03.36](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/c/7c067a5385e9f8b4011f7eefb70c09f296f83c18.png)

Is that correct? Please advise, thanks

---

<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:** [4 December 2020 11:05 UTC](https://discourse.nodered.org/t/missing-node-type-sqlitedb/36984/5 "2020-12-04T11:05:11Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![edje11](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/edje11/32/572_2.png) [@edje11](https://discourse.nodered.org/u/edje11)\
**Post date:** [4 December 2020 11:21 UTC](https://discourse.nodered.org/t/missing-node-type-sqlitedb/36984/6 "2020-12-04T11:21:33Z")

</div>

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](https://flows.nodered.org/node/node-red-node-sqlite)

---

<div class="post-metadata">

**Author:** ![dcaccount](https://avatars.discourse-cdn.com/v4/letter/d/e36b37/32.png) [@dcaccount](https://discourse.nodered.org/u/dcaccount)\
**Post date:** [4 December 2020 11:37 UTC](https://discourse.nodered.org/t/missing-node-type-sqlitedb/36984/7 "2020-12-04T11:37:07Z")

</div>

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

---

<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:** [4 December 2020 11:53 UTC](https://discourse.nodered.org/t/missing-node-type-sqlitedb/36984/8 "2020-12-04T11:53:38Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dcaccount](https://avatars.discourse-cdn.com/v4/letter/d/e36b37/32.png) [@dcaccount](https://discourse.nodered.org/u/dcaccount)\
**Post date:** [4 December 2020 12:05 UTC](https://discourse.nodered.org/t/missing-node-type-sqlitedb/36984/9 "2020-12-04T12:05:33Z")

</div>

So is it all OK?

---

<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:** [4 December 2020 12:14 UTC](https://discourse.nodered.org/t/missing-node-type-sqlitedb/36984/10 "2020-12-04T12:14:43Z")

</div>

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

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/e/9eb37cb10914d9fa875ebc29d1a8852b41ddb82a.png)

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

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/4/5443ff608439d66e6160f1e8ce13da590747c2f5.png)

---

<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:** [18 December 2020 12:14 UTC](https://discourse.nodered.org/t/missing-node-type-sqlitedb/36984/11 "2020-12-18T12:14:46Z")

</div>

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