# General

**URL:** https://discourse.nodered.org/c/general/7.md?page=571

[Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md)

**Page:** 572

---

## [SQLite table deleting over night, any advice!](https://discourse.nodered.org/t/sqlite-table-deleting-over-night-any-advice/43755)

<div class="topic-metadata">

**Author:** [@Dgillett](https://discourse.nodered.org/u/Dgillett)\
**Replies:** 28\
**Last updated:** [13 April 2021 14:55 UTC](https://discourse.nodered.org/t/sqlite-table-deleting-over-night-any-advice/43755 "2021-04-13T14:55:23Z")

</div>

So I have created a MQTT data tracking system using node red, and storing the data into SQLite. The issue I'm having is after I create the SQLite table and data starts logging, I go home for the day, when I come back I …

---

## [Node-RED is crashing after startup](https://discourse.nodered.org/t/node-red-is-crashing-after-startup/44106)

<div class="topic-metadata">

**Author:** [@AleCaste18](https://discourse.nodered.org/u/AleCaste18)\
**Replies:** 5\
**Last updated:** [13 April 2021 14:30 UTC](https://discourse.nodered.org/t/node-red-is-crashing-after-startup/44106 "2021-04-13T14:30:46Z")

</div>

Hi node-RED forum, I'm having trouble in launching node-RED. I have installed this module but i'm failing in unistalling it both using the npm command or lookin for it in the file manager. Pasting here the error in o…

---

## [SQLite Error: UNIQUE constraint failed](https://discourse.nodered.org/t/sqlite-error-unique-constraint-failed/43758)

<div class="topic-metadata">

**Author:** [@Samira05](https://discourse.nodered.org/u/Samira05)\
**Replies:** 33\
**Last updated:** [13 April 2021 12:23 UTC](https://discourse.nodered.org/t/sqlite-error-unique-constraint-failed/43758 "2021-04-13T12:23:34Z")

</div>

Good day everyone, i dont know where is false that i cannot show infos in DB in my tempelate. (i explain that i want to insert my csv.file to DB and then show Infos from DB) \[{"id":"68a0a347.56efbc","type":"tab","labe…

---

## [Displaying the value above the node](https://discourse.nodered.org/t/displaying-the-value-above-the-node/44088)

<div class="topic-metadata">

**Author:** [@jake123](https://discourse.nodered.org/u/jake123)\
**Replies:** 4\
**Last updated:** [13 April 2021 11:18 UTC](https://discourse.nodered.org/t/displaying-the-value-above-the-node/44088 "2021-04-13T11:18:47Z")

</div>

Is there a way to display the value of the node above the node itself. Lets say u have inject node set to boolean(true). Is there a way or a node that will display the msg.payload above the node. Something like thi…

---

## [I think, this question is beyond NR, but asking anyway?](https://discourse.nodered.org/t/i-think-this-question-is-beyond-nr-but-asking-anyway/44074)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 5\
**Last updated:** [13 April 2021 11:03 UTC](https://discourse.nodered.org/t/i-think-this-question-is-beyond-nr-but-asking-anyway/44074 "2021-04-13T11:03:53Z")

</div>

I think, this question is beyond NR, but asking anyway? So, trying to web page scrap dynamic content is just possible within NR? At least I don't see how a GET via http request/response can invoke dynamic content. Jus…

---

## [Fix worldmap marker location from the field device realtime data](https://discourse.nodered.org/t/fix-worldmap-marker-location-from-the-field-device-realtime-data/44031)

<div class="topic-metadata">

**Author:** [@djar](https://discourse.nodered.org/u/djar)\
**Replies:** 4\
**Last updated:** [13 April 2021 10:02 UTC](https://discourse.nodered.org/t/fix-worldmap-marker-location-from-the-field-device-realtime-data/44031 "2021-04-13T10:02:24Z")

</div>

Hello, I am new using Node-RED, I have a problem with fixing marker in Worldmap node with using a realtime data. I can solve it if I directly write the number of lat and lon and feed them to worldmap-UI through a funct…

---

## [Node-RED projects + uibuilder: How to include installation of vue, bootstrap, bootstrap-vue?](https://discourse.nodered.org/t/node-red-projects-uibuilder-how-to-include-installation-of-vue-bootstrap-bootstrap-vue/43898)

<div class="topic-metadata">

**Author:** [@NoMercyMike](https://discourse.nodered.org/u/NoMercyMike)\
**Replies:** 2\
**Last updated:** [13 April 2021 09:52 UTC](https://discourse.nodered.org/t/node-red-projects-uibuilder-how-to-include-installation-of-vue-bootstrap-bootstrap-vue/43898 "2021-04-13T09:52:53Z")

</div>

Hi, I've build a very simply CI/CD pipeline (Jira, Gitlab, Node-RED) for developing my flows and dashboards. In my dev stage (local docker container) I'm using Node-RED projects to keep everything under version control…

---

## [Node Red logging](https://discourse.nodered.org/t/node-red-logging/44090)

<div class="topic-metadata">

**Author:** [@mich3000](https://discourse.nodered.org/u/mich3000)\
**Replies:** 0\
**Last updated:** [13 April 2021 09:20 UTC](https://discourse.nodered.org/t/node-red-logging/44090 "2021-04-13T09:20:39Z")

</div>

Is there any setting i can set to get msgId also for standard logging not only in metric? Thanks {"level":99,"nodeid":"14e2db35.664b55","event":"node.debug.receive","msgid":"d9c14011.84d75","timestamp":1618304414264} i…

---

## [Add column headers to CSV file](https://discourse.nodered.org/t/add-column-headers-to-csv-file/15062)

<div class="topic-metadata">

**Author:** [@hathemi](https://discourse.nodered.org/u/hathemi)\
**Replies:** 12\
**Last updated:** [13 April 2021 08:21 UTC](https://discourse.nodered.org/t/add-column-headers-to-csv-file/15062 "2021-04-13T08:21:14Z")

</div>

i want t create a csv file with header i follow this example but doesn't work. i always find the header's names in one cell ? \[{"id":"1993503b.2a2d88","type":"fs-ops-access","z":"456ce3eb.038f9c","name":"","path":"meas…

---

## [Convert Date Time to Unix time](https://discourse.nodered.org/t/convert-date-time-to-unix-time/19787)

<div class="topic-metadata">

**Author:** [@mitchdennis](https://discourse.nodered.org/u/mitchdennis)\
**Replies:** 4\
**Last updated:** [13 April 2021 08:10 UTC](https://discourse.nodered.org/t/convert-date-time-to-unix-time/19787 "2021-04-13T08:10:23Z")

</div>

Hi all I have a message output being read from a CSV file that is in this format "GPS Time: "Sun Dec 01 08:50:14 PST 2019".Does anybody know how to convert it to a Unix time. Thanks Dennis Mitchell

---

## [How do you convert a 10 digit unix time](https://discourse.nodered.org/t/how-do-you-convert-a-10-digit-unix-time/12474)

<div class="topic-metadata">

**Author:** [@nodecentral](https://discourse.nodered.org/u/nodecentral)\
**Replies:** 2\
**Last updated:** [13 April 2021 08:09 UTC](https://discourse.nodered.org/t/how-do-you-convert-a-10-digit-unix-time/12474 "2021-04-13T08:09:01Z")

</div>

Hi, I’m trying to pull content from an online EPG, and the Start and Stop times of programmes look to only be 10 digits long, and I can’t seem to use a date time converter node e.g. Moment to convert them ? When I do …

---

## [HELP : IBM cloud lite : Node red app not available in "cloud foundry apps" after Deployed](https://discourse.nodered.org/t/help-ibm-cloud-lite-node-red-app-not-available-in-cloud-foundry-apps-after-deployed/44078)

<div class="topic-metadata">

**Author:** [@moezmtk](https://discourse.nodered.org/u/moezmtk)\
**Replies:** 0\
**Last updated:** [13 April 2021 06:28 UTC](https://discourse.nodered.org/t/help-ibm-cloud-lite-node-red-app-not-available-in-cloud-foundry-apps-after-deployed/44078 "2021-04-13T06:28:07Z")

</div>

Help, I 'm using IBM Cloud lite to deploy node red but after i deployed it ,it didn't appear in "cloud foundry apps " in " Resource List " after long time of waiting.

---

## [Email getting rejected with 550 Messages should have one or no Content-Type headers, not 2](https://discourse.nodered.org/t/email-getting-rejected-with-550-messages-should-have-one-or-no-content-type-headers-not-2/44067)

<div class="topic-metadata">

**Author:** [@chrisn-au](https://discourse.nodered.org/u/chrisn-au)\
**Replies:** 5\
**Last updated:** [12 April 2021 23:27 UTC](https://discourse.nodered.org/t/email-getting-rejected-with-550-messages-should-have-one-or-no-content-type-headers-not-2/44067 "2021-04-12T23:27:38Z")

</div>

Hi, Over the last week or so I have been getting an error for some emails sent with the email node to an outlook server. I am getting a bounce on the email with The response from the remote server was: 550 Messages sh…

---

## [USB RFID Reader and Pi keyboard Node](https://discourse.nodered.org/t/usb-rfid-reader-and-pi-keyboard-node/44063)

<div class="topic-metadata">

**Author:** [@ttavlis](https://discourse.nodered.org/u/ttavlis)\
**Replies:** 3\
**Last updated:** [12 April 2021 21:48 UTC](https://discourse.nodered.org/t/usb-rfid-reader-and-pi-keyboard-node/44063 "2021-04-12T21:48:09Z")

</div>

Dear all, I have a simple setup where I use a generic USB RFID Reader (as this ) one) to read a RFID card and "do stuff" (yes, play some music in sonos). The PI Keyboard Node gets the ID of the card, which is 10 charac…

---

## [Toggle lights with different states](https://discourse.nodered.org/t/toggle-lights-with-different-states/44062)

<div class="topic-metadata">

**Author:** [@mr.B](https://discourse.nodered.org/u/mr.B)\
**Replies:** 1\
**Last updated:** [12 April 2021 20:37 UTC](https://discourse.nodered.org/t/toggle-lights-with-different-states/44062 "2021-04-12T20:37:32Z")

</div>

Hi, I'm looking for an easy way to know whether at least one light in a light group has the state 'on'. This is because I want to toggle multiple lights with one single button, but without using a toggle function. (beca…

---

## [Node-Red 1.3.1 and sqlite3 again](https://discourse.nodered.org/t/node-red-1-3-1-and-sqlite3-again/43933)

<div class="topic-metadata">

**Author:** [@scargill](https://discourse.nodered.org/u/scargill)\
**Replies:** 27\
**Last updated:** [12 April 2021 20:00 UTC](https://discourse.nodered.org/t/node-red-1-3-1-and-sqlite3-again/43933 "2021-04-12T20:00:18Z")

</div>

Up to NR 1.2.9 I had everything installing and updating perfectly.... but here we go again - the Pi NR upgrade script - upgraded to NR 1.3.1 - the update reported issues with the serial port, i2c and sqlite3. I reinstall…

---

## [Bitwise operator issue](https://discourse.nodered.org/t/bitwise-operator-issue/44006)

<div class="topic-metadata">

**Author:** [@vlturner](https://discourse.nodered.org/u/vlturner)\
**Replies:** 7\
**Last updated:** [12 April 2021 18:53 UTC](https://discourse.nodered.org/t/bitwise-operator-issue/44006 "2021-04-12T18:53:52Z")

</div>

I am having a meltdown on something simple. I am trying to route the odd and even numbers through two paths of a function. I seem to have my code not operating as expected. \[{"id":"f8ce0fa1.b745e8","type":"inject",…

---

## [Injecting basic object in template node with little landing page retrieve \[object Object\] and I don't understand why](https://discourse.nodered.org/t/injecting-basic-object-in-template-node-with-little-landing-page-retrieve-object-object-and-i-dont-understand-why/44052)

<div class="topic-metadata">

**Author:** [@vongomben](https://discourse.nodered.org/u/vongomben)\
**Replies:** 1\
**Last updated:** [12 April 2021 17:41 UTC](https://discourse.nodered.org/t/injecting-basic-object-in-template-node-with-little-landing-page-retrieve-object-object-and-i-dont-understand-why/44052 "2021-04-12T17:41:30Z")

</div>

Hi. I don't understand why, if I inject an object in a template node, I cannot seem to access its payload from the node itself, I just see \[object Object\] How can I have the contet of this html page more dynamic and in…

---

## [Mqtts instead of mqtt on PubSubClient library](https://discourse.nodered.org/t/mqtts-instead-of-mqtt-on-pubsubclient-library/44039)

<div class="topic-metadata">

**Author:** [@saeed1](https://discourse.nodered.org/u/saeed1)\
**Replies:** 1\
**Last updated:** [12 April 2021 17:16 UTC](https://discourse.nodered.org/t/mqtts-instead-of-mqtt-on-pubsubclient-library/44039 "2021-04-12T17:16:20Z")

</div>

Hello Guys, i am afraid mybe its not completely relevant for this forum but i am posting it here, as its the most helpful forum. I was sending data from my raspberry pi (client) to my remote server via mqtts (8883). On…

---

## [TypeError: Cannot read property 'log' of undefined](https://discourse.nodered.org/t/typeerror-cannot-read-property-log-of-undefined/43959)

<div class="topic-metadata">

**Author:** [@cope](https://discourse.nodered.org/u/cope)\
**Replies:** 11\
**Last updated:** [12 April 2021 16:39 UTC](https://discourse.nodered.org/t/typeerror-cannot-read-property-log-of-undefined/43959 "2021-04-12T16:39:31Z")

</div>

I upgraded to 1.3.1 and now I cannot read my homeseer devices any more. The server is declared all right and the Device and Feature are found by the node. The Device is in a red box??? Any idea how to solve this pr…

---

## [Update last row of InfluxDB database](https://discourse.nodered.org/t/update-last-row-of-influxdb-database/44030)

<div class="topic-metadata">

**Author:** [@MrWolff](https://discourse.nodered.org/u/MrWolff)\
**Replies:** 7\
**Last updated:** [12 April 2021 15:35 UTC](https://discourse.nodered.org/t/update-last-row-of-influxdb-database/44030 "2021-04-12T15:35:09Z")

</div>

Hi everybody, I have made flow where I store data into a InfluxDB database. I have the following problem: When the machine stops running, the downtime starts. I insert the start time to the database. (see picture) Wh…

---

## [Change node in v1.3.0 not working](https://discourse.nodered.org/t/change-node-in-v1-3-0-not-working/44011)

<div class="topic-metadata">

**Author:** [@grant1](https://discourse.nodered.org/u/grant1)\
**Replies:** 7\
**Last updated:** [12 April 2021 15:28 UTC](https://discourse.nodered.org/t/change-node-in-v1-3-0-not-working/44011 "2021-04-12T15:28:23Z")

</div>

Last week I was running v1.2.9 (I think) and my flow worked great. I updated to 1.3 now and for some reason the Change nodes used in my flow have the red triangle, which I understand means an error in the config. When …

---

## [Ewelink state cant be showed](https://discourse.nodered.org/t/ewelink-state-cant-be-showed/44036)

<div class="topic-metadata">

**Author:** [@funhall](https://discourse.nodered.org/u/funhall)\
**Replies:** 0\
**Last updated:** [12 April 2021 14:15 UTC](https://discourse.nodered.org/t/ewelink-state-cant-be-showed/44036 "2021-04-12T14:15:57Z")

</div>

Have anybody solved the problem with the status?. I cant get the status when I toggle the power state Node. I dont get the OK status but only Toggle....

---

## [Txt or csv file on smb/nas](https://discourse.nodered.org/t/txt-or-csv-file-on-smb-nas/43990)

<div class="topic-metadata">

**Author:** [@biros](https://discourse.nodered.org/u/biros)\
**Replies:** 4\
**Last updated:** [12 April 2021 12:59 UTC](https://discourse.nodered.org/t/txt-or-csv-file-on-smb-nas/43990 "2021-04-12T12:59:38Z")

</div>

Hello, I have a nas on my network and i would like to edit a csv file on the nas. Is there a similar node or combination of nodes which could do the "append to file" action, but on a network level? The smb node works q…

---

## [Deploying Node-RED to Heroku](https://discourse.nodered.org/t/deploying-node-red-to-heroku/43999)

<div class="topic-metadata">

**Author:** [@StudentStrange](https://discourse.nodered.org/u/StudentStrange)\
**Replies:** 0\
**Last updated:** [11 April 2021 18:05 UTC](https://discourse.nodered.org/t/deploying-node-red-to-heroku/43999 "2021-04-11T18:05:14Z")

</div>

Hi there, I built a Node-RED application lately for my IoT project. Basically, this just includes some simple nodes like node-red-dashboard or node-red-contrib-mqtt-broker which are used for connecting with a server tha…

---

## [Electron-node-red no dashboard](https://discourse.nodered.org/t/electron-node-red-no-dashboard/43978)

<div class="topic-metadata">

**Author:** [@superace](https://discourse.nodered.org/u/superace)\
**Replies:** 3\
**Last updated:** [11 April 2021 08:32 UTC](https://discourse.nodered.org/t/electron-node-red-no-dashboard/43978 "2021-04-11T08:32:30Z")

</div>

Hi I am trying to get Electron to build an AppImage using https://github.com/dceejay/electron-node-red .I have managed to get it running but only if I have "NRelectron-editable-true" as option. This will copy the flow f…

---

## [(adminAuth) unable to login node-red](https://discourse.nodered.org/t/adminauth-unable-to-login-node-red/7074)

<div class="topic-metadata">

**Author:** [@pangda](https://discourse.nodered.org/u/pangda)\
**Replies:** 45\
**Last updated:** [11 April 2021 07:12 UTC](https://discourse.nodered.org/t/adminauth-unable-to-login-node-red/7074 "2021-04-11T07:12:24Z")

</div>

my problem is unable to login in node-red.the node-red is normal running if remove the adminAuth in setting.js files. But if I set adminAuth in setting.js file with username/password:admin/admin then I restart the…

---

## [RunTime Problem](https://discourse.nodered.org/t/runtime-problem/43911)

<div class="topic-metadata">

**Author:** [@valbuz](https://discourse.nodered.org/u/valbuz)\
**Replies:** 6\
**Last updated:** [10 April 2021 18:26 UTC](https://discourse.nodered.org/t/runtime-problem/43911 "2021-04-10T18:26:54Z")

</div>

Hi. i have two systems running on proxmox (in diff. Containers). the Installation is ioBroker and NodeRed. With one system i have sometimes Problems with NodeRed. It restart's everytime. I found something like error …

---

## [German translation - anyone interested?](https://discourse.nodered.org/t/german-translation-anyone-interested/38209)

<div class="topic-metadata">

**Author:** [@joerg\_w](https://discourse.nodered.org/u/joerg_w)\
**Replies:** 9\
**Last updated:** [10 April 2021 17:29 UTC](https://discourse.nodered.org/t/german-translation-anyone-interested/38209 "2021-04-10T17:29:13Z")

</div>

We just started a new attempt translating major parts of the UI. Just wondering if someone wants to support this - translating, reviewing, commenting - anyone is welcome. Discussion will be held on the #i18n-de Slack c…

---

## [Time Home Assistant KNX](https://discourse.nodered.org/t/time-home-assistant-knx/43774)

<div class="topic-metadata">

**Author:** [@Ives25](https://discourse.nodered.org/u/Ives25)\
**Replies:** 7\
**Last updated:** [10 April 2021 11:34 UTC](https://discourse.nodered.org/t/time-home-assistant-knx/43774 "2021-04-10T11:34:17Z")

</div>

Hello, I am using Node-RED in Home assistant and I want to write the time in an ETS group (GA) address. The time value is retrieved via the HA interface in an "input\_datetime.heure" entity The following flow works but…

[Previous page](https://discourse.nodered.org/c/general/7.md?page=570)

[Next page](https://discourse.nodered.org/c/general/7.md?page=572)