# What should i do

**URL:** <https://discourse.nodered.org/t/what-should-i-do/36259>\
**Category:** General\
**Created:** [20 November 2020 18:23 UTC](https://discourse.nodered.org/t/what-should-i-do/36259 "2020-11-20T18:23:37Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![p03920](https://avatars.discourse-cdn.com/v4/letter/p/58956e/32.png) [@p03920](https://discourse.nodered.org/u/p03920)\
**Post date:** [20 November 2020 18:23 UTC](https://discourse.nodered.org/t/what-should-i-do/36259/1 "2020-11-20T18:23:37Z")

</div>

i don't know......this error bothering me.....  
and my codes. where is wrong??? i don't know plz help me...

 ![KakaoTalk_20201121_031411239_01](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/a/1a6da4a57c404ffd40be34afee7fff905a034eeb.jpeg) ![KakaoTalk_20201121_031411239_04](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/3/d/3d56c151617c15f99e0531d11b2653963de4dea4.jpeg)

---

<div class="post-metadata">

**Author:** ![p03920](https://avatars.discourse-cdn.com/v4/letter/p/58956e/32.png) [@p03920](https://discourse.nodered.org/u/p03920)\
**Post date:** [20 November 2020 18:24 UTC](https://discourse.nodered.org/t/what-should-i-do/36259/2 "2020-11-20T18:24:14Z")

</div>

![KakaoTalk_20201121_031411239_02](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/a/fa1325bc4b48b4fc01fc4ce71ad7bfc94a2c4b3c.jpeg) ![KakaoTalk_20201121_031411239_03](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/c/6cb11a3084673864ccd5c1feb04f06771ad59c7f.jpeg)

---

<div class="post-metadata">

**Author:** ![p03920](https://avatars.discourse-cdn.com/v4/letter/p/58956e/32.png) [@p03920](https://discourse.nodered.org/u/p03920)\
**Post date:** [20 November 2020 18:24 UTC](https://discourse.nodered.org/t/what-should-i-do/36259/3 "2020-11-20T18:24:55Z")

</div>

![KakaoTalk_20201121_031754313](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/0/b033c21c38d3f8ede1a200dae204b7aa3e172031.jpeg)

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [20 November 2020 18:33 UTC](https://discourse.nodered.org/t/what-should-i-do/36259/4 "2020-11-20T18:33:28Z")

</div>

You have an extra single quote in this INSERT query...  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/9/f92c156b5e398a213ae0ff92b9b12c2d3e2a705e.jpeg)

Some node, somewhere in your flows is feeding a msg into a node called `iotdb` and is sending an invalid SQL INSERT statement where the 2nd last value contains an extra single quote.

With only photographs provided, it is almost impossible to help further.

---

<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:** [19 January 2021 18:33 UTC](https://discourse.nodered.org/t/what-should-i-do/36259/5 "2021-01-19T18:33:40Z")

</div>

Closed on 19 January 2021 18:33 UTC

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