# "Error: SQLITE\_ERROR: no such table: NCS"

**URL:** <https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037>\
**Category:** General\
**Created:** [26 August 2020 11:03 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037 "2020-08-26T11:03:51Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [26 August 2020 13:36 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/22 "2020-08-26T13:36:02Z")

</div>

linux ubuntu 16.04

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [26 August 2020 13:36 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/23 "2020-08-26T13:36:17Z")

</div>

no i am not using docker

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [26 August 2020 13:41 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/24 "2020-08-26T13:41:53Z")

</div>

Sir Thank you for this solution but still error is same

Error: SQLITE\_ERROR: no such table: NCS"

---

<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:** [26 August 2020 13:46 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/25 "2020-08-26T13:46:51Z")

</div>

I think the error speaks by itself.

1. Can you confirm the database path
2. the database table
3. whether there are any data in the database table in question with column `Person_ID`

---

<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:** [26 August 2020 13:54 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/27 "2020-08-26T13:54:25Z")

</div>

Can you open the database using the command line client and show the tables. Screenshot that showing the command you used to open the database please.

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [26 August 2020 14:12 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/28 "2020-08-26T14:12:28Z")

</div>

Sir I have checked the path can you tell how to check the path where Sqlite database is stored in linux.

---

<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:** [26 August 2020 14:15 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/29 "2020-08-26T14:15:25Z")

</div>

How did you open the database in your very first post and showed that you have 2 tables ?

```auto
sqlite> .tables
NCS NCS_DATABASE

```

1. show the command you used to open the db
2. which is the correct table NCS or NCS\_DATABASE ? 😅

i think .. the db path is correct .. try changing, in function node, your sql query instead NCS .. replace with NCS\_DATABASE. maybe you are using the wrong table.

... but confirm the above information !

---

<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:** [26 August 2020 14:37 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/30 "2020-08-26T14:37:15Z")

</div>

> [@UnborN](#):
>
> i think .. the db path is correct

There may be more than one db on the system.

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [26 August 2020 14:39 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/31 "2020-08-26T14:39:44Z")

</div>

yes i have changed that SQL query with NCS\_DATABASE.

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [26 August 2020 14:41 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/32 "2020-08-26T14:41:25Z")

</div>

but actually whenever I am injecting it is showing output ,but If i dont want to do inject manually,I mean by FOB mqtt code i am already passing that FOB ID then what i have to write in SQL to get the output.

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [26 August 2020 14:43 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/33 "2020-08-26T14:43:30Z")

</div>

it is showing me this while debugging

8/26/2020, 8:12:05 PM[node: Debug23](http://127.0.0.1:1880/?#)

SELECT Person\_ID FROM NCS\_DATABASE WHERE Person\_ID=' 0 4 2 2 2 4 3 6 ' : msg.payload : undefined

undefined

---

<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:** [26 August 2020 14:43 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/34 "2020-08-26T14:43:54Z")

</div>

> [@shipra](#):
>
> but actually whenever I am injecting it is showing output

So now you get a result ? its fixed ? no "no such table" error ?

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [26 August 2020 14:44 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/35 "2020-08-26T14:44:40Z")

</div>

yeaahhh no such error is coming.Thanks for that solution.  
But further i got stucked .help please.

---

<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:** [26 August 2020 14:49 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/36 "2020-08-26T14:49:52Z")

</div>

what is coming from your FOB MQTT .. paste the complete message and use

![](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/d/d56639561f3c9fa2f21f979311d7d4edcc5a9ef1.png)

---

<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:** [26 August 2020 15:00 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/37 "2020-08-26T15:00:19Z")

</div>

.. im guessing, a 'person id' is being passed with MQTT and you want to search the db based on that id ?  
we need to know the complete structure of the FOB MQTT message

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [26 August 2020 15:00 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/38 "2020-08-26T15:00:46Z")

</div>

yes sir correct .

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [26 August 2020 15:01 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/39 "2020-08-26T15:01:37Z")

</div>

```auto
[
    {
        "id": "4ee90eec.77d9f",
        "type": "mqtt in",
        "z": "a0a22bbe.4dd42",
        "name": "",
        "topic": "FOB",
        "qos": "2",
        "datatype": "auto",
        "broker": "3d22a2f.7bec8de",
        "x": 130,
        "y": 140,
        "wires": [
            [
                "d9dae4cd.dd58b8",
                "2862d90b.82b8b6"
            ]
        ]
    },
    {
        "id": "3d22a2f.7bec8de",
        "type": "mqtt-broker",
        "z": "",
        "name": "",
        "broker": "tcp://mqtt.eclipse.org",
        "port": "1883",
        "clientid": "NCS_Client03",
        "usetls": false,
        "compatmode": true,
        "keepalive": "60",
        "cleansession": true,
        "birthTopic": "",
        "birthQos": "0",
        "birthPayload": "",
        "closeTopic": "",
        "closeQos": "0",
        "closePayload": "",
        "willTopic": "",
        "willQos": "0",
        "willPayload": ""
    }
]

```

---

<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:** [26 August 2020 15:05 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/40 "2020-08-26T15:05:15Z")

</div>

.. we needed the mqtt message not the flow 😉

This is your MQTT msg :

```auto
{"topic":"FOB","payload":" 0 4 2 2 2 4 3 6 ","qos":2,"retain":false,"_msgid":"23a61276.129afe"}

```

so the mqtt payload has spaces in ? maybe it will need some processing because the db table may not have spaces between the numbers. Can you confirm ?

@Colin will this work? .. msg.payload.replace(" ", "");

---

<div class="post-metadata">

**Author:** ![shipra](https://avatars.discourse-cdn.com/v4/letter/s/71c47a/32.png) [@shipra](https://discourse.nodered.org/u/shipra)\
**Post date:** [26 August 2020 15:11 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/41 "2020-08-26T15:11:06Z")

</div>

yes mqtt has spaces

---

<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:** [26 August 2020 15:11 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037/42 "2020-08-26T15:11:47Z")

</div>

and the database it has spaces on not ?

[Previous page](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037.md?page=1)

[Next page](https://discourse.nodered.org/t/error-sqlite-error-no-such-table-ncs/32037.md?page=3)