# SQlite error with node red on Docker

**URL:** https://discourse.nodered.org/t/sqlite-error-with-node-red-on-docker/54618
**Category:** General
**Tags:** database, docker
**Created:** [2 December 2021 02:35 UTC](https://discourse.nodered.org/t/sqlite-error-with-node-red-on-docker/54618 "2021-12-02T02:35:39Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![TROJAN053](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@TROJAN053](https://discourse.nodered.org/u/TROJAN053)
#### Post date: [2 December 2021 02:35 UTC](https://discourse.nodered.org/t/sqlite-error-with-node-red-on-docker/54618/1 "2021-12-02T02:35:39Z")

</div>

Hi,  
I am using SQlite to keep some data, where as while passing my query as topic an error is appearing saying ' Error: SQLITE\_ERROR: no such table: History\_Stop'. I am using a windows 10 system and node red is running on Docker.

I have cross checked mulitple times table name and other things.

 ![andon](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/a/6aee6b7becb7d8c8da1901c677ee77cb5f2ffd33.jpeg)

---

<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: [2 December 2021 08:31 UTC](https://discourse.nodered.org/t/sqlite-error-with-node-red-on-docker/54618/2 "2021-12-02T08:31:30Z")

</div>

Is there a table called History\_Stop in your database?

---

<div class="post-metadata">

### Author: ![TROJAN053](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@TROJAN053](https://discourse.nodered.org/u/TROJAN053)
#### Post date: [2 December 2021 08:36 UTC](https://discourse.nodered.org/t/sqlite-error-with-node-red-on-docker/54618/4 "2021-12-02T08:36:48Z")

</div>

![History](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/9/c912dcbe879282c52e69ad78567a620fee000943.jpeg)  
Yes the table is alreay available. I have tested query for the other available table in the same database, but still error coming.

---

<div class="post-metadata">

### Author: ![hardillb](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/hardillb/32/12373_2.png) [@hardillb](https://discourse.nodered.org/u/hardillb)
#### Post date: [2 December 2021 08:41 UTC](https://discourse.nodered.org/t/sqlite-error-with-node-red-on-docker/54618/5 "2021-12-02T08:41:02Z")

</div>

How have you mounted the database into the docker container?

The container will be using unix paths, not Windows file paths.

---

<div class="post-metadata">

### Author: ![TROJAN053](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@TROJAN053](https://discourse.nodered.org/u/TROJAN053)
#### Post date: [2 December 2021 10:16 UTC](https://discourse.nodered.org/t/sqlite-error-with-node-red-on-docker/54618/6 "2021-12-02T10:16:19Z")

</div>

Hi hardillb,  
The database is not mounted on the docker.  
For docker path not cleared to me what you talking about.  
I have never used docker, my node red was already hosted by someone else.

---

<div class="post-metadata">

### Author: ![hardillb](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/hardillb/32/12373_2.png) [@hardillb](https://discourse.nodered.org/u/hardillb)
#### Post date: [2 December 2021 10:52 UTC](https://discourse.nodered.org/t/sqlite-error-with-node-red-on-docker/54618/7 "2021-12-02T10:52:18Z")

</div>

Docker containers have no access to files on the host system unless you explicitly share them with the container (and even then you will access them using a unix style path).

So the reason it says it can't find the table is because it has created a new empty SQLite database inside the container which contains no tables.

If the Node-RED images is being remotely hosted in somebody else's Docker environment then it definitely will not have any access to the SQLite file on your local machine.

---

<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: [31 January 2022 10:52 UTC](https://discourse.nodered.org/t/sqlite-error-with-node-red-on-docker/54618/8 "2022-01-31T10:52:53Z")

</div>

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