# Node Red Data doesn t store in sqlite

**URL:** <https://discourse.nodered.org/t/node-red-data-doesn-t-store-in-sqlite/1229>\
**Category:** General\
**Created:** [2 July 2018 06:16 UTC](https://discourse.nodered.org/t/node-red-data-doesn-t-store-in-sqlite/1229 "2018-07-02T06:16:36Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![YT2310](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/yt2310/32/35255_2.png) [@YT2310](https://discourse.nodered.org/u/YT2310)\
**Post date:** [2 July 2018 06:16 UTC](https://discourse.nodered.org/t/node-red-data-doesn-t-store-in-sqlite/1229/1 "2018-07-02T06:16:36Z")

</div>

Hello,  
I am using a sqlite databank to store a few datas in there and getting them into a dashboard.  
But after my Pi breakdown and reboot, the data are not store.

There is the following error in Node red: `" Error: SQLITE_ERROR: no search table: working values "`  
Is there any chance to save the datas Crash safely in the databank?

I hope the community can help me to fix this.

---

<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 July 2018 07:05 UTC](https://discourse.nodered.org/t/node-red-data-doesn-t-store-in-sqlite/1229/2 "2018-07-02T07:05:50Z")

</div>

> [@YT2310](#):
>
> There is the following error in Node red: `" Error: SQLITE_ERROR: no search table: working values "`

Is that a copy/paste of the error or have you retyped it? If you have retyped can you check it is absolutely correct please, it doesn't look right to me.

Either way what is the query that you are passing in that causes that error?

---

<div class="post-metadata">

**Author:** ![YT2310](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/yt2310/32/35255_2.png) [@YT2310](https://discourse.nodered.org/u/YT2310)\
**Post date:** [2 July 2018 07:22 UTC](https://discourse.nodered.org/t/node-red-data-doesn-t-store-in-sqlite/1229/3 "2018-07-02T07:22:34Z")

</div>

It is copy/paste (working values is my table)…  
The query is a timestamp which catch the datas from the databank and set them into my dashboard

---

<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 July 2018 07:50 UTC](https://discourse.nodered.org/t/node-red-data-doesn-t-store-in-sqlite/1229/4 "2018-07-02T07:50:56Z")

</div>

Interesting, I have never seen that error. “No such table” certainly, but not “No search table” and google doesn’t say anything helpful as far as I can see.

Check using another client (such as command line sqlite) that the table exists. If it does then feed the query into a debug node and paste the result here please (that is actually what I meant by asking what the query is).

---

<div class="post-metadata">

**Author:** ![YT2310](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/yt2310/32/35255_2.png) [@YT2310](https://discourse.nodered.org/u/YT2310)\
**Post date:** [2 July 2018 09:30 UTC](https://discourse.nodered.org/t/node-red-data-doesn-t-store-in-sqlite/1229/5 "2018-07-02T09:30:27Z")

</div>

okay i got my fault, after I reinstall sqlite, there was this error again, so i checked again my data base and just find a Syntax Problem, one of my names in the database has the same Name than a comand in SQL…

---

<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 July 2018 09:43 UTC](https://discourse.nodered.org/t/node-red-data-doesn-t-store-in-sqlite/1229/6 "2018-07-02T09:43:39Z")

</div>

So was the error really ‘no search table’?

---

<div class="post-metadata">

**Author:** ![YT2310](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/yt2310/32/35255_2.png) [@YT2310](https://discourse.nodered.org/u/YT2310)\
**Post date:** [2 July 2018 09:57 UTC](https://discourse.nodered.org/t/node-red-data-doesn-t-store-in-sqlite/1229/7 "2018-07-02T09:57:55Z")

</div>

yes but i doesn t come from node red it was from sqlite

---

<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 July 2018 10:49 UTC](https://discourse.nodered.org/t/node-red-data-doesn-t-store-in-sqlite/1229/8 "2018-07-02T10:49:10Z")

</div>

> [@YT2310](#):
>
> yes but i doesn t come from node red it was from sqlite

Yes, I realised that. I have never seen that message from sqlite.